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.42-26.23 (release notes, download), with Galera replication library 4.23 (release notes, download) implementing wsrep API version 26. It also includes Galera Cluster for MySQL 8.4, consisting of MySQL-wsrep 8.4.5-26.23 (release notes, download); it also uses the same Galera replication library 4.23. This release incorporates all changes to MySQL 8.0.42, and MySQL 8.4.5 adding a synchronous option for your MySQL High Availability solutions.
In the Galera replication library 4.23, we now allow you to use CMake 4.0.0 for building, but from a user standpoint we have more robust node leave & shutdown by ensuring that pending messages are sent before cluster connections are shutdown. We also have a stateless/arbitrator flag which is now configurable, not hardcoded in the garbd binary. And we fixed an error: mix-segment clusters no longer trigger comparison doesn’t meet irreflexive requirements.
In MySQL-wsrep 8.0.42-26.23 and 8.4.5-26.23, we added WSREP_MODE_APPLIER_LOG_WARNINGS to print warnings when a replicated row fails foreign key checks. In addition we also have applier logging extra foreign key failure details when WSREP_MODE_APPLIER_LOG_WARNINGS is enabled. There is also wsrep_applier_retry_count, and if set to a value greater than 0, had the secondary retry writeset application up to n-times instead of hard aborting on the first error. Note that the default is still 0.
We also fixed a heap buffer overflow crash on foreign key cascades into VARCHAR columns, and ensure that a replicated DELETE that loses its parent table is now forced into a single-thread to keep order. The server_uuid is no longer saved as all zeros on first start when wsrep_sync_server_uuid = ON is set.
When it comes to FLUSH TABLES WITH READ LOCK (FTWRL), it now returns an error hen the node is in a non-primary component instead of just hanging. Also, applying Total Order Isolation (TOI) operations after an FTWRL desync now raises an error, instead of crashing the server.
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 Editioncan do for you.