How to reshard a collection?

Q: How to reshard a collection?

Ensure you're running MongoDB 5.0 or newer. Make sure the cluster has sufficient resources and minimal workload to support the resharding process. You must initiate the process by running a command. Carefully choose the new shard key, considering factors like query patterns, data distribution, and write loads. db.adminCommand({ reshardCollection: "databaseName.collectionName", key: { fieldName1: 1, fieldName2: -1 }, // New shard key unique: false // Set to true if shard key values must be unique });

Difficulty: 7/10

shard key selection, resharding process, balancer behavior

Resharding a collection in MongoDB involves changing the shard key. While MongoDB does not directly allow modifying the shard key for an existing collection, starting from version 5.0, MongoDB provides a process to reshard a collection.

1
Ensure you're running MongoDB 5.0 or newer.
2
Make sure the cluster has sufficient resources and minimal workload to support the resharding process.
3
You must initiate the process by running a command.
4
Carefully choose the new shard key, considering factors like query patterns, data distribution, and write loads.

javascript

Scenario Questions

0-2 years experience

2-5 years experience

1During a recent rollout we attempted to reshard a large orders collection and observed the balancer getting stuck. Walk me through how you would diagnose and resolve the issue.

Follow-up Questions