Sharding strategies: directory-based, range-based, and hash-based

This post introduces and compares three sharding strategies: directory-based, range-based, and hash-based. It details the mechanics, pros, and cons of each, including potential issues like data distribution imbalance and hotspots. The post recommends hash-based sharding as the default due to its generally even distribution and ease of resharding, provided the shard key has high cardinality. It also mentions PlanetScale's built-in sharding options and the Vitess project.