DVDevansh Vermainbackendblueprints.hashnode.dev·Jul 18 · 12 min readWhy is it a tough ask to Scale a SQL Database Horizontally especially for WritesPart 1: The Comfort of Vertical Scaling Picture this. You've built an e-commerce backend on PostgreSQL. Everything is on a single server — one instance, one disk, one brain making all the decisions. F00
DVDevansh Vermainbackendblueprints.hashnode.dev·Jul 13 · 7 min readHow consistent hashing works and helps in rebalancing shards in a SQL DB.The problem consistent hashing solves Say you shard your users table across 4 database nodes /shards using a hash function -> hash(user_id) % 4. This works fine — until you add a 5th node. Now % 4 bec00