MySQL 8.4 has two good options for High Availability clusters: Galera Cluster (and Percona XtraDB Cluster (PXC)) plus MySQL InnoDB Cluster. Both solutions are now mature enough, so what is the deciding factor? Workload characteristics, application compatibility (Galera is virtually synchronous; InnoDB Cluster offers 2 modes – single primary mode, which is one instance being read-write, with the rest being read only, and multi-primary mode, which is closer to what Galera Cluster is) and operational preferences, most likely will decide which one comes out top in 2025, is what we aim to answer at next week’s webinar.

Due to the lack of real-world usage statistics (we can tell you how many Galera Cluster downloads we have, for example, or even customer numbers, but we won’t have anything to compare against), we look at proxy statistics, like …

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.41-26.22 (release notes, download), with Galera replication library 4.22 (release notes, download) implementing wsrep API version 26. It also includes Galera Cluster for MySQL 8.4, consisting of MySQL-wsrep 8.4.4-26.22 (release notes, …

If you’ve ever wanted to deploy Galera Cluster on Rancher by SUSE, you now can since Galera Cluster is a partner chart in their repository. This means Codership’s Galera Cluster is a SUSE Ready Verified partner. A direct link to the HELM charts for MySQL/Galera Cluster is here.

What is Rancher? Rancher is a Kubernetes management tool to deploy and run clusters anywhere and on any provider. Rancher can provision Kubernetes from a hosted provider, provision compute nodes and then install Kubernetes onto them, or import existing Kubernetes clusters running anywhere.

Rancher comes with very good …

As we know, Orchestrator is a MySQL high availability and replication management tool that aids in managing farms of MySQL servers. In this blog post, we discuss how to make the Orchestrator (which manages MySQL) itself fault-tolerant and highly available. When considering HA for the Orchestrator one of the popular choices will be using the Raft consensus. […]

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.40-26.21 (release notes, download), with Galera replication library 4.21 (release notes, download) implementing wsrep API version 26. It also includes Galera Cluster for MySQL 8.4, consisting of MySQL-wsrep 8.4.3-26.21 (release notes, …

We have documented streaming replication, and we have also mentioned how you can use streaming replication, and we also once did a webinar with recording on it, and we wrote a very in-depth blog post on how to use streaming replication to manage large transactions with Galera Cluster.

However, we had a question recently about streaming replication around the usage of wsrep_trx_fragment_unit and wsrep_trx_fragment_size (also, well …

Join us for an in-depth webinar where we introduce the new Helm Chart for Galera Cluster for MySQL, now available from Codership (read the blog).

In this session, we’ll guide you through the process of deploying a high-availability MySQL cluster using Galera Cluster on Kubernetes (live demo!). You’ll learn how Helm Charts can simplify Kubernetes application management, including installation and upgrades, while ensuring robust deployment automation.

This webinar is ideal for database administrators, DevOps engineers, and anyone looking to streamline their MySQL high availability deployments on Kubernetes, whether on cloud platforms like Amazon EKS, Google GKE, or on-premises solutions. We’ll cover best practices for configuration, deployment, and scaling of your Galera Cluster, and offer insights on how to …

Codership, the makers of Galera Cluster, are pleased to announce the availability of Helm charts for Galera Cluster for MySQL 8.0.39. It is available on our GitHub releases page, for convenience. You are encouraged to send feature requests at our GitHub issues.

Helm charts help you manage your Kubernetes applications, to install and upgrade any Kubernetes applications; think of it as a package manager. Kubernetes helps you automate the deployment, management and scaling of containerized applications.

For this blog post, we will use the example of setting it up at DigitalOcean, but the setup is similar, whether you do this in a …

Galera Cluster Enterprise Edition (EE) has had support for Non-Blocking Operations (NBO) schema upgradesever since the first release of Galera Cluster Enterprise Edition (EE). It is reasonably well documented, and we think more people will benefit from using it, of course. Schema changes tend to always remain a daunting task when you have large databases to manage.

To compare between Total Order Isolation (TOI), the default, with NBO that is available in Galera Cluster Enterprise Edition (EE), we create a test table:

CREATE TABLE large;
USE large;

CREATE TABLE test_table (
    id INT PRIMARY KEY AUTO_INCREMENT,
    data VARCHAR(255),
    num1 INT,
    num2 INT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Then we …

Codership will be a sponsor at DOAG 2024 in Nuremberg, Germany. There will also be 2 Galera Cluster related talks to attend:

1. Building a Global, High-Availability Database with Galera Cluster: A Live Demo Colin Charles Codership
2. Safe Harbor! Wie der Galera Cluster ihre MySQL Datenbanken „unsinkbar“ macht. Matthias Jung Ordix

There are also a few Galera Cluster blog posts in German from our partner Ordix that are useful:

1. …