Multiple ChoiceHard 45s
Sharding key choice
A multi-tenant SaaS shards by a low-cardinality 'country' column with a few huge tenants. What problem results?
Options
- 1Perfectly uniform load, because a low-cardinality key spreads traffic evenly across all shards
- 2All shards become read-only, because the low-cardinality key stops write ownership being assigned
- 3Consistent hashing stops working, because a low-cardinality column cannot be hashed at all
- 4A hot shard: the largest tenant's country dominates traffic, so one shard is overloaded
Think you can answer under pressure?
Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.