Changes in MySQL-wsrep 5.7.41-25.33 (2023-04-06)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.41 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.41.

Galera Cluster 5.7 is available as targeted packages and package repositories for Debian, Ubuntu, CentOS and RHEL. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD will be available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

** WE HIGHLY RECOMMEND AN UPGRADE TO MySQL 8.0 AS MySQL 5.7 HAS END-OF-LIFE OCTOBER 2023. **

Notable changes and fixes in MySQL-wsrep since the latest release 5.7.40-25.32:

• all output from wsrep_diag.sql goes to the same output stream

Known Issues:

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST.

Changes in MySQL-wsrep 8.0.39-26.20 (2024-08-02)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.39 and wsrep API version 26.

This release incorporates all changes up to MySQL 8.0.39.

Galera Cluster 8.0 is available as targeted packages and package repositories for Debian 10 (Buster), 11 (Bullseye), and 12 (Bookworm), Ubuntu 20.04 LTS (Focal), 22.04 LTS (Jammy), and 24.04 LTS (Noble), CentOS 7 and RHEL 7, 8, and 9. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep since the latest release 8.0.37-26.19:

Changes in MySQL-wsrep 5.7.44-25.36 (2024-01-08)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.44 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.44.

Galera Cluster 5.7 is available as targeted packages and package repositories for CentOS 7 and RHEL 7 and 8. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

** WE HIGHLY RECOMMEND AN UPGRADE TO MySQL 8.0 AS MySQL 5.7 HAS END-OF-LIFE OCTOBER 2023. **

Notable changes and fixes in MySQL-wsrep since the latest release 5.7.43-25.35:

Changes in MySQL-wsrep 8.0.36-26.17 (2024-03-26)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.36 and wsrep API version 26.

This release incorporates all changes up to MySQL 8.0.36.

Galera Cluster 8.0 is available as targeted packages and package repositories for Debian 10 (Buster), 11 (Bullseye), and 12 (Bookworm), Ubuntu 20.04 LTS (Focal) and 22.04 LTS (Jammy), CentOS 7 and RHEL 7, 8, and 9. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep since the latest release 8.0.35-26.16:

• Recovering the GTID in case log file contains non-text bytes have been fixed, ensuring --wsrep-recover option functions correctly.

• CLONE SST has a few fixes: port settings from my.cnf read if not specified in wsrep_sst_address, it doesn't use client authentication credentials from m.cnf, it uses caching_sha2_password now for user creation for SST, no longer mysql_native_password, and there are better diagnostic messages when used with SSL.

• More diagnostic functionality including adding transaction sequence numbers and source IDs for ignored errors, and logging of event of row-based replication buffer file creation. Skipping doublewrite recovery is only printed when wsrep_debug is set.

• Standardized TOI error voting in Galera Cluster by using only MySQL error codes, addressing inconsistencies caused by locale differences and non-deterministic execution paths. This ensures uniform voting outcomes for TOI event failures. However, this can break backwards compatibility and opens up a possibility of a cluster split, so the server side wsrep protocol version is bumped to 7 in order to keep the old behaviour until the cluster is fully upgraded.

• Resolved an issue where a combination of native deadlocks and BF aborts in stored procedures led to assertion failures. The solution skips wsrep BF abort error handling for sub-statements, ensuring error handling only post sub-statement execution.

• Fixed an issue where autocommit SELECT FOR UPDATE queries, if BF aborted, could lead to inconsistencies and assertions within InnoDB.

• Error handling for SELECT FOR UPDATE inside transaction.

• wsrep_notify_status view should be passed down.

Known Issues:

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST.

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.26 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.26.

Galera Cluster 5.7 is now available as targeted packages and package repositories for Debian, Ubuntu, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable bugs fixed in this release:

