Galera Cluster for MySQL 5.7.40 and MySQL 8.0.31 released

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. This release incorporates all changes to MySQL 5.7.40 and MySQL 8.0.31 respectively, adding a synchronous option for your MySQL High Availability solutions. Note that we also have a Galera Cluster Enterprise Edition release for MySQL 8.0.31.

This is yet another release where you are also meant to continue using the Galera replication library 3.37 implementing the wsrep API version 25 for MySQL-wsrep 5.7.40. One can presume that unless there is a bug, we will not be releasing a new version of the library, as MySQL 5.7 goes End of Life (EOL) in October 2023. We strongly encourage you to upgrade from MySQL-wsrep 5.7 to MySQL-wsrep 8.0.

In MySQL 5.7.40-25.32, some changes include a new wsrep_diag.sql script which contains useful diagnostic queries for troubleshooting wsrep related issues, alongside mysqld_bootstrap handling interruptions. Around the recovery side of things, the wsrep position can be recovered even if wsrep is off, and wsrep_recover is an enhanced new addition backported from 8.0 to aid in the recovery of crashed clusters. wsrep_sync_wait is skipped during trigger execution, and there is a new wsrep_mode, APPLIER_IGNORE_MISSING_TABLE that enables the server to skip failures with table open at apply, only if hte log event contains other tables that are open; this is the default, and it improves multi-table updates involving triggers. There is also better handling of Total Order Isolation (TOI) from mistakenly skipping replication events to error reporting.

In the Galera replication library 4.14 for MySQL 8.0.31-26.12, we have deprecated the protonet.backend option since it supports only one option, asio; relatedly, protonet.version has also been deprecated. socket.ssl_compression is also deprecated as SSL compression cannot be enabled. They will be removed in a future release. We found a bug in the library that could parse incorrect parameters as long as it had a “good” prefix, i.e. evs.*, so we have fixed it such that it prevents setting of invalid option values. The parser also has improved: ISO8601 durations previously accepted invalid values, and now does not; in addition to the ISO8601 format, parsing durations now support real number representation.

In MySQL 8.0.31-26.12, we now ensure that mysqladmin displays all status variables for wsrep, overring the previous default upper limit. Like 5.7.40-25.32 we include the wsrep_diag.sql script for diagnostic handling, have better handling for Total Order Isolation (TOI), the mysqld_bootstrap script also handles interrupts, the wsrep position can be recovered even if wsrep is off, and the multi-table updates involving triggers are handled better, while wsrep_mode has APPLIER_IGNORE_MISSING_TABLE enabled as default. We now also have a version_comment variable to display server version releases.

Please download the latest software and update your Galera Clusters! We continue to provide repositories for popular Linux distributions, and we encourage you to use them. Contact us more more information about what Galera Cluster Enterprise Edition can do for you.