What makes a good shard key?
Answer from the constraint
A good key spreads writes, supports dominant access patterns, avoids hot tenants, and leaves a credible migration and rebalancing path.
A useful response structure
- Name the user-visible requirement or invariant.
- Choose the simplest decision that protects it.
- State the cost and the likely failure mode.
- Give one observable trigger for changing the design.