From Zero to Hero: Scaling Postgres in Kubernetes Using the Power of...
summary
Shows how CloudNativePG operator runs PostgreSQL on Kubernetes with one primary and two replicas, supports a synchronous replica option, and exposes Prometheus metrics, Grafana dashboards and mTLS by default. Describes backups via WAL archive to object stores (default RPO 5 minutes), physical base backups and PVC/volume snapshots, cross‑cluster replica clusters and a demonstrated 4.5 TB recovered in 2 minutes. Claims day‑0 to day‑2 lifecycle automation, and notes the only current manual action is establishing cross‑cluster streaming replication.
AI-written summary · about
chapters (13)
- 0:00Scaling Postgres in Kubernetes
- 2:33Cloud Native PG overview
- 5:50Cloud Native PG components
- 8:20Deploy Postgres cluster
- 11:56High availability & failover
- 12:59Backup & recovery
- 16:32Disaster recovery
- 18:00Production architecture with three availability zones
- 19:46Multi-cluster DR setup
- 21:56Single-AZ challenges
- 23:00Future developments
- 25:07Choosing the right setup
- 26:35Conclusion and key takeaways
related talks
34mRun PostgreSQL:The Kubernetes way
50mDemystifying Kubernetes for Postgres DBAs; A Guide to Operators
48mPostgreSQL in Kubernetes: Operation - Day 2
30mRunning PostgreSQL on Kubernetes in Production: Day 2 Operations with CloudNativePG
41mCloud-Native Databases in Kubernetes with OpenShift and Postgres
54mPostgres: From Cloud to Hybrid and On Prem Again
26mKubernetes from the Database Out
37mData On Kubernetes, Deploying And Running PostgreSQL And Patterns For Databases In a Kubernetes Cluster.