Part 1 of 8 · 1 min read
Why this page closes the level
In this module you will
- State what makes a shard key good: even spread, queries that stay on one shard, and no hot keys.
- Choose a shard key for users, orders, messages and time series, and defend the choice with numbers.
- Predict which queries become single-shard and which become scatter/gather for a given key.
- Handle joins, the celebrity problem and resharding when the key turns out to be wrong.
- Use a checklist to review a sharding plan in an interview.
Everything in this level meets here. The shard key decides where data lives, which queries are cheap, where the hot spots appear and how painful it is to change later. It is often the first design question in a case study. The tier is Core. The numbers are made up to show the idea, unless the text names a book.