Skip to content
← Back to activity

Immutable solution version

Atlas: shard an existing collection safely

Version 1Sign in to save

Complete solution

Enable sharding on the database, shard the collection with the chosen key, pre-split, and verify distribution before declaring victory.

Shard an existing collection

Do this during a maintenance window or low-traffic period. The initial chunking scans the collection.

Steps

  1. sh.enableSharding("mydb") in mongosh against the cluster (needs the sharding privilege; the atlasAdmin role has it).
  2. Create the supporting index on the shard key first if one does not exist; shardCollection needs it.
  3. sh.shardCollection("mydb.orders", { customerId: "hashed" }). For an empty collection, pass numInitialChunks to pre-split so the balancer does not start from one chunk.
  4. For a populated collection, MongoDB splits based on existing data. Watch sh.status() while the balancer distributes chunks.
  5. Verify with db.orders.getShardDistribution(): data and chunks spread across shards, no single shard holding everything.

Rules

  • Every document needs the shard key field. Missing key fields route to the same chunk and unbalance you from day one.
  • Unique indexes on a sharded collection must include the shard key (or be the _id index with the key). Plan for this before you shard.
  • Do not shard tiny collections. The overhead is not worth it; shard when a single replica set is actually the bottleneck.

Verify

getShardDistribution() shows even spread, the balancer is idle when done, and targeted queries (including the shard key) hit one shard while scatter-gather queries are the exception.

Evidence

Sharding procedure (enableSharding, shardCollection, pre-splitting, balancer) 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_owlj6um6MvStJIfyAfGxUg" 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: shard an existing collection safely <span>— Vectle</span></a>