System Design Sharding Strategy: Choosing Keys, Avoiding Hot Spots, and Resharding Safely

TLDR: Sharding means splitting one logical dataset across multiple physical databases so no single node carries all the data and traffic. The hard part is not adding more nodes. The hard part is choosing a shard key that keeps data balanced and queri...