Replication & Sharding
Database scaling strategies
- 00 Replication & Sharding — Roadmap Postgres streaming replicas by hand. Manual shard routing without Vitess. beginner 3 min →
- 01 Replication Fundamentals Why replication exists, synchronous vs asynchronous, WAL-based streaming, and the consistency trade-offs every replica introduces. beginner 8 min →
- 02 Postgres Streaming Replication by Hand Setting up a primary, configuring pg_basebackup, streaming WAL to a standby — no managed service, no Patroni, just Postgres. intermediate 12 min →
- 03 Sharding Concepts When replication isn't enough, partition keys, shard routing strategies, and the operational complexity you accept when you shard. intermediate 10 min →
- 04 Manual Shard Routing Building a shard router in application code — connection management, transaction boundaries, migration strategies, and avoiding common pitfalls. intermediate 11 min →
- 05 Postgres Table Partitioning Range, list, and hash partitioning — the single-server answer to large tables that buys you most of what sharding promises without the operational cost. intermediate 9 min →