MJMayank Jaininsyntax-soul.hashnode.dev·17h ago · 10 min readDemystifying PgBouncer: Connection Pools, Hidden Math, and Multi-Pod ScalingIf you are running PostgreSQL or AlloyDB in a high-traffic production environment, you have likely heard that you need PgBouncer. But while setting it up can seem as simple as dropping a lightweight p00
MJMayank Jaininsyntax-soul.hashnode.dev·2d ago · 9 min readRedis in Production: Pitfalls, Anti-Patterns, and Hard-Won LessonsThis is the practical, "things that actually bite people" post. Everything here is a pattern that looks fine in development, passes code review, and then causes a real incident once it hits production00
MJMayank Jaininsyntax-soul.hashnode.dev·2d ago · 11 min readSharding, Replication, and Sharded Replication in Redisverything so far has assumed a single Redis instance. That's fine for a lot of use cases, but it has two hard limits: your dataset can't be bigger than one machine's RAM, and if that one machine goes 00
MJMayank Jaininsyntax-soul.hashnode.dev·2d ago · 8 min readCache Invalidation Patterns: Cache-Aside, Write-Through, and Write-BehindThere's an old joke in computer science: "There are only two hard things: cache invalidation and naming things." This post is about the first one — the actual strategies real systems use to keep cache00
MJMayank Jaininsyntax-soul.hashnode.dev·3d ago · 8 min readThe Single-Threaded Nature of Redis, In Depth — and How to Monitor ItIn Post 2, we introduced the fact that Redis executes commands on a single thread, and why that means throwing more vCPUs at it doesn't help. This post goes deeper: what actually runs where, which com00