MySQL and OpenStack
summary
MySQL serves as the metadata store for Nova, Neutron, Keystone, Glance and Cinder and is commonly deployed as Percona XtraDB Cluster or MariaDB Galera to get synchronous, multi‑writer replication; configure wsrep_sync_wait to avoid stale reads and rely on the OpenStack retry‑on‑deadlock pattern. Running MySQL on VMs exposes networked storage latency, bad‑neighbor IO jitter and Swift page‑size issues, so clustered or NDB-style designs perform better. Trove provides DBaaS with simple commands like trove create MySQL one, supports backups and replicas and uses MySQL 5.6 GTID replication.
AI-written summary · about
chapters (8)
- 0:00MySQL and OpenStack intro
- 1:19MySQL in a VM
- 3:32Galera cluster as backend
- 8:53Connection pools for OpenStack
- 9:56MySQL in VM considerations
- 11:55Introducing Trove database as a service
- 15:55Trove usage examples
- 20:17Q&A
related talks
51mMySQL in the Cloud
51mPostgres on OpenStack
25mData in the Cloud
23mRunning MySQL on K8s. Deployment, Scaling, Backups and advanced configuration
56mDeploying MySQL on Kubernetes & Openshift
38mIntro: Vitess
36mCreate your Own MySQL-as-a-Service that Runs Anywhere Using Kubernetes Operators
55mThe Future of MySQL