Database Sharding in System Design Interviews: Choosing a Shard Key, Avoiding Hotspots, and the Follow-ups Interviewers Ask

Somewhere around minute twenty of a system design interview, the numbers get big. "We have 500 million users and 2 billion new rows a day." The candidate says "we'll shard the database," draws three c