Containerizing PostgreSQL and Making it Cloud Native Ready
summary
A container suite that packages PostgreSQL plus small wrapper services for admin, backup and monitoring is available and proven to run on Docker, Kubernetes/OpenShift and Marathon Mesos using CentOS7/RHEL7 base images. It uses pg_basebackup for full backups persisted to NFS and executed as a kubernetes job, collects 20–30 Postgres metrics via a small Go scraper pushed to Prometheus and shown in Grafana, and provides crunchy-collect, crunchy-backup, crunchy-watch (failover), pgpool and a kitchen sink example with one master, one synchronous replica and multiple async replicas able to scale and recover.
AI-written summary · about
chapters (18)
- 0:00Intro
- 0:22About Crunchy Data...
- 1:29Why Containers for PostgreSQL?
- 4:12Deployment Options
- 7:18Customizing Your PostgreSQL Containers
- 9:29PostgreSQL Container Design Features
- 12:24Backup and Restore
- 14:01High Availability
- 15:54Database Monitoring
- 17:48DBA Utility Microservices
- 19:54DBaaS Example: Crunchy Container Suite
- 24:17What About Orchestrating Containers?
- 26:40Swarm Deployment
- 26:51Kubernetes Deployment
- 27:04Performance Considerations
- 28:48Kitchensink Example
- 31:25Kitchensink (OpenShift) Example
- 32:22Summary
related talks
34mRun PostgreSQL:The Kubernetes way
26mKubernetes from the Database Out
30mBridging the DevOps to Data Divide with a Common Cloud Native Stack
41mCloud-Native Databases in Kubernetes with OpenShift and Postgres
56mExperiments with Postgres in Docker and the Cloud
50mDemystifying Kubernetes for Postgres DBAs; A Guide to Operators
36mKube-native Postgres [I]
54mPostgres: From Cloud to Hybrid and On Prem Again