Galera Cluster for MySQL 5.6.51, 5.7.33, and 8.0.23 released

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.6, 5.7 and 8.0, consisting of MySQL-wsrep 5.6.51 (release notes, download), 5.7.33 (release notes, download) and 8.0.23 (release notes, download) with Galera replication library 3.33 (release notes, download) implementing wsrep API version 25, and Galera replication library 4.8 (release notes, download) implementing wsrep API version 26 for 8.0. This release incorporates all changes to MySQL 5.6.51, 5.7.33 and 8.0.23 respectively, adding a synchronous option for your MySQL High Availability solutions.

Throughout the entire packages, for the binary tarballs, we have bumped the release of OpenSSL to version 1.1.1k. It is recommended that you upgrade as soon as possible if you are using the binary tarballs.

For the Galera replication library 3.33, we now ensure that the recoveries happen to the correct position after a process gets killed during an Incremental State Transfer (IST). We also have hardware CRC32 support for FreeBSD/ARM.

In MySQL 5.6.51, we have added the audit log plugin in Debian, and we have fixed the mysqldump State Snapshot Transfer (SST) script to keep the general log and slow query log variables intact on the donor node. We also made global variables wsrep_provider and wsrep_notify_cmd as read-only.

In MySQL 5.7.33, the above fixes in 5.6.51 were rolled in, in addition to ensure that when you run mysqld --help --verbose, the command would not hang.

In Galera replication library 4.8 we have made many new fixes and features; for one we incorporate the IST recovery and correct position as per 3.33 above. We have also added support for X509 certificate chains, changed the SSL error messaging (to become more human readable and friendly), plus we have also added socket.ssl_reload=1 and socket.dynamic=1 as options to reload the SSL provider certificate and the latter makes the upgrade path from non-SSL to SSL clusters much easier as nodes can communicate over both SSL and TCP connections. We have also documented this naturally!

In MySQL 8.0.23, the CLONE SST plugin that was introduced in a previous release now also works with binary tarball installations. In addition, IPv6 support exists for CLONE SST now as well. One notable change is that CREATE TABLE AS SELECTnow cannot be used to create non-InnoDB tables in the cluster (creating non-InnoDB tables is also not recommended in general). There is also a Percona PAM and Percona Simple LDAP plugin merged now, which will help you have multiple backend authentication methods. For SST to work, Percona XtraBackup 8.0.23-16.0 and higher is required now.

It is also important to remember that MySQL 5.6 has reached End Of Life (EOL) so we do recommend that you upgrade to MySQL-wsrep 5.7.