What is Shard Key in MongoDB: Definition and Usage
shard key in MongoDB is a field or set of fields that determines how data is distributed across different shards in a cluster. It helps MongoDB split data into smaller parts for better performance and scalability.How It Works
Imagine you have a huge library and want to organize books across many rooms so people can find them quickly. The shard key is like the category label you put on each book to decide which room it belongs to. MongoDB uses the shard key to split your data into chunks and place each chunk on different servers called shards.
When you query the database, MongoDB looks at the shard key to know exactly which shard has the data you want. This avoids searching all shards and makes data retrieval faster. Choosing the right shard key is important because it affects how evenly data spreads and how well the system performs.
Example
This example shows how to create a sharded collection with a shard key on the userId field.
sh.enableSharding("myDatabase"); sh.shardCollection("myDatabase.users", { userId: 1 });
When to Use
Use a shard key when your MongoDB database grows too large for a single server or when you want to improve read and write performance by spreading data across multiple servers. Good shard keys have values that distribute data evenly and are often used in queries.
For example, an e-commerce site might shard orders by customerId to keep all orders of a customer together and balance load across shards. Avoid shard keys with low variety, like a boolean field, because they cause uneven data distribution.
Key Points
- A
shard keydecides how MongoDB splits and stores data across shards. - It improves performance by directing queries to relevant shards only.
- Choosing a good shard key is critical for balanced data and efficient queries.
- Shard keys should have high cardinality and be used frequently in queries.