Google SWE teaches systems design | EP5: Database sharding/partitioning

My ex would've been really good at picking a fixed number of partitions because she told me I wasn't too big or too small, just right (pain). Also, slight error on my part: dynamic partitioning doesn't necessarily mean the database rebalances on its own - sometimes it will make the suggestion and an operator has to do so manually. Recommended Reading: Designing Data Intensive Applications, Chapter 6 0:00 Introduction 1:45 Objectives of partitioning 2:25 Methodologies for partitioning 4:01 Hash Range Partitioning 4:35 Hash Range Partitioning Tradeoffs 5:44 Indexes in a partitioned database 7:01 Local Index Tradeoffs 7:29 Global Indexes 8:53 Rebalancing Partitions 10:28 Fixed Number of Partitions 12:20 Fixed number of partitions per node 13:03 Sharding Summary 14:05 Sharding Summary Continued