Multi-Region Postgres With Replication
Set up Postgres with logical + physical replication across 2 regions. Practice failover, lag monitoring, and consistency trade-offs.
About this project
Multi-region database design is the senior-backend interview frontier. This project teaches the trade-offs hands-on: streaming replication, logical replication, failover orchestration, lag monitoring, and the consistency choices (read-your-writes, strong vs eventual). You will set up two-region Postgres on a small cloud (Hetzner is fine, costs $20-50 for the experiment), simulate a region failure, and document the recovery procedure.
Why build this in 2026?
AI workloads are increasingly compute-distributed; the question of "where does our data live and how do we keep it consistent" is back on the table.
What you'll ship
- Terraform repo provisioning the full setup
Sign up to see the full project brief
Full deliverables, success criteria, and AI Career Tutor support — free.
You'll unlock:Complete project brief, AI tutor that knows this project, and progress tracking when you start.