In our lab environment, we received some emails from our provider, DigitalOcean saying a few nodes would be going down, because of issues with the physical nodes. Since we run a 9-node Galera Cluster in the lab, across 3 regions (San Francisco, London and Singapore), this posed an interesting problem!

Upon connecting to one of the nodes, we see:

mysql> show status like 'wsrep_cluster_size';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| wsrep_cluster_size | 7     |
+--------------------+-------+
1 row in set (0.02 sec)

So we know that 2 of the nodes are down. Presuming you do not have any monitoring setup (might we recommend …

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.43 (release notes, download) and MySQL-wsrep 8.0.34 (release notes, download), with Galera replication library 4.16 (release notes, download) implementing wsrep API version …

Course Dates

Public course: EMEA timezone 26th of September. USA timezone 27th of September.

Company dedicated training or consulting session, request for dates for your company via email to: sales@galeracluster.com

Course Duration

1 day.  The breakdown is 3 hours, with a half hour lunch break, and another 3 hours per day. There will be bio-breaks. The total contact time with the trainer is 6 hours over a span of 1 day.

Requirements

• You need to be able to use Zoom the platform we will be using
• You will need to have access to an SSH client. Being in a Microsoft Windows environment is OK, but you need to have SSH to access the remote servers that we provide you access to.
• Some basic understanding of Linux (e.g. package management) as well as MySQL
…

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.42 (release notes, download) and MySQL-wsrep 8.0.33 (release notes, download), with Galera replication library 4.15 (release notes, download) implementing wsrep API version …

An inordinate amount of our Galera Cluster customer base is still using the MySQL 5.7 variant of Galera Cluster. Besides not being able to have access to all the new features of the Galera 4 library, MySQL 5.7 is rapidly reaching End of Life (EOL) status in October 2023. This is less than six months away, and it is also why we would like to focus on getting our users upgraded to MySQL 8.0 with Galera Cluster.

Firstly, MySQL 8 has been Generally Available (GA) since 19 April 2018. That is a whole five years, and you must by now, already know that there is a new release model, where there are new features included in minor releases. The release notes are a must read. Next, Codership released Galera Cluster 4 with MySQL 8 with MySQL 8.0.19, on …

MySQL has InnoDB data encryption, and Galera Cluster has supported it since it appeared in the main server. The one thing that was not covered was the encryption of the Galera Cache (the galera.cache file).

Here is a simple extract from the binlog.000001 files.

strings binlog.* |grep Custom |wc -l
10000
strings galera.cache |grep Custom |wc -l
10000

strings galera.cache|tail -10
Customer9100
Customer9099
Customer9098
Customer9097
Customer9096
Customer9095
Customer9094
Customer9093
Customer9092
Customer9091

You need to edit your /etc/my.cnf to include:

early-plugin-load=keyring_file.so
keyring_file_data=/var/lib/mysql-keyring/keyring

Note that in this example we are using the keyring_file plugin, which stores keyring data in a file on the local server host. This is not intended for regulatory compliance. You need to use a key management server that protects encryption keys in key vaults or hardware …

A common question we get is: can I add a node to my Galera Cluster without restarting the entire cluster? The simple answer is YES.

A lot worry about the fact that you do list servers that are part of the cluster within your my.cnf, and this file is not reloadable in a dynamic fashion. Fret not, though, because as long as your my.cnf has one active cluster member (the DONOR), you can have it be the JOINER.

If for example, you have 3 nodes: galera1: 159.223.105.21 galera2: 137.184.78.182 galera3: 137.184.65.171

The my.cnf line for wsrep_address should read as follows:

wsrep_cluster_address="gcomm://159.223.105.21,137.184.78.182,137.184.65.171"

It is then trivial for you to have your fourth server (say, galera4: 161.35.120.111), have a my.cnf that reads as follows:

wsrep_cluster_address="gcomm://159.223.105.21,137.184.78.182,137.184.65.171,161.35.120.111"

Now, …

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.41 (release notes, download) and MySQL-wsrep 8.0.32 (release notes, download). This release incorporates all changes to MySQL 5.7.41 and MySQL 8.0.32 respectively, adding a …

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.40 (release notes, download) and MySQL-wsrep 8.0.31 (release notes, download) with Galera replication library 4.14 (release notes, download) implementing wsrep API version 26. …

While Galera Manager is ideal for deploying on Amazon AWS or DigitalOcean, or even on your own on-premise hosts, there is a third option that exists, that allows you to monitor an existing cluster that you already have installed. While we won’t go thru installing a Galera Cluster in this post, we will show you how to get Galera Manager to function for this purpose.

Obtain Galera Manager via filling in the form. Once you have the gm-installer on your Galera Manager host, remember to execute: chmod +x gm-installer. We recommend also …