From VMs to Cloud-Native PostgreSQL in Kubernetes...
summary
Case study of migrating a medium e‑commerce app (four sites, ~50–70 GB DBs) to Cloud Native PostgreSQL on Kubernetes using an operator, logical replication for cutover, and Barman+S3 backups; steady load ~100 TPS with spikes to ~200 during batch loads. Tests use limos and k9s, benchmarks via the cnpg plugin; storage uses local PV + operator on VMware (lose‑node risk), no pgbouncer, automatic failover succeeds in tests, full rebuild from S3 under ~40 minutes.
AI-written summary · about
chapters (14)
- 0:00Introduction and speaker background
- 4:16Application overview and challenges
- 9:34Motivation for migration to Kubernetes
- 12:23Operator selection and Cloud Native PostgreSQL
- 16:40Myths and realities about Kubernetes and PostgreSQL
- 23:40Migration planning and storage options
- 27:34Networking and connection handling
- 31:23Kubernetes cluster management and failover
- 34:56Disaster recovery and backup strategies
- 37:03Tuning and configuration considerations
- 41:20Migration methods and logical replication
- 44:52Testing and operator reliability
- 46:14Comparison before and after migration
- 47:40Training and future steps
related talks
37mData On Kubernetes, Deploying And Running PostgreSQL And Patterns For Databases In a Kubernetes Cluster.
28mLightning Talk: Cloud Native PostgreSQL - Running PostgreSQL on Kubernetes
48mPostgreSQL in Kubernetes: Operation - Day 2
30mRunning PostgreSQL on Kubernetes in Production: Day 2 Operations with CloudNativePG
34mRun PostgreSQL:The Kubernetes way
41mCloud-Native Databases in Kubernetes with OpenShift and Postgres
05mFive Minutes by CloudNativePG River
27mFrom Zero to Hero: Scaling Postgres in Kubernetes Using the Power of...