Create your Own MySQL-as-a-Service that Runs Anywhere Using Kubernetes Operators

on YouTube ↗36m

" summary

DIY MySQL-as-a-Service runs on Kubernetes using Presslabs operator and Orchestrator with Percona MySQL containers, StatefulSets and a sidecar that writes backups to S3; production workload moves off AWS RDS to private cloud and runs for ~1.5 years. Automated failover promotes replicas but single-master design causes ~1–3 minute downtime on failure. Monitoring uses Prometheus; storage on OpenStack/Cinder with LVM works better than vendor controllers; current backups use mysqldump, plan snapshot backups, multi‑master and online upgrades remain unfinished.

AI-written summary · about

" chapters (16)

1. 0:00Introduction
2. 1:11About Platform Line
3. 1:56Agenda
4. 3:08Background
5. 4:55What did you look for
6. 10:21Why not Kubernetes
7. 13:40Our Solution
8. 16:25Components
9. 17:54Cluster Architecture
10. 19:37Kubernetes Containers
11. 21:04Orchestrator
12. 22:37Problems with both approaches
13. 26:50Software stack issues
14. 28:35Future plans
15. 29:28Links
16. 30:27Questions

" related talks

• 41mDemocratizing MySQL: From Cloud Managed to Kubernetes ManagedSachin Manpathak · KubeCon + CloudNativeCon Europe 2019
• 35mRunning MySQL on Kubernetes [I]Patrick M. Galbraith · KubeCon + CloudNativeCon North America 2017
• 23mRunning MySQL on K8s. Deployment, Scaling, Backups and advanced configurationAnanias Tsalouchidis · Percona University Istanbul 2022
• 53mMySQL in the Cloud: DBaaS vs KubernetesMichal Nosek · Percona Live 2022
• 56mDeploying MySQL on Kubernetes & OpenshiftAleksandr Rubin · HighLoad++ Moscow 2018
• 19mPrivate DBaaS: Why you Need it, How to Build ItSergei Pronin · Percona University Istanbul 2022
• 36mFrom a Database in Container to DBaaS on KubernetesPeter Zaitsev · Open Source Summit Latin America 2022
• 27mDatabase Infrastructure with Open Source Kubernetes Database OperatorsINEL PANDZIC · stackconf 2023