• Work around 'pure virtual function called' crash on Centos 6 (codership/mysql-wsrep#298)

• Fixed an applying bug of SET PASSWORD which caused password to be exposed as plain text on slave nodes (codership/mysql-wsrep#356)

• Fixed a shutdown bug which caused mysqld process to exit before applier threads were shut down gracefully (codership/mysql-wsrep#353)

• Fixed use-after-delete bug which caused segmentation fault (codership/mysql-wsrep#352)

Known issues with this release:

• Server cannot be started using 'service' command on Debian Stretch.

• SST between 5.6 and 5.7 nodes is not supported

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST

• Compilation with DTrace enabled may fail, so -DENABLE_DTRACE=:BOOL=OFF may be given to cmake to disable DTrace

Changes to Repositories Structure

With the new release the repository structure is changed to allow for existence of all of the wsrep-patched mysql versions currently supported: 5.5 through 5.7. Thus the repository layout requires from the user to adjust his or her repository configuration to accomodate those changes. In order to have the WSREP and Galera library installed, one would need to add the following repositories: 1. Galera-3 repository for galera library: e.g. http://releases.galeracluster.com/galera-3// 2. Corresponding mysql-wsrep repository: e.g. http://releases.galeracluster.com/mysql-wsrep-/ here: ldist is Linux or BSD distribution (Ubuntu, Centos) and mversion is MySQL version, i.e. 5.5, 5.6, 5.7

How To Install

Repositories contain dummy or meta packages, called mysql-wsrep- which are convenience packages for installation of the corresponding version of WSREP. One can install the whole suite by running, for example: apt-get install mysql-wsrep-5.6 galera-3

Quirks for Ubuntu Xenial and 5.6

Due to the peculiarities of how apt resolves packages and presence of 5.7 libraries in Xenial repositories the command above might require additional steps/changes in order to succeed.

One would need to either configure apt pinning for codership repositories for them to have priority over upstream packages or to specify mysql-common package version explicitly as the one located in the WSREP repositories in order to get things installed.

Changes in MySQL-wsrep 5.7.37-25.29 (2022-05-16)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.36 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.37.

Galera Cluster 5.7 is available as targeted packages and package repositories for Debian, Ubuntu, CentOS and RHEL. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD will be available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep since the latest release 5.7.36-25.28:

• innodb_disallow_writes has been refactored to ensure that disk writes don't leak the mysql data directory when node is in SST donor state

• fixes a race condition in wsrep_sst_rsync by performing all disk IO blocking before creating the tables_flushed file

Known Issues:

• Server cannot be started using 'service' command on Debian Stretch.

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST.

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.28 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.28.

Galera Cluster 5.7 is now available as targeted packages and package repositories for Debian, Ubuntu, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Known issues with this release:

• Server cannot be started using 'service' command on Debian Stretch.

• SST between 5.6 and 5.7 nodes is not supported

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST

• Compilation with DTrace enabled may fail, so -DENABLE_DTRACE=:BOOL=OFF may be given to cmake to disable DTrace

End of Life:

• This is the last release for OpenSUSE 13.2 and Ubuntu Trusty.

Changes to Repositories Structure

With the new release the repository structure is changed to allow for existence of all of the wsrep-patched mysql versions currently supported: 5.5 through 5.7. Thus the repository layout requires from the user to adjust his or her repository configuration to accomodate those changes. In order to have the WSREP and Galera library installed, one would need to add the following repositories: 1. Galera-3 repository for galera library: e.g. http://releases.galeracluster.com/galera-3// 2. Corresponding mysql-wsrep repository: e.g. http://releases.galeracluster.com/mysql-wsrep-/ here: ldist is Linux or BSD distribution (Ubuntu, Centos) and mversion is MySQL version, i.e. 5.5, 5.6, 5.7

How To Install

Repositories contain dummy or meta packages, called mysql-wsrep- which are convenience packages for installation of the corresponding version of WSREP. One can install the whole suite by running, for example: apt-get install mysql-wsrep-5.6 galera-3

Quirks for Ubuntu Xenial and 5.6

Due to the peculiarities of how apt resolves packages and presence of 5.7 libraries in Xenial repositories the command above might require additional steps/changes in order to succeed.

One would need to either configure apt pinning for codership repositories for them to have priority over upstream packages or to specify mysql-common package version explicitly as the one located in the WSREP repositories in order to get things installed.

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.23 and Galera 3.10, wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.23.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com, while previous releases remain available on LaunchPad. The source repositories and bug tracking are now on http://www.github.com/codership .

Notable bug fixes in MySQL-wsrep since last binary release by Codership (5.6.21):

• getifaddr() rather than ifconfig is used to detect the IP of the node, resulting in better compatibility with newer Linux distributions (codership/mysql-wsrep#45) .

New features and notable changes in MySQL 5.6.22 - 5.6.23:

• Support for SSL 2.0 and 3.0 has been disabled as they provide weak encryption;

• yaSSL was upgraded to version 2.3.7;

• Numerous fixes in InnoDB and native MySQL replication;

Known issues with this release:

• There is a package conflict on CentOS 6/7 which requires manual removal of postfix, mysql and mariadb libraries before installing mysql-wsrep

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.49 and Galera 3.16, wsrep API version 25.

This release incorporates all changes up to MySQL 5.5.49.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

Notable fixes in MySQL 5.5.49:

• mysql client programs now support the --ssl-mode option that can be used to force encryption to be used

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.54 and Galera 3.20, wsrep API version 25.

This release incorporates all changes up to MySQL 5.5.54.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE, SLES and FreeBSD. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

Notable bug fixes in MySQL-wsrep:

• Compilation with GCC 6 has been fixed (MW-332)

Notable fixes in Oracle MySQL Community Edition 5.5.54:

• Incompatible Change: The mysqld_safe script has been fortified against various security vulnerabilities

Known issues with this release:

• If using the Ubuntu 16.04 Xenial package, the server can not be bootstrapped using systemd. Please use the SysV init script with the 'bootstap' option to bootstrap the node. Note that a server that has been started that way can not be controlled via systemd and must be stopped using the SysV script. Normal server startup and shutdown is possible via systemd.

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.48 and Galera 3.15, wsrep API version 25.

This release incorporates all changes up to MySQL 5.5.48.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

Notable fixes in MySQL 5.5.48:

• yaSSL has been upgraded to version 2.3.9

• DROP TABLE statements that contain non-regular characters may cause replication to break (MySQL Bug #77249)

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.46 and Galera 3.13, wsrep API version 25.

This release incorporates all changes up to MySQL 5.5.46.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com, while previous releases remain available on LaunchPad. The source repositories and bug tracking are now on http://www.github.com/codership .

New features and notable changes in MySQL-wsrep since last binary release by Codership (5.5.45):

• A "compat" package is now provided to allow MySQL-wsrep to be installed without removing packages such as Postfix which depend on older MySQL versions

Notable bug fixes in MySQL-wsrep:

• IB atomic builtins are no longer used when compiling as they may cause the server to hang (codership/mysql-wsrep#221)

• query cache is now compatible with wsrep_sync_wait (codership/mysql-wsrep#201)

New features and notable changes in MySQL 5.5.46:

• yaSSL was upgraded to version 2.3.8

• Miscellaneous fixes in InnoDB

Changes in MySQL-wsrep 8.4.4-26.22 (2025-02-25)

Codership is pleased to announce the first LTS release of Galera Cluster for MySQL 8.4, consisting of MySQL-wsrep 8.4.4 and wsrep API version 26.

This release incorporates all changes up to MySQL 8.4.4.

Galera Cluster 8.4 is available as targeted packages and package repositories for Debian 11 (Bullseye), and 12 (Bookworm), Ubuntu 22.04 LTS (Jammy), and 24.04 LTS (Noble), RHEL 8, and 9. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep in 8.4.3-26.21:

• Fixed issue with GRANT/REVOKE role statements not replicating across nodes (codership/mysql-wsrep#421)

• Improved error handling in wsrep_sync_wait() by moving error handling to the end of dispatch_command()

• Fixed transaction handling with BF aborts during COMMIT statements (MDEV-35446)

• Fixed an issue where transactions that were BF aborted during COMMIT could incorrectly succeed

Known Issues:

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST.

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 8.0.22 and Galera 4.7, wsrep API version 26.

This release incorporates all changes up to MySQL 8.0.22 and numerous fixes and enhancements specific to Galera replication.

Notable new features in MySQL-wsrep 8.0 since latest release 8.0.21-26.4.

• A new SST method based on Clone plugin was added.

• A new variable wsrep_mode was introduced to wsrep behavior. The first application of the variable is to allow ignoring native replication filter rules if configured with replicate-do-db (codership/mysql-wsrep#372).

• Logging was improved to display the origin of wsrep-lib and Galera related messages. Log messages prefixed with P come from Galera library, messages prefixed with L come from wsrep-lib.

Notable fixes in MySQL-wsrep since latest release 8.0.21-26.4.

• Load data failure with foreign keys was fixed (codership/mysql-wsrep#375).

• PS protocol compatibility with MySQL-wsrep was improved.

• FreeBSD compatibility for Xtrabackup v2 SST script was improved (codership/mysql-wsrep#379).

• BF-BF conflicts between OPTIMIZE/REPAIR/ALTER TABLE and DML in precense of foreign key constraints were suppressed (MDEV-21577).

XtraBackup compatibility:

• Percona XtraBackup version 8.0.22-15.0 or higher is required to perform XtraBackup based SSTs.

The packages are available from https://releases.galeracluster.com/ for the following operating systems:

• CentOS 7 and 8

• Debian 10

• RedHat 7 and 8

• SLES 15 SP 1

Known issues with this release:

• When installing software on CentOS 8, dnf modules mysql and mariadb must be disabled before installing Galera Cluster software. This can be done by running dnf module disable mysql mariadb.

• When installing software in Ubuntu 20.04, in order to select correct versions of mysql-common and mysql-client packages, the following must be run before installing mysql-wsrep-8.0 package

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 8.0.21 and Galera 4.6, wsrep API version 26.

This release incorporates all changes up to MySQL 8.0.21 and numerous fixes and enhancements specific to Galera replication.

New features in MySQL-wsrep since latest release 8.0.19-26.3.

• Audit log plugin was merged from Percona XTraDB Cluster.

Notable fixes in MySQL-wsrep since latest release 8.0.19-26.3.

• Wsrep patch was reworked to work with CATS InnoDB transaction scheduling algorithm.

• Deadlock between DDL and applying transaction was fixed.

• Server crash when starting transaction with wsrep_on disabled was fixed.

• Several memory leaks and memory access errors reported by AddressSanitizer were fixed.

• Generic binary tarball package was included in this release.

• Fix for vulnerability CVE-2020-15180.

The packages are available from https://releases.galeracluster.com/ for the following operating systems:

• CentOS 7 and 8

• Debian 10

• RedHat 8 and 8

• SLES 15 SP 1

End of life notice:

This is the last release for openSUSE 15.0.

Known issues with this release:

• When installing software on CentOS 8, dnf modules mysql and mariadb must be disabled before installing Galera Cluster software. This can be done by running dnf module disable mysql mariadb.

• When installing software in Ubuntu 20.04, in order to select correct versions of mysql-common and mysql-client packages, the following must be run before installing mysql-wsrep-8.0 package

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.17 and Galera 3.20, wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.17.

Galera Cluster 5.7 is now available as targeted packages and package repositories for Debian, Ubuntu and CentOS. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com.

Notable changes in this release:

• If needed, initialization of the initial MySQL database can be performed using the --initialize command:

  Copy

  sudo /usr/sbin/mysqld --user=mysql --initialize --log-error=/tmp/mysqld_initialize.log

• On systemd systems, bootstrapping the first node of the cluster is performed using the following command:

Notable bug fixes in MySQL-wsrep:

• Using Galera cluster as an asynchronous replication slave with replication filtering could cause holes to form in the GTID sequence (MW-319)

• An assertion could occur if --wsrep_log_conflicts=ON is used and the server was compiled with assertions enabled (MW-28, codership/mysql-wsrep#28)

• If Galera had to perform transaction replaying on a particular transaction, the "affected rows" field in the message returned to the client could be incorrect (MW-329)

Known issues with this release:

• SST between 5.6 and 5.7 nodes is not supported;

• The --wsrep-replication-bundle option has no effect and may be removed in a future release

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST

• Compilation with DTrace enabled may fail, so -DENABLE_DTRACE=0 may be used to disable DTrace

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.18 and Galera 3.21, wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.18.

Galera Cluster 5.7 is now available as targeted packages and package repositories for Debian, Ubuntu and CentOS. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com.

Notable bug fixes in MySQL-wsrep:

• Fix for thread leak when changing the value of wsrep_slave_threads (MW-336)

• The issue of DROP TABLE containing temporary tables resulting in binlog divergence has been fixed (MW-360)

• RESET MASTER is now rejected if the wsrep provider is enabled and gtid_mode is ON (MW-362)

• InnoDB buffer pool is not dumped anymore at server shutdown when --wsrep-recover option is given (MW-365)

• Improved IPv6 support (MW-366)

• Fixes for certfication key generation in the presence of foreign key constraints (MW-369)

• Fix to debug assertion MW-379

• SHOW STATUS will not block anymore with wsrep_sync_wait=1 (MW-86)

Known issues with this release:

• Server cannot be started using 'service' command on Debian Stretch.

• SST between 5.6 and 5.7 nodes is not supported

• The --wsrep-replication-bundle option has no effect and may be removed in a future release

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST

Changes to Repositories Structure

With the new release the repository structure is changed to allow for existence of all of the wsrep-patched mysql versions currently supported: 5.5 through 5.7. Thus the repository layout requires from the user to adjust his or her repository configuration to accomodate those changes. In order to have the WSREP and Galera library installed, one would need to add the following repositories: 1. Galera-3 repository for galera library: e.g. http://releases.galeracluster.com/galera-3// 2. Corresponding mysql-wsrep repository: e.g. http://releases.galeracluster.com/mysql-wsrep-/ here: ldist is Linux or BSD distribution (Ubuntu, Centos) and mversion is MySQL version, i.e. 5.5, 5.6, 5.7

How To Install

Repositories contain dummy or meta packages, called mysql-wsrep- which are convenience packages for installation of the corresponding version of WSREP. One can install the whole suite by running, for example: apt-get install mysql-wsrep-5.6 galera-3

Quirks for Ubuntu Xenial and 5.6

Due to the peculiarities of how apt resolves packages and presence of 5.7 libraries in Xenial repositories the command above might require additional steps/changes in order to succeed.

One would need to either configure apt pinning for codership repositories for them to have priority over upstream packages or to specify mysql-common package version explicitly as the one located in the WSREP repositories in order to get things installed.

Changes in MySQL-wsrep 8.0.33-26.14 (2023-06-16)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.33 and wsrep API version 26.

This release incorporates all changes up to MySQL 8.0.33.

Galera Cluster 8.0 is available as targeted packages and package repositories for Debian, Ubuntu, CentOS and RHEL. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep since the latest release 8.0.32-26.13:

• when inside a stored function or trigger, the current statement transaction should not allow commit or rollback

Changes in MySQL-wsrep 8.0.40-26.21 (2024-12-03)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.40 and wsrep API version 26.

This release incorporates all changes up to MySQL 8.0.40.

Galera Cluster 8.0 is available as targeted packages and package repositories for Debian 11 (Bullseye), and 12 (Bookworm), Ubuntu 20.04 LTS (Focal), 22.04 LTS (Jammy), and 24.04 LTS (Noble), RHEL 8, and 9. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep since the latest release 8.0.39-26.20:

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.32 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.32.

Galera Cluster 5.7 is now available as targeted packages and package repositories for Debian, Ubuntu, CentOS, RHEL and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable new features in MYSQL-wsrep 5.7 subce latest release 5.7.32-25.24.

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.46 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.46.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com.

The latest version of MySQL-wsrep 5.6 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Known issues with this release:

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.42 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.42.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com.

The latest version of MySQL-wsrep 5.6 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on http://www.github.com/codership.

New features in MySQL-wsrep:

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.43 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.43.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com.

The latest version of MySQL-wsrep 5.6 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Known issues with this release:

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.38 and Galera 3.22, wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.38.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com.

The latest version of MySQL-wsrep 5.6 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on http://www.github.com/codership.

Notable bug fixes in MySQL-wsrep:

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.61 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.5.61.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership.

Notable bug fixes in MySQL-wsrep:

• New configuration option wsrep_certification_rules to enable more relaxed certification rules for foreign key references on child table inserts. This option is effective only with Galera version 3.24 or higher (galera#491).

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.53 and Galera 3.19, wsrep API version 25.

This release incorporates all changes up to MySQL 5.5.53.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

Notable fixes in Oracle MySQL Community Edition 5.5.53:

• Incompatible change: The behavior of the --secure_file_priv option has changed and additional checks are performed on the value at server startup. The default value on most platforms has been changed to /var/lib/mysql-files. That directory is created at package installation time.

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.45 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.45.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com.

The latest version of MySQL-wsrep 5.6 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Known issues with this release:

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.29 and Galera 3.15, wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.29.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

New features and notable changes in MySQL-wsrep since last binary release by Codership (5.6.28):

• A new variable, wsrep_dirty_reads can be used to enable reading from a non-primary node

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.45 and Galera 3.12, wsrep API version 25.

This release incorporates all changes up to MySQL 5.5.45.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com, while previous releases remain available on LaunchPad. The source repositories and bug tracking are now on http://www.github.com/codership .

New features and notable changes in MySQL-wsrep since last binary release by Codership (5.5.42):

• The SST password is no longer passed via the command line or visble in the error log or 'ps' output (codership/mysql-wsrep#141)

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.55 and Galera 3.21, wsrep API version 25.

This release incorporates all changes up to MySQL 5.5.55.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE, SLES and FreeBSD. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

Notable bug fixes in MySQL-wsrep:

• CREATE TABLE AS SELECT fixes (MW-322)

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.58 and Galera 3.22, wsrep API version 25.

This release incorporates all changes up to MySQL 5.5.58.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership.

Notable bug fixes in MySQL-wsrep:

• Avoid returning outdated values for wsrep_ready status variable (MW-384)

Changes in MySQL-wsrep 8.0.41-26.22 (2025-02-25)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.41 and wsrep API version 26.

This release incorporates all changes up to MySQL 8.0.41.

Galera Cluster 8.0 is available as targeted packages and package repositories for Debian 11 (Bullseye), and 12 (Bookworm), Ubuntu 20.04 LTS (Focal), 22.04 LTS (Jammy), and 24.04 LTS (Noble), RHEL 8, and 9. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep since the latest release 8.0.40-26.21:

Changes in MySQL-wsrep 5.7.34-25.26 (2021-07-26)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.34 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.34.

Galera Cluster 5.7 is available as targeted packages and package repositories for Debian, Ubuntu, CentOS, RHEL and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD will be available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable fixes in MySQL-wsrep since the latest release 5.7.33-25.25:

• SST scripts for rsync and xtrabackup-v2 SST methods now accept ssl-ca, ssl-cert and ssl-key configuration varibles either in [sst] or [mysqld] configuration section. The old variables tca, tcert and tkey are now deprecated but still accepted if they are present in [sst] section in the configuration file.

• Binlog purging was disabled when the mysqld server was started with --wsrep-recover option (codership/mysql-wsrep#381).

• Parallel applying of write sets to tables without primary key was disabled (MDEV-25551).

Packaging:

• A dependency to stunnel package was added as it is needed for rsync SST SSL support.

End of life notices:

• Ubuntu 16.04 (Xenial) has reached the end of the regular maintenance period. Therefore we plan to discontinue providing MySQL-wsrep packages for Ubuntu 16.04 after this release.

• Due to little usage pattern we plan to discontinue building MySQL-wsrep 5.7 packages for SUSE Linux Enterprise Server 12 after this release.

The users still running above discontinued platforms are adviced to use the binary tarball package.

Known issues with this release:

• Server cannot be started using 'service' command on Debian Stretch.

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST

• Compilation with DTrace enabled may fail, so -DENABLE_DTRACE=:BOOL=OFF may be given to cmake to disable DTrace

Changes to Repositories Structure

With the new release the repository structure is changed to allow for existence of all of the wsrep-patched mysql versions currently supported: 5.5 through 5.7. Thus the repository layout requires from the user to adjust his or her repository configuration to accomodate those changes. In order to have the WSREP and Galera library installed, one would need to add the following repositories: 1. Galera-3 repository for galera library: e.g. https://releases.galeracluster.com/galera-3/<ldist>/ 2. Corresponding mysql-wsrep repository: e.g. https://releases.galeracluster.com/mysql-wsrep-<mversion>/<ldist> here: ldist is Linux or BSD distribution (Ubuntu, Centos) and mversion is MySQL version, i.e. 5.6, 5.7 or 8.0

How To Install

Repositories contain dummy or meta packages, called mysql-wsrep- which are convenience packages for installation of the corresponding version of WSREP. One can install the whole suite by running, for example: apt-get install mysql-wsrep-5.7 galera-3

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.35 and Galera 3.20, wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.35.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE, SLES and FreeBSD. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

Notable bug fixes in MySQL-wsrep:

• Using Galera cluster as an asynchronous replication slave with replication filtering could cause holes to form in the GTID sequence (MW-319)

• An assertion could occur if --wsrep_log_conflicts=ON is used and the server was compiled with assertions enabled (MW-28, codership/mysql-wsrep#28)

• If Galera had to perform transaction replaying on a particular transaction, the "affected rows" field in the message returned to the client could be incorrect (MW-329)

• An "OK" message could be sent to the client even if a query was aborted due to a transaction conflict (MW-328)

• An error about a transaction conflict could be delivered to the next client statement, rather than the statement it was about (MW-328)

• Compilation with GCC 6 has been fixed (MW-332)

• Running a ROLLBACK TO SAVEPOINT statement could cause the cluster to hang (MW-253)

New features, notable changes and bug fixes in Oracle MySQL 5.6.35:

• Incompatible Change: The mysqld_safe script has been fortified against various security vulnerabilities

• INSERT operations on a table with an auto_increment key could result in a duplicate key error (Bug #76872)

Known issues with this release:

• If using the Ubuntu 16.04 Xenial package, the server can not be bootstrapped using systemd. Please use the SysV init script with the 'bootstap' option to bootstrap the node. Note that a server that has been started that way can not be controlled via systemd and must be stopped using the SysV script. Normal server startup and shutdown is possible via systemd.

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.29 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.29.

Galera Cluster 5.7 is now available as targeted packages and package repositories for Debian, Ubuntu, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable fixes in MySQL-wsrep since the last binary release by Codership (5.7.28-25.20).

• Fixed occasional hang during server shutdown. Due to race condition a client connection got sometimes stuck in waiting for network event from invalid file descriptor.

Known issues with this release:

• Server cannot be started using 'service' command on Debian Stretch.

• SST between 5.6 and 5.7 nodes is not supported

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST

• Compilation with DTrace enabled may fail, so -DENABLE_DTRACE=:BOOL=OFF may be given to cmake to disable DTrace

Changes to Repositories Structure

With the new release the repository structure is changed to allow for existence of all of the wsrep-patched mysql versions currently supported: 5.5 through 5.7. Thus the repository layout requires from the user to adjust his or her repository configuration to accomodate those changes. In order to have the WSREP and Galera library installed, one would need to add the following repositories: 1. Galera-3 repository for galera library: e.g. https://releases.galeracluster.com/galera-3/<ldist>/ 2. Corresponding mysql-wsrep repository: e.g. https://releases.galeracluster.com/mysql-wsrep-<mversion>/<ldist> here: ldist is Linux or BSD distribution (Ubuntu, Centos) and mversion is MySQL version, i.e. 5.5, 5.6, 5.7

How To Install

Repositories contain dummy or meta packages, called mysql-wsrep- which are convenience packages for installation of the corresponding version of WSREP. One can install the whole suite by running, for example: apt-get install mysql-wsrep-5.6 galera-3

Quirks for Ubuntu Xenial and 5.6

Due to the peculiarities of how apt resolves packages and presence of 5.7 libraries in Xenial repositories the command above might require additional steps/changes in order to succeed.

One would need to either configure apt pinning for codership repositories for them to have priority over upstream packages or to specify mysql-common package version explicitly as the one located in the WSREP repositories in order to get things installed.

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.59 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.5.59.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership.

Notable bug fixes in MySQL-wsrep:

Reminder: Changes to Repositories Structure

With the new release the repository structure is changed to allow for existence of all of the wsrep-patched mysql versions currently supported: 5.5 through 5.7. Thus the repository layout requires from the user to adjust his or her repository configuration to accomodate those changes. In order to have the WSREP and Galera library installed, one would need to add the following repositories: 1. Galera-3 repository for galera library: e.g. http://releases.galeracluster.com/galera-3// 2. Corresponding mysql-wsrep repository: e.g. http://releases.galeracluster.com/mysql-wsrep-/ here: ldist is Linux or BSD distribution (Ubuntu, Centos) and mversion is MySQL version, i.e. 5.5, 5.6, 5.7

How To Install

Repositories contain dummy or meta packages, called mysql-wsrep- which are convenience packages for installation of the corresponding version of WSREP. One can install the whole suite by running, for example: apt-get install mysql-wsrep-5.6 galera-3

Quirks for Ubuntu Xenial and 5.6

Due to the peculiarities of how apt resolves packages and presence of 5.7 libraries in Xenial repositories the command above might require additional steps/changes in order to succeed.

One would need to either configure apt pinning for codership repositories for them to have priority over upstream packages or to specify mysql-common package version explicitly as the one located in the WSREP repositories in order to get things installed.

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.41 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.41.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com.

The latest version of MySQL-wsrep 5.6 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on http://www.github.com/codership.

• New configuration option wsrep_certification_rules to enable more relaxed certification rules for foreign key references on child table inserts. This option is effective only with Galera version 3.24 or higher (galera#491).

• Fixed a resource leak in case of ROLLBACK TO SAVEPOINT which was followed by COMMIT (mysql-wsrep#318).

• InnoDB undo tablespaces are now included in rsync SST (mysql-wsrep#337).

• FK constraint violation in applier after ALTER TABLE ADD FK was fixed by adding both parent and child table keys into ALTER TOI write set (mysql-wsrep#332).

• Memory leak with native MySQL replication when InnoDB was used as a relay log info and master info repository has been fixed. (mysql-wsrep#329).

Known issues with this release:

• If using the Ubuntu 16.04 Xenial package, the server can not be bootstrapped using systemd. Please use the SysV init script with the 'bootstap' option to bootstrap the node. Note that a server that has been started that way can not be controlled via systemd and must be stopped using the SysV script. Normal server startup and shutdown is possible via systemd.

• Server cannot be started using 'service' command on Debian Stretch.

Reminder: Changes to Repositories Structure

With the new release the repository structure is changed to allow for existence of all of the wsrep-patched mysql versions currently supported: 5.5 through 5.7. Thus the repository layout requires from the user to adjust his or her repository configuration to accomodate those changes. In order to have the WSREP and Galera library installed, one would need to add the following repositories: 1. Galera-3 repository for galera library: e.g. http://releases.galeracluster.com/galera-3// 2. Corresponding mysql-wsrep repository: e.g. http://releases.galeracluster.com/mysql-wsrep-/ here: ldist is Linux or BSD distribution (Ubuntu, Centos) and mversion is MySQL version, i.e. 5.5, 5.6, 5.7

How To Install

Repositories contain dummy or meta packages, called mysql-wsrep- which are convenience packages for installation of the corresponding version of WSREP. One can install the whole suite by running, for example: apt-get install mysql-wsrep-5.6 galera-3

Quirks for Ubuntu Xenial and 5.6

Due to the peculiarities of how apt resolves packages and presence of 5.7 libraries in Xenial repositories the command above might require additional steps/changes in order to succeed.

One would need to either configure apt pinning for codership repositories for them to have priority over upstream packages or to specify mysql-common package version explicitly as the one located in the WSREP repositories in order to get things installed.

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.52 and Galera 3.18, wsrep API version 25.

This release incorporates all changes up to MySQL 5.5.52, including the fix for CVE-2016-6662.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

Notable fixes in Oracle MySQL Community Edition 5.5.51, 5.5.52:

• CVE-2016-6662. An authenticated remote user could leverage the mysqld_safe script to obtain elevated local privileges;

• It was possible to write log files ending with .ini or .cnf that later could be parsed as option files. The general query log and slow query log can no longer be written to a file ending with .ini or .cnf. (Bug #24388753)

• Privilege escalation was possible by exploiting the way REPAIR TABLE used temporary files. (Bug #24388746)

• Multiple buffer overflows were fixed

Known issues with this release:

• If using the Ubuntu 16.04 Xenial package, the server can not be bootstrapped using systemd. Please use the SysV init script with the 'bootstap' option to bootstrap the node. Note that a server that has been started that way can not be controlled via systemd and must be stopped using the SysV script. Normal server startup and shutdown is possible via systemd.

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.62 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.5.62.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership.

Note that Galera Cluster for MySQL 5.5.62 will be the last release of 5.5 series.

Notable bug fixes in MySQL-wsrep:

• Maximum variable length was increased to 4096 in order to work around wsrep_provider_options truncation if the provider options string contains long variable values (mysql-wsrep#348).

Reminder: Changes to Repositories Structure

With the new release the repository structure is changed to allow for existence of all of the wsrep-patched mysql versions currently supported: 5.5 through 5.7. Thus the repository layout requires from the user to adjust his or her repository configuration to accomodate those changes. In order to have the WSREP and Galera library installed, one would need to add the following repositories: 1. Galera-3 repository for galera library: e.g. http://releases.galeracluster.com/galera-3// 2. Corresponding mysql-wsrep repository: e.g. http://releases.galeracluster.com/mysql-wsrep-/ here: ldist is Linux or BSD distribution (Ubuntu, Centos) and mversion is MySQL version, i.e. 5.5, 5.6, 5.7

How To Install

Repositories contain dummy or meta packages, called mysql-wsrep- which are convenience packages for installation of the corresponding version of WSREP. One can install the whole suite by running, for example: apt-get install mysql-wsrep-5.6 galera-3

Quirks for Ubuntu Xenial and 5.6

Due to the peculiarities of how apt resolves packages and presence of 5.7 libraries in Xenial repositories the command above might require additional steps/changes in order to succeed.

One would need to either configure apt pinning for codership repositories for them to have priority over upstream packages or to specify mysql-common package version explicitly as the one located in the WSREP repositories in order to get things installed.

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.50 and Galera 3.17, wsrep API version 25.

This release incorporates all changes up to MySQL 5.5.50.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

New features and notable changes in MySQL-wsrep since last binary release by Codership (5.5.49):

• An experimental package for Ubuntu 16.04 Xenial is now available. Please see below for more information.

Notable bug fixes in MySQL-wsrep:

• The server returned stale values from the NOW() function if transaction replay has happened on the connection.

Notable fixes in Oracle MySQL Community Edition 5.5.50:

• Several potential buffer overflow issues have been fixed.

Known issues with this release:

• If using the Ubuntu 16.04 Xenial package, the server can not be bootstrapped using systemd. Please use the SysV init script with the 'bootstap' option to bootstrap the node. Note that a server that has been started that way can not be controlled via systemd and must be stopped using the SysV script. Normal server startup and shutdown is possible via systemd.

Changes in MySQL-wsrep 5.7.39-25.31 (2022-10-27)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.39 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.39.

Galera Cluster 5.7 is available as targeted packages and package repositories for Debian, Ubuntu, CentOS and RHEL. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD will be available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep since the latest release 5.7.38-25.30:

• The InnoDB wsrep applier lock wait timeout from 8.0 has been backported. In introduces the innodb-wsrep-applier-lock-wait-timeout variable to improve the reliability in resolving cluster conflicts.

• The variable wsrep_slave_UK_checks has been deprecated and the default behaviour has changed to being ON.

Known Issues:

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST.

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.42 and Galera 3.10, wsrep API version 25.

This release incorporates all changes up to MySQL 5.5.42.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com, while previous releases remain available on LaunchPad. The source repositories and bug tracking are now on http://www.github.com/codership .

New features and notable changes in MySQL-wsrep since last binary release by Codership (5.5.37):

• The wsrep_causal_reads variable has been deprecated. A new variable, wsrep_sync_wait, has been introduced to allow causal checks to be specified separately for selects, updates and inserts (lp:1277053)

• improved support for distributions based on the .deb package format, such as Ubuntu

Notable bug fixes in MySQL-wsrep:

• getifaddr() rather than ifconfig is used to detect the IP of the node, resulting in better compatibility with newer Linux distributions (codership/mysql-wsrep#45) .

• Table administration commands such as CHECK TABLE are now replicated (lp:1046726)

• Improvements in the replication of events (lp:1312618)

• SST could fail with thousands of tables (lp:1294431)

New features and notable changes in MySQL 5.5.38 - 5.5.42:

• Support for SSL 2.0 and 3.0 has been disabled as they provide weak encryption;

• Security issue with ALTER TABLE ... ADD FOREIGN KEY has been fixed (Bug #19471516, Bug #73650)

• yaSSL was upgraded to version 2.3.7;

• TRUNCATE TABLE is logged only when it executes successfully, in order to prevent inconsistencies. (Bug #17942050, Bug #71070)

Known issues with this release:

• There is a package conflict on CentOS 6/7 which requires manual removal of postfix, mysql and mariadb libraries before installing mysql-wsrep

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 8.0.23 and wsrep API version 26.

This release incorporates all changes up to MySQL 8.0.23 and numerous fixes and enhancements specific to Galera replication.

Notable fixes changes in behavior in MySQL-wsrep since latest release 8.0.22-26.5.

• Fixed Clone SST to work with binary tarball installations (codership/mysql-wsrep#386).

• Fixed performance regression on conflict heavy load.

• Fixed mysqldump SST script to keep general_log, slow_query_log global variable values intact on donor (codership/mysql-wsrep#108).

• Added IPv6 support to CLONE SST script.

• If system variable bind_address contains list of addresses, wsrep bind addresses wsrep incoming address list are populated by using the first one.

• Audig log plugin was added into Debian packages.

• OpenSSL version in binary tarball build was bumped to 1.1.1k.

• Global variables wsrep_provider and wsrep_notify_cmd were made read-only.

• CREATE TABLE AS SELECT cannot be used to create non-InnoDB tables in cluster.

Notable new features in MySQL-wsrep 8.0 since latest release 8.0.22-26.5.

• Merged Percona PAM plugin from Percona XtraDB Cluster.

• Merged Percona Simple LDAP plugin from Percona XtraDB Cluster.

XtraBackup compatibility:

• Percona XtraBackup version 8.0.23-16.0 or higher is required to perform XtraBackup based SSTs.

The packages are available from https://releases.galeracluster.com/ for the following operating systems:

• CentOS 7 and 8

• Debian 10

• RedHat 7 and 8

• SLES 15 SP 1

Known issues with this release:

• When installing software on CentOS 8, dnf modules mysql and mariadb must be disabled before installing Galera Cluster software. This can be done by running dnf module disable mysql mariadb.

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.30 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.30.

Galera Cluster 5.7 is now available as targeted packages and package repositories for Debian, Ubuntu, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable fixes in MySQL-wsrep since the last binary release by Codership (5.7.29-25.21).

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.39 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.39.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com.

The latest version of MySQL-wsrep 5.6 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on http://www.github.com/codership.

Notable bug fixes in MySQL-wsrep:

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.20 and Galera 3.22, wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.20.

Galera Cluster 5.7 is now available as targeted packages and package repositories for Debian, Ubuntu, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on http://www.github.com/codership.

Notable bug fixes in MySQL-wsrep:

• Preserve

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.49 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.49.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 5.6 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable fixes in MySQL-wsrep since the last binary release by Codership (5.6.48-25.30).

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.36 and Galera 3.21, wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.36.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE, SLES and FreeBSD. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

Notable bug fixes in MySQL-wsrep:

• CREATE TABLE AS SELECT fixes (MW-317, MW-322)

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.33 and Galera 3.18, wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.33, including the fix for CVE-2016-6662

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

Notable bug fixes in MySQL-wsrep:

• Galera would crash on startup if compiled with GCC 6 (MW-267, codership/mysql-wsrep#267)

New features, notable changes and bug fixes in Oracle MySQL 5.6.32 and 5.6.33:

Changes in MySQL-wsrep 8.4.5-26.23 (2025-06-23)

Codership is pleased to announce the first LTS release of Galera Cluster for MySQL 8.4, consisting of MySQL-wsrep 8.4.5 and wsrep API version 26.

This release incorporates all changes up to MySQL 8.4.5.

Galera Cluster 8.4 is available as targeted packages and package repositories for Debian 11 (Bullseye), and 12 (Bookworm), Ubuntu 22.04 LTS (Jammy), and 24.04 LTS (Noble), RHEL 8, and 9. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com or https://www.mariadb.com/ (as Codership has been acquired by MariaDB plc).

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep in 8.4.4-26.22:

• added WSREP_MODE_APPLIER_LOG_WARNINGS, to print warnings when a replicated row fails foreign-key checks

• added wsrep_applier_retry_count, and if set > 0 has the secondary re-try writeset application up to n times instead of hard aborting on the first error (the default is 0)

• Fix heap-buffer-overflow crash on FK cascades into VARCHAR columns

• Replicated DELETE that loses its parent table is now forced single-thread to keep order

• Applier logs extra FK failure detail when WSREP_MODE_APPLIER_LOG_WARNINGS is enabled

• server_uuid no longer saved as all-zeroes on first start with wsrep_sync_server_uuid = ON

• FLUSH TABLES WITH READ LOCK now returns an error when the node is in a non-primary component instead of hanging

• Attempting TOI operations after an FTWRL desync now raises ER_UNKNOWN_COM_ERROR instead of crashing the server

Known Issues:

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST.

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.31 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.31.

Galera Cluster 5.7 is now available as targeted packages and package repositories for Debian, Ubuntu, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable fixes in MySQL-wsrep since the last binary release by Codership (5.7.30-25.22).

• Binary tarball package is compiled with OpenSSL 1.1.1g.

• Deadlock between DDL and applying transaction was fixed.

• Fix for the following security vulnerability CVE-2020-15180.

End of Life Notice:

This is the last release for Debian Jessie and openSUSE 15.0.

Known issues with this release:

• Server cannot be started using 'service' command on Debian Stretch.

• SST between 5.6 and 5.7 nodes is not supported

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST

• Compilation with DTrace enabled may fail, so -DENABLE_DTRACE=:BOOL=OFF may be given to cmake to disable DTrace

Changes to Repositories Structure

With the new release the repository structure is changed to allow for existence of all of the wsrep-patched mysql versions currently supported: 5.5 through 5.7. Thus the repository layout requires from the user to adjust his or her repository configuration to accomodate those changes. In order to have the WSREP and Galera library installed, one would need to add the following repositories: 1. Galera-3 repository for galera library: e.g. https://releases.galeracluster.com/galera-3/<ldist>/ 2. Corresponding mysql-wsrep repository: e.g. https://releases.galeracluster.com/mysql-wsrep-<mversion>/<ldist> here: ldist is Linux or BSD distribution (Ubuntu, Centos) and mversion is MySQL version, i.e. 5.5, 5.6, 5.7

How To Install

Repositories contain dummy or meta packages, called mysql-wsrep- which are convenience packages for installation of the corresponding version of WSREP. One can install the whole suite by running, for example: apt-get install mysql-wsrep-5.7 galera-3

Changes in MySQL-wsrep 5.7.38-25.30 (2022-08-19)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.38 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.38.

Galera Cluster 5.7 is available as targeted packages and package repositories for Debian, Ubuntu, CentOS and RHEL. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD will be available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep since the latest release 5.7.37-25.29:

• Distinguish between unset ssl_mode and ssl_mode explicitly set to "DISABLED"

Known Issues:

• Server cannot be started using 'service' command on Debian Stretch.

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST.

EOL Notice:

• This will be the last release for Debian 9 "Stretch" as it became EOL June 30,

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.47 and Galera 3.14, wsrep API version 25.

This release incorporates all changes up to MySQL 5.5.47.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

Notable bug fixes in MySQL-wsrep 5.5.47:

• Limit binlog recovery so that the wsrep position found from storage engines is not exceeded. This is required to have consistent position between wsrep position stored in innodb header and recovered binlog (codership/mysql-wsrep#226)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.24 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.24.

Galera Cluster 5.7 is now available as targeted packages and package repositories for Debian, Ubuntu, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on http://www.github.com/codership.

New features in MySQL-wsrep:

• Auth_pam and auth_dialog plugins were added in this release.

• Support for Ubuntu/Bionic was added in this release.

Notable bug fixes in MySQL-wsrep:

• Rsync SST was not copying tablespace from the donor node (mysql-wsrep#334).

• Fixes for transaction replaying from stored procedures (mysql-wsrep#336).

• Fixed a regression where transaction replaying caused a crash when AUTOCOMMIT=OFF (mysql-wsrep#344).

• Fixes for transaction replaying from event scheduler (mysql-wsrep#347).

Known issues with this release:

• Server cannot be started using 'service' command on Debian Stretch.

• SST between 5.6 and 5.7 nodes is not supported

• The --wsrep-replication-bundle option has no effect and may be removed in a future release

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST

Changes to Repositories Structure

With the new release the repository structure is changed to allow for existence of all of the wsrep-patched mysql versions currently supported: 5.5 through 5.7. Thus the repository layout requires from the user to adjust his or her repository configuration to accomodate those changes. In order to have the WSREP and Galera library installed, one would need to add the following repositories: 1. Galera-3 repository for galera library: e.g. http://releases.galeracluster.com/galera-3// 2. Corresponding mysql-wsrep repository: e.g. http://releases.galeracluster.com/mysql-wsrep-/ here: ldist is Linux or BSD distribution (Ubuntu, Centos) and mversion is MySQL version, i.e. 5.5, 5.6, 5.7

How To Install

Repositories contain dummy or meta packages, called mysql-wsrep- which are convenience packages for installation of the corresponding version of WSREP. One can install the whole suite by running, for example: apt-get install mysql-wsrep-5.6 galera-3

Quirks for Ubuntu Xenial and 5.6

Due to the peculiarities of how apt resolves packages and presence of 5.7 libraries in Xenial repositories the command above might require additional steps/changes in order to succeed.

One would need to either configure apt pinning for codership repositories for them to have priority over upstream packages or to specify mysql-common package version explicitly as the one located in the WSREP repositories in order to get things installed.

Changes in MySQL-wsrep 8.0.26-26.8 (2021-11-15)

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 8.0.26 and wsrep API version 26.

This release incorporates all changes up to MySQL 8.0.26.

Galera Cluster 8.0 is available as targeted packages and package repositories for Debian, Ubuntu, CentOS and RHEL. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

Notable changes and fixes in MySQL-wsrep since the latest release 8.0.25-26.7:

• New wsrep_mode IGNORE_CASCADING_FK_DELETE_MISSING_ROW_ERROR was added to work around applying errors with cascading delete. This is a workaround for https://bugs.mysql.com/bug.php?id=80821.

• A rare deadlock between cluster configuration change and FLUSH TABLES WITH READ LOCK was fixed.

• Executing FLUSH TABLES is now allowed also when not in primary component.

• A bug which caused streaming replication transaction to roll back locally but not in the cluster was fixed (MDEV-26707).

• New SST configuration options donor-timeout and joiner-timeout were added.

• MDL BF-BF conflict between ALTER and UPDATE was fixed. A certification key corresponding to MDL lock taken for table referenced by foreign key constraint is added to write set to make parallel applying dependencies correct.

• Write set applying reliability was improved by introducing periodic check for long lock waits for applied write sets.

• Terminology change: The use of 'master' and 'slave' was deprecated. The following system variables were renamed:

  • wsrep_slave_threads -> wsrep_applier_threads

  • wsrep_slave_FK_checks -> wsrep_applier_FK_checks
• Packages for Debian 11/Bullseye are now provided.

• OpenSSL library version has been updated to version 1.1.1l in binary tarball release.

XtraBackup compatibility:

• Percona XtraBackup version 8.0.26-18.0 or higher is required to perform XtraBackup based SSTs.

End of life notice:

• Due to little usage pattern building MySQL-wsrep 8.0 packages for SUSE Linux Enterprise Server 15 was discontinued.

The users still running above discontinued platforms are advised to use the binary tarball package.

Known issues with this release:

• When installing software on CentOS 8, dnf modules mysql and mariadb must be disabled before installing Galera Cluster software. This can be done by running dnf module disable mysql mariadb.

Changes in MySQL-wsrep 8.4.3-26.21 (2024-12-03)

Codership is pleased to announce the first LTS release of Galera Cluster for MySQL 8.4, consisting of MySQL-wsrep 8.4.3 and wsrep API version 26.

This release incorporates all changes up to MySQL 8.4.3.

Galera Cluster 8.4 is available as targeted packages and package repositories for Debian 11 (Bullseye), and 12 (Bookworm), Ubuntu 22.04 LTS (Jammy), and 24.04 LTS (Noble), RHEL 8, and 9. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep in 8.4.2-26.20:

Changes in MySQL-wsrep 8.0.30-26.11 (2022-11-24)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.30 and wsrep API version 26.

This release incorporates all changes up to MySQL 8.0.30.

Galera Cluster 8.0 is available as targeted packages and package repositories for Debian, Ubuntu, CentOS and RHEL. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 8.0 for FreeBSD will be available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep since the latest release 8.0.28-26.10:

Changes in MySQL-wsrep 8.4.2-26.20 (2024-08-02)

Codership is pleased to announce the first beta release of Galera Cluster for MySQL 8.4, consisting of MySQL-wsrep 8.4.2 and wsrep API version 26.

This release incorporates all changes up to MySQL 8.4.2.

Galera Cluster 8.4 is available as targeted packages and package repositories for Debian 11 (Bullseye), and 12 (Bookworm), Ubuntu 22.04 LTS (Jammy), and 24.04 LTS (Noble), CentOS 7 and RHEL 7, 8, and 9. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep in 8.4.2-26.20:

Changes in MySQL-wsrep 8.0.37-26.19 (2024-07-01)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.37 and wsrep API version 26.

This release incorporates all changes up to MySQL 8.0.37.

Galera Cluster 8.0 is available as targeted packages and package repositories for Debian 10 (Buster), 11 (Bullseye), and 12 (Bookworm), Ubuntu 20.04 LTS (Focal), 22.04 LTS (Jammy), and 24.04 LTS (Noble), CentOS 7 and RHEL 7, 8, and 9. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep since the latest release 8.0.36-26.18:

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.27 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.27.

Galera Cluster 5.7 is now available as targeted packages and package repositories for Debian, Ubuntu, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable bugs fixed in this release:

• Fixed segmentation fault when setting

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.25 and Galera 3.12, wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.25.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com, while previous releases remain available on LaunchPad. The source repositories and bug tracking are now on http://www.github.com/codership .

New features and notable changes in MySQL-wsrep since last binary release by Codership (5.6.23):

• Various forms of FLUSH that are replicated in traditional MySQL async replication are now also replicated in Galera under TOI (codership/mysql-wsrep#67)

Changes in MySQL-wsrep 8.0.36-26.18 (2024-04-30)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.36 and wsrep API version 26.

This release incorporates all changes up to MySQL 8.0.36.

Galera Cluster 8.0 is available as targeted packages and package repositories for Debian 10 (Buster), 11 (Bullseye), and 12 (Bookworm), Ubuntu 20.04 LTS (Focal) and 22.04 LTS (Jammy), CentOS 7 and RHEL 7, 8, and 9. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep since the latest release 8.0.35-26.17:

Changes in MySQL-wsrep 8.0.27-26.9 (2022-02-14)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.27 and wsrep API version 25.

This release incorporates all changes up to MySQL 8.0.27

Galera Cluster 8.0 is available as targeted packages and package repositories for Debian, Ubuntu, CentOS and RHEL. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD will be available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep since the latest release 8.0.26-26.8:

Codership is pleased to announce a new beta release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.15 and Galera 3.18, wsrep API version 25.

This is a beta-quality release and should not be used in production. We welcome feedback about the release. You can use the bug tracker at

or you can email us at info@galeracluster.com

This release incorporates all changes up to MySQL 5.7.15.

Galera Cluster 5.7 beta is now available as targeted packages and package repositories for Ubuntu 16.06 and CentOS 7. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com.

Notable changes in this release:

• If needed, initialization of the initial MySQL database can be performed using the --initialize command:

Changes in MySQL-wsrep 5.7.42-25.34 (2023-06-16)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.42 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.42.

Galera Cluster 5.7 is available as targeted packages and package repositories for Debian, Ubuntu, CentOS and RHEL. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD will be available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

** WE HIGHLY RECOMMEND AN UPGRADE TO MySQL 8.0 AS MySQL 5.7 HAS END-OF-LIFE OCTOBER 2023. **

Notable changes and fixes in MySQL-wsrep since the latest release 5.7.41-25.33:

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.21 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.21.

Galera Cluster 5.7 is now available as targeted packages and package repositories for Debian, Ubuntu, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on http://www.github.com/codership.

Notable bug fixes in MySQL-wsrep:

• Changing the variable

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.33 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.33.

Galera Cluster 5.7 is now available as targeted packages and package repositories for Debian, Ubuntu, CentOS, RHEL and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable fixes in MySQL-wsrep since the last binary release by Codership (5.7.32-25.24).

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.30 and Galera 3.16, wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.30.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

New features and notable changes in MySQL-wsrep since last binary release by Codership (5.6.29):

• DDL statements are no longer recorded in the general log on the slaves (MW-44)

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.31 and Galera 3.17, wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.31.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

New features and notable changes in MySQL-wsrep since last binary release by Codership (5.6.30):

• An experimental package for Ubuntu 16.04 Xenial is now available. Please see below for more information.

Changes in MySQL-wsrep 5.7.43-25.35 (2023-08-18)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.43 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.43.

Galera Cluster 5.7 is available as targeted packages and package repositories for Ubuntu 18.04 LTS (Bionic), CentOS 7 and RHEL 7 and 8. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD will be available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

** WE HIGHLY RECOMMEND AN UPGRADE TO MySQL 8.0 AS MySQL 5.7 HAS END-OF-LIFE OCTOBER 2023. **

Notable changes and fixes in MySQL-wsrep since the latest release 5.7.42-25.34:

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.28 and Galera 3.14, wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.28.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

New features and notable changes in MySQL-wsrep since last binary release by Codership (5.6.27):

• If a query such as CREATE USER needs to be printed to the error log, any plaintext passwords will be obfuscated (codership/mysql-wsrep#216)

Changes in MySQL-wsrep 8.0.31-26.12 (2023-03-08)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.31 and wsrep API version 26.

This release incorporates all changes up to MySQL 8.0.31.

Galera Cluster 8.0 is available as targeted packages and package repositories for Debian, Ubuntu, CentOS and RHEL. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 8.0 for FreeBSD will be available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep since the latest release 8.0.30-26.11:

• mysqladmin now displays all status variables for wsrep, overriding the default upper limit to be read from the server

• a wsrep_diag.sql script contains useful diagnostics queries for troubleshooting wsrep related issues

• wsrep_recover script accepts now --basedir and --mysqld options to support installations in non-standard locations (codership/mysql-wsrep#409)

• better handling of Total Order Isolation, from mistakenly skipped replication to error reporting

• mysqld_bootstrap script handles interruptions

• now have version_comment variable to display server version releases

• the wsrep position can be recovered even if wsrep is off

• new wsrep_mode APPLIER_IGNORE_MISSING_TABLE which enables the server to skip failures with table open at applying time, but only if the log event contains other tables that are open. This is the default setting now, improving multi-table updates involving triggers

Known Issues:

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST.

Changes in MySQL-wsrep 5.7.40-25.32 (2023-03-08)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.40 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.40.

Galera Cluster 5.7 is available as targeted packages and package repositories for Debian, Ubuntu, CentOS and RHEL. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD will be available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

** WE HIGHLY RECOMMEND AN UPGRADE TO MySQL 8.0 AS MySQL 5.7 HAS END-OF-LIFE OCTOBER 2023. **

Notable changes and fixes in MySQL-wsrep since the latest release 5.7.39-25.31:

• wsrep_sync_wait is skipped during trigger execution

• a wsrep_diag.sql script contains useful diagnostics queries for troubleshooting wsrep related issues

• mysqld_bootstrap script handles interruptions

• wsrep_recover is an enhanced new addition, backported from 8.0 to aid in recovery of crashed clusters

• the wsrep position can be recovered even if wsrep is off

• new wsrep_mode APPLIER_IGNORE_MISSING_TABLE which enables the server to skip failures with table open at applying time, but only if the log event contains other tables that are open. This is the default setting now, improving multi-table updates involving triggers

• better handling of Total Order Isolation, from mistakenly skipped replication to error reporting

Known Issues:

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST.

Changes in MySQL-wsrep 8.0.28-26.10 (2022-05-16)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.27 and wsrep API version 25.

This release incorporates all changes up to MySQL 8.0.28.

Galera Cluster 8.0 is available as targeted packages and package repositories for Debian, Ubuntu, CentOS and RHEL. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 8.0 for FreeBSD will be available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep since the latest release 8.0.27-26.9:

• Progress reporting is implemented from the xtrabackup SST script. If pv is present, the SST stream is piped thru pv.

• Progress reporting for CLONE SST can be disabled if progress=none is set in [sst]

• wsrep_sst_rsync has been refactored

• wsrep_sst_xtrabackupv2 now includes the PORT variable by default (4444)

• fixes a crash on shutdown after starting an XA transaction (MDEV-26575) and also disallows XA when Galera library is loaded (XA is not supported in the community release edition)

• innodb_disallow_writes has been refactored to ensure that disk writes don't leak the mysql data directory when node is in SST donor state

• fixes a race condition in wsrep_sst_rsync by performing all disk IO blocking before creating the tables_flushed file

Known Issues:

• Server cannot be started using 'service' command on Debian Stretch.

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST.

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.50 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.50.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 5.6 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable fixes in MySQL-wsrep since the last binary release by Codership (5.6.49-25.31).

• FreeBSD compatibility for Xtrabackup v2 SST script was improved (codership/mysql-wsrep#379).

Known issues with this release:

• If using the Ubuntu 16.04 Xenial package, the server can not be bootstrapped using systemd. Please use the SysV init script with the 'bootstap' option to bootstrap the node. Note that a server that has been started that way can not be controlled via systemd and must be stopped using the SysV script. Normal server startup and shutdown is possible via systemd.

• Server cannot be started using 'service' command on Debian Stretch.

End of Life Notice:

• This is the last official build for CentOS 6 and RedHat 6.

• As MySQL 5.6 is nearing its end of life, upgrading to MySQL-wsrep 5.7 is highly recommended.

Reminder: Changes to Repositories Structure

With the new release the repository structure is changed to allow for existence of all of the wsrep-patched mysql versions currently supported: 5.5 through 5.7. Thus the repository layout requires from the user to adjust his or her repository configuration to accomodate those changes. In order to have the WSREP and Galera library installed, one would need to add the following repositories: 1. Galera-3 repository for galera library: e.g. https://releases.galeracluster.com/galera-3// 2. Corresponding mysql-wsrep repository: e.g. https://releases.galeracluster.com/mysql-wsrep-/ here: ldist is Linux or BSD distribution (Ubuntu, Centos) and mversion is MySQL version, i.e. 5.6, 5.7 or 8.0

How To Install

Repositories contain dummy or meta packages, called mysql-wsrep- which are convenience packages for installation of the corresponding version of WSREP. One can install the whole suite by running, for example: apt-get install mysql-wsrep-5.6 galera-3

Quirks for Ubuntu Xenial and 5.6

Due to the peculiarities of how apt resolves packages and presence of 5.7 libraries in Xenial repositories the command above might require additional steps/changes in order to succeed.

One would need to either configure apt pinning for codership repositories for them to have priority over upstream packages or to specify mysql-common package version explicitly as the one located in the WSREP repositories in order to get things installed.

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.34 and Galera 3.19, wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.34.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

Notable bug fixes in MySQL-wsrep:

• The ALTER USER statement is now replicated correctly (MW-305, codership/mysql-wsrep#292, lp1376269)

• The wsrep_max_ws_rows could cause SELECT queries that use temporary tables to return an error (MW-309, lp1638138)

New features, notable changes and bug fixes in Oracle MySQL 5.6.34:

• Incompatible change: The behavior of the --secure_file_priv option has changed and additional checks are performed on the value at server startup. The default value on most platforms has been changed to /var/lib/mysql-files. That directory is created at package installation time.

• The yaSSL library has been upgraded to 2.4.2.

Known issues with this release:

• If using the Ubuntu 16.04 Xenial package, the server can not be bootstrapped using systemd. Please use the SysV init script with the 'bootstap' option to bootstrap the node. Note that a server that has been started that way can not be controlled via systemd and must be stopped using the SysV script. Normal server startup and shutdown is possible via systemd.

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.25 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.25.

Galera Cluster 5.7 is now available as targeted packages and package repositories for Debian, Ubuntu, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

New features in MySQL-wsrep:

• Packages for openSUSE Leap 15 and Ubuntu 18.04 Bionic Beaver were added in this release.

Known issues with this release:

• Server cannot be started using 'service' command on Debian Stretch.

• SST between 5.6 and 5.7 nodes is not supported

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST

• Compilation with DTrace enabled may fail, so -DENABLE_DTRACE=:BOOL=OFF may be given to cmake to disable DTrace

Changes to Repositories Structure

With the new release the repository structure is changed to allow for existence of all of the wsrep-patched mysql versions currently supported: 5.5 through 5.7. Thus the repository layout requires from the user to adjust his or her repository configuration to accomodate those changes. In order to have the WSREP and Galera library installed, one would need to add the following repositories: 1. Galera-3 repository for galera library: e.g. http://releases.galeracluster.com/galera-3// 2. Corresponding mysql-wsrep repository: e.g. http://releases.galeracluster.com/mysql-wsrep-/ here: ldist is Linux or BSD distribution (Ubuntu, Centos) and mversion is MySQL version, i.e. 5.5, 5.6, 5.7

How To Install

Repositories contain dummy or meta packages, called mysql-wsrep- which are convenience packages for installation of the corresponding version of WSREP. One can install the whole suite by running, for example: apt-get install mysql-wsrep-5.6 galera-3

Quirks for Ubuntu Xenial and 5.6

Due to the peculiarities of how apt resolves packages and presence of 5.7 libraries in Xenial repositories the command above might require additional steps/changes in order to succeed.

One would need to either configure apt pinning for codership repositories for them to have priority over upstream packages or to specify mysql-common package version explicitly as the one located in the WSREP repositories in order to get things installed.

Changes in MySQL-wsrep 8.0.34-26.15 (2023-08-18)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.34 and wsrep API version 26.

This release incorporates all changes up to MySQL 8.0.34.

Galera Cluster 8.0 is available as targeted packages and package repositories for Debian 10 (Buster) and 11 (Bullseye), Ubuntu 18.04 LTS (Bionic), 20.04 LTS (Focal) and 22.04 LTS (Jammy), CentOS 7 and RHEL 7, 8, and 9. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep since the latest release 8.0.33-26.14:

• when the server as started with read-only=ON, the mode toggled off during concurrent load due to a race condition.

• 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 (not user visible, but notable as to how wsrep_retry_autocommit now works)

• INFO-level wsrep messages are now logged with SYSTEM_LEVEL priority by default, as WSREP information level messages are crucial for debugging replication issues. New variable, wsrep_info_level 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.

• Fix an inconsistency caused by ROLLBACK TO SAVEPOINT

• systemd multi-instance support fixed

Known Issues:

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST.

End of Life Notice:

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

Changes in MySQL-wsrep 5.7.36-25.28 (2022-02-14)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.36 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.36.

Galera Cluster 5.7 is available as targeted packages and package repositories for Debian, Ubuntu, CentOS and RHEL. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD will be available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep since the latest release 5.7.35-25.27:

• Parallel apply improvements: CREATE TABLE .. LIKE is marked as unsafe and a transaction is marked as unsafe when it traverses into a cascade delete operation. This fixes MDEV-26803.

• CREATE TABLE with FOREIGN KEY constraint failed to apply in parallel, now will get referenced tables appended as keys in the writeset. This fixes MDEV-27276.

End of life notices:

• We have stopped building CentOS 8 packages, and we cannot guarantee that packages built for Red Hat Enterprise Linux 8 will continue working for CentOS Stream.

The users still running above discontinued platforms are advised to use the binary tarball package.

Known Issues:

• Server cannot be started using 'service' command on Debian Stretch.

• InnoDB tablespaces outside of the data directory are not supported, as they may not be copied over during SST.

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.51 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.51.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 5.6 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable fixes in MySQL-wsrep since the last binary release by Codership (5.6.50-25.32).

• Fixed mysqldump SST script to keep general_log, slow_query_log global variable values intact on donor (codership/mysql-wsrep#108).

• Audit log plugin missing from Debian packages was added.

• OpenSSL version in binary tarball build was bumped to 1.1.1k.

• Global variables wsrep_provider and wsrep_notify_cmd were made read-only.

Known issues with this release:

• If using the Ubuntu 16.04 Xenial package, the server can not be bootstrapped using systemd. Please use the SysV init script with the 'bootstap' option to bootstrap the node. Note that a server that has been started that way can not be controlled via systemd and must be stopped using the SysV script. Normal server startup and shutdown is possible via systemd.

• Server cannot be started using 'service' command on Debian Stretch.

End of Life Notice:

• This is the last release build for MySQL-wsrep 5.6 series.

Reminder: Changes to Repositories Structure

With the new release the repository structure is changed to allow for existence of all of the wsrep-patched mysql versions currently supported: 5.5 through 5.7. Thus the repository layout requires from the user to adjust his or her repository configuration to accomodate those changes. In order to have the WSREP and Galera library installed, one would need to add the following repositories: 1. Galera-3 repository for galera library: e.g. https://releases.galeracluster.com/galera-3// 2. Corresponding mysql-wsrep repository: e.g. https://releases.galeracluster.com/mysql-wsrep-/ here: ldist is Linux or BSD distribution (Ubuntu, Centos) and mversion is MySQL version, i.e. 5.6, 5.7 or 8.0

How To Install

Repositories contain dummy or meta packages, called mysql-wsrep- which are convenience packages for installation of the corresponding version of WSREP. One can install the whole suite by running, for example: apt-get install mysql-wsrep-5.6 galera-3

Quirks for Ubuntu Xenial and 5.6

Due to the peculiarities of how apt resolves packages and presence of 5.7 libraries in Xenial repositories the command above might require additional steps/changes in order to succeed.

One would need to either configure apt pinning for codership repositories for them to have priority over upstream packages or to specify mysql-common package version explicitly as the one located in the WSREP repositories in order to get things installed.

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.44 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.44.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com.

The latest version of MySQL-wsrep 5.6 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Known issues with this release:

• If using the Ubuntu 16.04 Xenial package, the server can not be bootstrapped using systemd. Please use the SysV init script with the 'bootstap' option to bootstrap the node. Note that a server that has been started that way can not be controlled via systemd and must be stopped using the SysV script. Normal server startup and shutdown is possible via systemd.

• Server cannot be started using 'service' command on Debian Stretch.

End of Life:

• This is the last release for SuSE Linux Enterprise Server 11

Reminder: Changes to Repositories Structure

With the new release the repository structure is changed to allow for existence of all of the wsrep-patched mysql versions currently supported: 5.5 through 5.7. Thus the repository layout requires from the user to adjust his or her repository configuration to accomodate those changes. In order to have the WSREP and Galera library installed, one would need to add the following repositories: 1. Galera-3 repository for galera library: e.g. http://releases.galeracluster.com/galera-3// 2. Corresponding mysql-wsrep repository: e.g. http://releases.galeracluster.com/mysql-wsrep-/ here: ldist is Linux or BSD distribution (Ubuntu, Centos) and mversion is MySQL version, i.e. 5.5, 5.6, 5.7

How To Install

Repositories contain dummy or meta packages, called mysql-wsrep- which are convenience packages for installation of the corresponding version of WSREP. One can install the whole suite by running, for example: apt-get install mysql-wsrep-5.6 galera-3

Quirks for Ubuntu Xenial and 5.6

Due to the peculiarities of how apt resolves packages and presence of 5.7 libraries in Xenial repositories the command above might require additional steps/changes in order to succeed.

One would need to either configure apt pinning for codership repositories for them to have priority over upstream packages or to specify mysql-common package version explicitly as the one located in the WSREP repositories in order to get things installed.

Changes in MySQL-wsrep 8.0.25-25.7 (2021-07-26)

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 8.0.23 and wsrep API version 26.

This release incorporates all changes up to MySQL 8.0.25.

Galera Cluster 8.0 is available as targeted packages and package repositories for Debian, Ubuntu, CentOS, RHEL and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep since the latest release 8.0.23-26.6:

• Changing system variable wsrep_on value during multi statement transaction is not allowed (MDEV-25226).

• SST scripts for rsync and xtrabackup-v2 SST methods now accept ssl-ca, ssl-cert and ssl-key configuration varibles either in [sst] or [mysqld] configuration section. The old variables tca, tcert and tkey are now deprecated but still accepted if they are present in [sst] section in the configuration file.

• Binlog purging was disabled when the mysqld server was started with --wsrep-recover option (codership/mysql-wsrep#381).

• Clone SST method reliability was improved.

• Parallel applying of write sets to tables without primary key was disabled (MDEV-25551).

• Both MDL and InnoDB locking was improved to handle cluster-wide conflicts more gracefully.

• Parallel applying for FK parent delete was fixed to respect applying order.

XtraBackup compatibility:

• Percona XtraBackup version 8.0.25-17.0 or higher is required to perform XtraBackup based SSTs.

Packaging:

• A dependency to stunnel package was added as it is needed for rsync SST SSL support.

The packages are available from https://releases.galeracluster.com/ for the following operating systems:

• CentOS 7 and 8

• Debian 10

• RedHat 7 and 8

• SLES 15 SP 1

End of life notices:

• Due to little usage pattern we plan to discontinue building MySQL-wsrep 8.0 packages for SUSE Linux Enterprise Server 15 after this release.

The users still running above discontinued platforms are adviced to use the binary tarball package.

Known issues with this release:

• When installing software on CentOS 8, dnf modules mysql and mariadb must be disabled before installing Galera Cluster software. This can be done by running dnf module disable mysql mariadb.

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.21 and Galera 3.9, wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.21 and numerous fixes and enhancements specific to Galera replication.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com, while previous releases remain available on LaunchPad. The source repositories and bug tracking are now on http://www.github.com/codership .

New features and notable changes in MySQL-wsrep since last binary release by Codership (5.6.16):

• The wsrep_causal_reads variable has been deprecated. A new variable, wsrep_sync_wait, has been introduced to allow causal checks to be specified separately for selects, updates and inserts (lp:1277053)

• Improvements in the replication of events (lp:1312618)

• SST is governed by a timeout so that the joiner does not hang if the donor dies (lp:1292991)

• Table administration commands such as CHECK TABLE are now replicated (lp:1046726)

New features and notable fixes in Galera replication since last binary release by Codership (3.5):

• CRITICAL: fixed writeset fragmentation bug that could cause GTID inconsistency (GitHub galera#185)

• Automatic node eviction: unstable nodes can be removed from the cluster if they fail to consistenly respond to heartbeat messages

• Intelligent donor selection: the cluster will attempt to select a donor that can serve IST

• A new provider option, pc.recovery, facilitates restart in case of a full cluster crash

Notable bug fixes in MySQL-wsrep:

• Important: fixes for transactions exceeding the maximum writeset size(lp:1309669, lp:1270920)

• Updating a unique key could cause parallel applying to hang (lp:1280896)

• Replication could fail with inserts to table with single unique key (lp:1299116)

• Node aborts if it first joins a non-primary component (lp:1334606)

New features and notable changes in MySQL 5.6.17 - 5.6.21:

• InnoDB tables can be rebuilt in place using online DDL

• DTrace Support

• Numerous fixes in InnoDB and native MySQL replication

Known issues with this release:

• Node address autoconfiguration does not work on Fedora 20 and later releases

• There is a package conflict on CentOS 6/7 which requires manual removal of postfix, mysql and maridb libraries before installing mysql-wsrep

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 8.0.19 and Galera 4.5, wsrep API version 26.

This release incorporates all changes up to MySQL 8.0.19 and numerous fixes and enhancements specific to Galera replication. This is the first generally available binary release of MySQL-wsrep 8.0 series.

Notable new features in MySQL-wsrep 8.0 series are:

• Streaming replication will improve execution of large transactions by splitting transaction replication and applying into small fragments.

• Three new Galera system tables have been added into mysql database: wsrep_cluster, wsrep_cluster_members and wsrep_streaming_log. A database administrator has now a view in cluster membership status via system tables.

• Better integration with MySQL binlog group commit provides higher transaction throughput.

• New synchronization functions WSREP_LAST_SEEN_GTID(), WSREP_LAST_WRITTEN_GTID() and WSREP_SYNC_WAIT_UPTO_GTID() have been introduced to help applications to implement read-your-writes and monotonic-reads consistency guarantees.

• Optimized write set certification rules will improve foreign key support by reducing the number of foreign key related false conflicts in certification.

Notable fixes in MySQL-wsrep since latest release candidate (8.0.19-26.3-rc)

• Server crash on START TRANSACTION after INSERT IGNORE was fixed.

Deprecated features:

• System variable wsrep_preordered has been deprecated and will be removed in a future release.

• System variable wsrep_mysql_replication_bundle was deprecated and will be removed in a future release.

The packages are available from https://releases.galeracluster.com/ for the following operating systems:

• CentOS 7 and 8

• Debian 10

• OpenSUSE 15

• SLES 15 SP 1

Known issues with this release:

• When installing software on CentOS 8, dnf modules mysql and mariadb must be disabled before installing Galera Cluster software. This can be done by running dnf module disable mysql mariadb.

• When installing software in Ubuntu 20.04, in order to select correct versions of mysql-common and mysql-client packages, the following must be run before installing mysql-wsrep-8.0 package

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 5.7, consisting of MySQL-wsrep 5.7.23 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.7.23.

Galera Cluster 5.7 is now available as targeted packages and package repositories for Debian, Ubuntu, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com.

The latest version of MySQL-wsrep 5.7 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on http://www.github.com/codership.

Notable bug fixes in MySQL-wsrep:

• New configuration option

Changes in MySQL-wsrep 8.0.35-26.16 (2024-01-08)

Codership is pleased to announce a new GA release of Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.35 and wsrep API version 26.

This release incorporates all changes up to MySQL 8.0.35.

Galera Cluster 8.0 is available as targeted packages and package repositories for Debian 10 (Buster) and 11 (Bullseye), 20.04 LTS (Focal) and 22.04 LTS (Jammy), CentOS 7 and RHEL 7, 8, and 9. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable changes and fixes in MySQL-wsrep since the latest release 8.0.34-26.15:

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.27 and Galera 3.13, wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.27.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com, while previous releases remain available on LaunchPad. The source repositories and bug tracking are now on http://www.github.com/codership .

New features and notable changes in MySQL-wsrep since last binary release by Codership (5.6.25):

• A "compat" package is now provided to allow MySQL-wsrep to be installed without removing packages such as Postfix which depend on older MySQL versions

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.48 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.48.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 5.6 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Notable fixes in MySQL-wsrep since the last binary release by Codership (5.6.47-25.29).

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.47 and wsrep API version 25.

This release incorporates all changes up to MySQL 5.6.47.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, CentOS, RHEL, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from https://www.galeracluster.com.

The latest version of MySQL-wsrep 5.6 for FreeBSD is available in the FreeBSD Ports Collection.

The source repositories and bug tracking are now on https://github.com/codership/mysql-wsrep.

Known issues with this release:

• If using the Ubuntu 16.04 Xenial package, the server can not be bootstrapped using systemd. Please use the SysV init script with the 'bootstap' option to bootstrap the node. Note that a server that has been started that way can not be controlled via systemd and must be stopped using the SysV script. Normal server startup and shutdown is possible via systemd.

• Server cannot be started using 'service' command on Debian Stretch.

Reminder: Changes to Repositories Structure

With the new release the repository structure is changed to allow for existence of all of the wsrep-patched mysql versions currently supported: 5.5 through 5.7. Thus the repository layout requires from the user to adjust his or her repository configuration to accomodate those changes. In order to have the WSREP and Galera library installed, one would need to add the following repositories: 1. Galera-3 repository for galera library: e.g. https://releases.galeracluster.com/galera-3// 2. Corresponding mysql-wsrep repository: e.g. https://releases.galeracluster.com/mysql-wsrep-/ here: ldist is Linux or BSD distribution (Ubuntu, Centos) and mversion is MySQL version, i.e. 5.5, 5.6, 5.7

How To Install

Repositories contain dummy or meta packages, called mysql-wsrep- which are convenience packages for installation of the corresponding version of WSREP. One can install the whole suite by running, for example: apt-get install mysql-wsrep-5.6 galera-3

Quirks for Ubuntu Xenial and 5.6

Due to the peculiarities of how apt resolves packages and presence of 5.7 libraries in Xenial repositories the command above might require additional steps/changes in order to succeed.

One would need to either configure apt pinning for codership repositories for them to have priority over upstream packages or to specify mysql-common package version explicitly as the one located in the WSREP repositories in order to get things installed.