Galera Cluster for MySQL 5.7.43 and MySQL 8.0.34 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.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 26. This release incorporates all changes to MySQL 5.7.43 and MySQL 8.0.34 respectively, adding a synchronous option for your MySQL High Availability solutions.

For MySQL 5.7, one should continue using the Galera replication library 3.37 implementing the wsrep API version 25 for MySQL-wsrep 5.7.32. 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.43-25.35, when the server is started with read-only=ON, the mode toggled off during highly concurrent workloads due to a race condition. This has now been fixed. While not user visible, this is notable to how wsrep_retry_autocommit now works: the condition to replay a transaction via autocommit retry is now based entirely on wsrep_conflict_state, not accessing the lex tree as it is not guaranteed to be in a well-formed state.

In the Galera replication library 4.16 for MySQL 8.0.35-26.15, improvements around better handling when the socket is closed, even stretches to FreeBSD. We also cleaned up all the excessive debug logging. And we have also removed out-of-order certification for BF aborted transactions.

In MySQL 8.0.34-26.15, we have the two above fixes in 5.7.43-25.35 (read-only=ON works during highly concurrent workloads; and how wsrep_retry_autocommit has changed). In addition, INFO-level wsrep messages are now logged with SYSTEM_LEVEL priority by default, as WSREP information level messages are crucial for debugging replication issues. However, if you choose to have the old behaviour, a new variable, wsrep_info_level has been introduced to allow changing the priority to INFORMATION_LEVEL if needed. During CREATE TABLE AS SELECT, Galera will not support wsrep_forced_binlog_format=MIXED|STATEMENT, and it will result in ROW with a warning. We also fixed an inconsistency caused by ROLLBACK TO SAVEPOINT. For systemd multi-instance users, we now have support, to ensure that you can specify which instance to bootstrap too (in addition to specifying the startup position).

This is the last release for Ubuntu 18.04 LTS (Bionic) as it is has reached EOL May 31 2023.

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.