Announcing Galera Cluster 5.7.18, 5.6.36 and 5.5.55 with Galera 3.21. Improvements to IPv6 Support, Bug Fixes and Changes to Repositories Structure

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

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
MySQL-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/DIST/

Here DIST is Linux distribution (ubuntu, centos, …).

The latest version of Galera for FreeBSD is available in FreeBSD Ports
Collection. Go to https://www.freebsd.org/cgi/ports.cgi?query=Galera&stype=all

2. Corresponding MySQL-wsrep repository:
e.g. http://releases.galeracluster.com/mysql-wsrep-MVERSION/DIST

Here DIST 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-MVERSION
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.

For more detailed installation instructions, please refer to documentation
in http://galeracluster.com/documentation-webpages/.

 

NEW FEATURES AND NOTABLE FIXES IN THE GALERA REPLICATION LIBRARY SINCE LAST BINARY RELEASE BY CODERSHIP (3.21):

* Galera now considers umask when creating gcache files
(GAL-505, codership/galera#449)

* Clean abort is ensured when core piping is used (GAL-505)

* Node state is marked unsafe when slave executes TOI (GAL-504)

* A bug in send monitor that could cause the node to stop replicating under
heavy write load has been fixed. (GAL-495)

* URI parsing has been improved for IPv6 addresses. Now Galera accepts addresses in IPv6 notation
(GAL-501, GAL-338, codership/galera#338)

* GCache recovery fixes (GAL-494, GAL-500)

* IST progress is reported in the log (GAL-491)

* Improved build time checks for ASIO version (GAL-510)

 

NOTABLE BUG FIXES IN MYSQL-WSREP:

Version 5.7.18-25.12:

* 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. Now MySQL-wsrep accepts addresses in IPv6 notation (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)

 

Version 5.6.36-25.20:

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

* 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. Now MySQL-wsrep accepts addresses in IPv6 notation (MW-366)

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

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

Version 5.5.55-25.21:

* CREATE TABLE AS SELECT fixes (MW-322)

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

* 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.

For Galera Cluster 5.6:
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.

For Galera Cluster 5.7:

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

Leave a Reply

Your email address will not be published. Required fields are marked *