Postgres on OpenStack
summary
Claims concrete deployable steps: use Glance image + snapshot workflow to ship clean Postgres images, create Nova flavors + host-aggregate extra_specs to pin DB VMs to SSD hosts, choose between local instance store shared via NFS or Cinder volumes for elastic, network-backed storage, and manage networking with Neutron security groups. Trove is noted as immature for clustering. WAL and base backups go to Swift using wally -> Swift WAL archiving, which proves fast and practical in production.
AI-written summary · about
chapters (29)
- 0:00Introduction
- 1:04What is OpenStack?
- 2:31Glance Image Service
- 3:35Cinder Block Storage Service
- 4:41Nova Compule Service
- 6:50Neutron Networking Service
- 7:46Swift Object Storage
- 8:44Wat what about Trave?
- 10:53Database server images
- 13:53Creating an image
- 16:02Uploading the image
- 17:01Dedicated database flavours
- 18:12Targeting a host aggregate
- 19:35Create host aggregate
- 20:10Create favour
- 21:42A note on Scheduler Filters
- 24:37Local storage
- 26:40Shared instance storage
- 28:19Volume storage
- 30:33Data storage
- 34:47Instance firewaling
- 37:09Security group configuration
- 37:47Private cluster network
- 39:47Network configuration
- 40:39Network topology
- 41:45WAL archiving to Swift
- 44:05Installing WALE
- 47:09WAL Archives
- 48:49Summary cold
related talks
41mCloud-Native Databases in Kubernetes with OpenShift and Postgres
54mPostgres: From Cloud to Hybrid and On Prem Again
45mPostgres: ServerLESS is more?
30mBridging the DevOps to Data Divide with a Common Cloud Native Stack
35mContainerizing PostgreSQL and Making it Cloud Native Ready
01h 00mWriting Portable PostgreSQL - backed network applications for the open cloud
28mRun PostgreSQL in Warp Speed Using NVMe/TCP in the Cloud
28mFrom VMs to Ku...