Percona XtraDB Cluster is an open source, cost-effective, robust MySQL clustering solution for businesses. It enables applications requiring synchronous replication of data to have fault-tolerant failover and quick, easy scalability across commodity and off-the-shelf hardware. Organizations use Percona XtraDB Cluster to power highly available applications in the most demanding public, private and hybrid cloud environments. It is an excellent solution for your MySQL cluster and database needs.
This chart, based off of the Percona chart (which in turn is based off the MySQL chart), bootstraps a multi-node Percona XtraDB Cluster deployment on a Kubernetes cluster using the Helm package manager.
The chart exploits the deterministic nature of StatefulSet and KubeDNS to ensure the cluster bootstrap is performed in the correct order.
Percona Consulting can help you determine if Percona XtraDB Cluster is the right solution for your company and if it is, help with your deployment, while ensuring optimal performance for your database and cluster nodes. Percona Support can ensure your deployment runs as expected and help you in a crisis. If you lack the resources to manage your Percona XtraDB Cluster deployment, our Managed Services team can take over the full operation of your servers.
When you execute a query, it is executed locally on the node. All data is available locally, no need for remote access.
No central management. You can lose any node at any point of time, and the cluster will continue to function without any data loss.
Good solution for scaling a read workload. You can put read queries to any of the nodes.
Overhead of provisioning new node. When you add a new node, it has to copy the full data set from one of the existing nodes. If it is 100GB, it copies 100GB.
This can’t be used as an effective write scaling solution. There might be some improvements in write throughput when you run write traffic to 2 nodes versus all traffic to 1 node, but you can’t expect a lot. All writes still have to go on all nodes.
You have several duplicates of the data, for 3 nodes you have 3 duplicates.
Percona XtraDB Cluster is based on Percona Server running with the XtraDB storage engine. It uses the Galera library, which is an implementation of the write set replication (wsrep) API developed by Codership Oy. The default and recommended data transfer method are via Percona XtraBackup.
Tell us about a new Kubernetes application
Never miss a thing! Sign up for our newsletter to stay updated.
Discover and learn about everything Kubernetes