Lightning Talk: Kubernetes as Your DBA
Lightningat Data on Kubernetes Day NA 2024 · on Tuesday, 2024-11-12· at 11:55· Salt Palace | Level 2 | 250 A·
summary
Shows that a Postgres Kubernetes operator (example: PGO) automates concrete DBA work: it builds a three-node HA cluster with Patroni and HAProxy, configures backups with PG BackRest, sets up monitoring, retries and purges backups, and performs rolling minor and scripted major upgrades (pg_upgrade, logical replication or dump/restore). Customers run multi‑terabyte databases and hundreds to thousands of schemas; operators cut night‑time on‑call and handle failovers but major upgrade planning and strategic DBA decisions remain necessary.
AI-written summary · about
chapters (20)
- 0:00Kubernetes as your DBA
- 1:25Need a virtual DBA on Kubernetes
- 2:30Database architecture and Kubernetes
- 5:41DBA day-to-day tasks
- 7:30Kubernetes automates DBA tasks
- 8:56Kubernetes operators for databases
- 9:58High availability with operators
- 11:48Backup and disaster recovery
- 13:15Monitoring and security with operators
- 14:39Database upgrades and maintenance
- 16:02Still need a human DBA
- 17:26Database creation and maintenance
- 18:31Try the Postgres operator
- 20:55Benefits of virtual DBAs
- 21:37Q&A: Kubernetes upgrades
- 23:28Q&A: Stateless and ephemeral concerns
- 24:51Q&A: Node maintenance and failovers
- 27:55Q&A: User accounts and permissions
- 28:59Q&A: Postgres-like compatibility
- 29:41Q&A: Persistent volumes on bare metal
related talks
50mDemystifying Kubernetes for Postgres DBAs; A Guide to Operators
25mPostgres on Kubernetes for the Reluctant DBA
26mKubernetes from the Database Out
48mPostgreSQL in Kubernetes: Operation - Day 2
07mLightning Talk: My Database Runs on Kubernetes. What's Next? Data Platforms!
34mRun PostgreSQL:The Kubernetes way
18mChaos testing of a Postgres cluster on Kubernetes
26mBeyond the DBaaS Trap: Achieving Data Sovereignty With Kubernetes and CloudnativePG