Say it like this
- We need to shard the user database.
- Let's implement sharding to scale horizontally.
- Which shard key should we use for sharding?
Use it at work
Scaling
- We'll need sharding when the database hits 5 TB.
- We shard users by region.
Debugging
- This query hits every shard. That's why it's slow.
- One shard is much bigger than the others.
Design
- What's the shard key?
- Sharding makes cross-user queries hard.
Don't say this
Sharding is a noun; the verb is to implement sharding, not to sharding.
Don't mix it up
| Term | What it is | Who writes or uses it | When |
|---|---|---|---|
| sharding | Splitting data across databases | Engineers, DBAs | Very large data |
| partitioning | Splitting a table inside one database | DBAs | Large tables |
| replication | Copying data | DBAs | Reliability |
Practice
Try it
4 quick exercises
1. To handle our growing user base, we decided to implement _______ on the user database by geographic region.
2. Which sentence uses sharding incorrectly?
3. Your team is discussing database scaling. Which sounds most natural?
4. Rewrite this using sharding: 'We are going to split our data across many different database servers based on which region each user is from.'
Say it out loud
Phrase 1 of 3
"We need to shard the user database."
We don't save your recording. The word check uses your browser's speech recognition.
More about sharding
Real examples(3)
- in a standup
"We're planning to implement sharding on our customer table because we're hitting the 100 million row limit."
- in a code review
"This query assumes all data is on one shard, so it will fail once we enable sharding."
- in a team meeting
"Sharding by user ID makes sense here because our reads and writes are mostly user-specific."
More mistakes(2)
Handle with care. Sharding is a database-specific term; do not confuse it with partitioning (which is broader) or replication (which copies data). Do not use as a verb to mean general splitting.
- ✕Sharding and partitioning are the same thing.✓Sharding is a type of partitioning that distributes data across multiple servers.
Partitioning is broader and includes single-server techniques; sharding always involves multiple servers.
- ✕We use sharding for backup and disaster recovery.✓We use replication for backup and disaster recovery.
Sharding is for scaling, not backup; replication duplicates data for resilience.
Other forms(2)
- sharding noun
"Sharding allows us to scale our database horizontally across multiple servers."
- shard noun
"Each shard contains data for a specific range of user IDs."
Often used with(4)
- shard key · The field used to determine which shard stores each record; commonly used together as shard key selection or choosing a shard key.
- implement sharding · Standard phrase meaning to put sharding into practice; very common in technical discussions.
- horizontal scaling · Sharding is a form of horizontal scaling; these terms often appear together in architecture discussions.
- distributed database · Sharding creates a distributed database; these concepts are closely related.
Similar words(2)
- data partitioning · Broader term; partitioning can be on a single server, but sharding always spans multiple servers.
- horizontal scaling · Describes the approach; sharding is the specific technique used for horizontal scaling.
Opposites(3)
- vertical scaling
- replication
- monolithic database
Questions(5)
- What does sharding mean in software engineering?
- Sharding is a database scaling technique where data is split and distributed across multiple independent database servers. Each server (called a shard) stores a subset of the data based on a shard key, such as user ID or geographic location. This allows systems to handle much larger datasets and higher query throughput than a single database server could manage alone.
- How do you use sharding in a sentence at work?
- You typically use sharding as a noun in context like: 'We are implementing sharding to scale our database,' or 'The shard key for sharding is user ID.' You would not use it as a verb by saying 'we are sharding the database'—instead say 'we are implementing sharding on the database.'
- Is sharding formal or informal?
- Sharding is neutral and professional. It appears in formal architecture documents, technical RFCs, and casual team conversations equally. The term is standard in the tech industry and appropriate for all contexts—standup meetings, code reviews, job interviews, and written documentation.
- What is the difference between sharding and replication?
- Sharding divides data across multiple servers so each server holds a different subset (scaling for capacity), while replication copies the same data to multiple servers (for redundancy and availability). You might use both together: sharded data that is also replicated for fault tolerance.
- How do I choose a shard key?
- Choose a shard key based on how your application queries data. It should evenly distribute data across shards to avoid hotspots, and queries should typically access only one shard. Common shard keys are user ID, customer ID, or geographic region—fields that reflect your application's access patterns.
