Skip to content

Compare various solutions to deploy MySQL in Kubernetes

There are multiple ways to deploy and manage MySQL in Kubernetes. Here we will focus on comparing the following open source solutions:

Generic

The review of generic features, such as supported MySQL versions, open source models and more.

Feature/Product Percona Operator for MySQL (based on PXC) Percona Operator for MySQL (based on PS) Bitpoke MySQL Operator Moco Oracle MySQL Operator Vitess
Open source model Apache 2.0 Apache 2.0 Apache 2.0 Apache 2.0 Apache 2.0 Apache 2.0
MySQL versions 5.7, 8.0 8.0 5.7 8.0 8.0 5.7, 8.0
Kubernetes conformance Various versions are tested Various versions are tested Not guaranteed Not guaranteed Not guaranteed Not guaranteed
Paid support ✅ ✅ 🚫 🚫 ✅ 🚫

MySQL Topologies

Focus on replication capabilities and proxies integrations.

Feature/Product Percona Operator for MySQL (based on PXC) Percona Operator for MySQL (based on PS) Bitpoke MySQL Operator Moco Oracle MySQL Operator Vitess
Replication Sync with Galera Async and Group Replication Async Semi-sync Group Replication Async
Proxy HAProxy and ProxySQL HAProxy and MySQL Router None None MySQL Router VTGate
Multi-cluster deployment ✅ 🚫 🚫 🚫 🚫 🚫
Sharding 🚫 🚫 🚫 🚫 🚫 ✅

Backups

Here are the backup and restore capabilities of each solution.

Feature/Product Percona Operator for MySQL (based on PXC) Percona Operator for MySQL (based on PS) Bitpoke MySQL Operator Moco Oracle MySQL Operator Vitess
Scheduled backups ✅ ✅ ✅ ✅ 🚫 ✅
Incremental backups 🚫 🚫 🚫 ✅ 🚫 🚫
PITR ✅ 🚫 🚫 🚫 🚫 🚫
PVCs for backups ✅ 🚫 🚫 🚫 🚫 🚫

Monitoring

Monitoring is crucial for any operations team.

Feature/Product Percona Operator for MySQL (based on PXC) Percona Operator for MySQL (based on PS) Bitpoke MySQL Operator Moco Oracle MySQL Operator Vitess
Custom exporters Through sidecars Through sidecars mysqld_exporter mysqld_exporter 🚫 🚫
PMM ✅ ✅ 🚫 🚫 🚫 🚫

Miscellaneous

Compare various features that are not a good fit for other categories.

Feature/Product Percona Operator for MySQL (based on PXC) Percona Operator for MySQL (based on PS) Bitpoke MySQL Operator Moco Oracle MySQL Operator Vitess
Customize MySQL ConfigMaps and Secrets ConfigMaps and Secrets ConfigMaps ConfigMaps ConfigMaps 🚫
Helm ✅ ✅ ✅ ✅ ✅ 🚫
Transport encryption ✅ ✅ 🚫 🚫 ✅ ✅
Encryption-at-rest ✅ ✅ 🚫 🚫 🚫 🚫

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services. Join K8S Squad to benefit from early access to features and “ask me anything” sessions with the Experts.


Last update: 2024-10-29