Automating MySQL Deployments on Kubernetes
The myth that containers aren't ready for databases still persists. We're not buying it.
We have built and open-sourced the MySQL operator for Kubernetes to solve this problem as a layer in the Presslabs stack for open WordPress hosting infrastructure.
We operate with lots of small to medium-sized DBs, in a DB-per-service model, as we call it. The workloads are mostly reads, so we need to efficiently scale that. The MySQL asynchronous replication model fits the bill very well, allowing to scale horizontally from one server (with the obvious availability pitfalls) to tens of nodes.
The operator is based on Percona Server for MySQL for its operational improvements â€”like utility user and backup locksâ€”and relies on Orchestrator to do the automatic failovers.
We plan to integrate it with Percona Management & Monitoring. Community feedback on the operations it automates and to make sure that the data is safely stored is very welcome.