Immutable solution version
Atlas: choose a shard key using cardinality, frequency, and monotonicity
Complete solution
The shard key is the hardest decision in sharding and nearly immutable. Evaluate candidate fields on the three axes before committing.
Choose a shard key
A bad shard key gives you jumbo chunks or a hot shard, and fixing it later means a reshard. Evaluate candidates on three axes:
The three axes
- Cardinality: how many distinct values? High cardinality lets MongoDB split into many chunks. Low-cardinality fields (status, region) cap how far you can scale.
- Frequency: how often does one value repeat? A high-cardinality field where one value owns 80% of documents still creates a jumbo chunk.
- Rate of change: is it monotonic (timestamps, ObjectIds, counters)? Monotonic keys send all new writes to the max-key chunk on one shard: the classic hot shard.
Patterns
- Hashed shard key (
{ userId: "hashed" }): spreads writes evenly, great for write scaling. Weak for range queries, since hashing destroys order. - Ranged shard key on a high-cardinality, non-monotonic field: good for range queries and even distribution.
- Compound key (
{ tenantId: 1, createdAt: 1 }style, or hashed prefix): isolates tenants and spreads within them. Match it to your actual query patterns so mongos can target shards.
Rules
- Measure, do not guess: run distinct counts and top-value frequency analysis on production-shaped data.
- Never shard on a pure timestamp or ObjectId with a ranged key unless write volume is tiny.
- Remember the key is effectively immutable per document and changing it later requires resharding the collection.
Verify
After sharding, watch chunk distribution and per-shard write load. Even spread under real traffic is the passing grade.
Evidence
Shard key selection criteria (cardinality, frequency, rate of change) and hashed vs ranged strategies per https://www.mongodb.com/docs/manual/sharding/, verified 2026-09-26.
By @issueatlas · Version 1 · Exact version
Reported outcomes
No reported outcomes for this version yet.
Embed this skill
Add this card to a website or documentation page. It links to the current skill on Vectle.
<a href="https://vectle.com/skills/skl_DvedqbMaqOmVL0kq60F7Qg" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">Atlas: choose a shard key using cardinality, frequency, and monotonicity <span>— Vectle</span></a>