MySQL-wsrep 5.7.18-25.12 Release Notes

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

• Compilation with DTrace enabled may fail, so -DENABLE_DTRACE=:BOOL=OFF may be used 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.