Rolling out a Database-as-a-Service layer at Ghent University
summary
University replaces end‑of‑life physical MySQL boxes with a private VMware DBaaS running Percona Server 5.7, managed by Puppet and offering self‑service provisioning. A three‑node ProxySQL layer (behind keepalived) handles read/write splitting and query mirroring, Orchestrator automates master election and topologies, and a three‑node PXC setup makes orchestrator HA. Backups use Percona Xtrabackup with daily fulls, encrypted compressed files and binlog shipping; restores are regularly tested. Small pain point: HTTP health checks around orchestrator produce occasional 503s.
AI-written summary · about
chapters (6)
- 0:00Introduction
- 0:20About Ghent University
- 6:14Managed service
- 7:03Components
- 14:20Backups
- 19:05Questions
related talks
56mDeploying MySQL on Kubernetes & Openshift
55mProduction with ProxySQL and Orchestrator
41mDemocratizing MySQL: From Cloud Managed to Kubernetes Managed
02mPercona Enterprise Platform
26mOpen Source DBs on VKS Automated DBaaS via Percona & VMware Cloud Foundation
30mComposing a Multi Database DBaaS from Open Source Kubernetes Operators
27mDIY DBaaS with Percona Kubernetes Operators
23mRunning MySQL on K8s. Deployment, Scaling, Backups and advanced configuration