Based on Percona Server 5.5.37-35.0 including all the bug fixes in it, Galera Replicator 2.10 (including fixes in 2.9 and 2.10 milestones) and on wsrep API 25.10 (including fixes in 25.10), Percona XtraDB Cluster 5.5.37-25.10 is now the current stable release. All of Percona‘s software is open-source and free.
This is an General Availability release. We did our best to eliminate bugs and problems during the testing release, but this is a software, so bugs are expected. If you encounter them, please report them to our bug tracking system.
Percona XtraDB Cluster now supports stream compression/decompression with new xtrabackup-sst compressor/decompressor options.
Garbd init script and configuration files have been packaged for CentOS and Debian, in addition, in Debian garbd is packaged separately in percona-xtradb-cluster-garbd-2.x package.
New meta packages are now available in order to make the Percona XtraDB Cluster installation easier.
Debian/Ubuntu debug packages are now available for Galera and garbd.
New SST options have been implemented: inno-backup-opts, inno-apply-opts, inno-move-opts which pass options to backup, apply and move stages of innobackupex.
Initial configurable timeout, of 100 seconds, to receive a first packet via SST has been implemented, so that if donor dies somewhere in between, joiner doesn’t hang. Timeout can be configured with the sst-initial-timeout variable.
The joiner would wait and not fall back to choosing other potential donor nodes (not listed in wsrep_sst_donor) by their state. This happened even when comma was added at the end. This fixes it for that particular case.
Support for Query Cache has been implemented.
wsrep_sst_rsync would silently fail on joiner when rsync server port was already taken. Bug fixed #1099783.
Example wsrep_notify script failed on node shutdown. Bug fixed #1132955.
When grastate.dat file was not getting zeroed appropriately it would lead to RBR error during the IST. Bug fixed #1180791.
gcomm exception in PC validate_state_msgs() during cluster partitioning/re-merges” has been fixed. Bug fixed #1182367.
Due to the Provides: line in Percona XtraDB Cluster (which provides Percona-Server-server), the command yum install Percona-Server-server would install Percona XtraDB Cluster instead of the expected Percona Server. Bug fixed #1201499.
Replication of partition tables without binlogging enabled failed, partition truncation didn’t work because of lack of TO isolation there. Bug fixed #1219605.
Exception during group merge after partitioning event has been fixed. Bug fixed #1232747.
Default value for binlog_format is now ROW. This is done so that Percona XtraDB Cluster is not started with wrong defaults leading to non-deterministic outcomes like crash. Bug fixed #1243228.
CREATE TABLE AS SELECT was not replicated, if the select result set was empty. Bug fixed #1246921.
INSERT would return deadlock instead of duplicate key on secondary unique key collision. Bug fixed #1255147.
Joiner node would not initialize storage engines if rsync was used for SST and the first view was non-primary. Bug fixed #1257341.
Table level lock conflict resolving was releasing the wrong lock. Bug fixed #1257678.
Resolved the perl dependencies needed for Percona XtraDB Cluster 5.6. Bug fixed #1258563.
Obsolete dependencies have been removed from Percona XtraDB Cluster. Bug fixed #1259256.
GCache file allocation could fail if file size was a multiple of page size. Bug fixed #1259952.
Fixed rsync SST for compatibility with rsync version 3.1.0. Bug fixed #1261673.
During the installation of percona-xtradb-cluster-garbd-3.x package, Debian tries to start it, but as the configuration is not set, it would fail to start and leave the installation in iF state. Bug fixed #1262171.
Runtime checks have been added for dynamic variables which are Galera incompatible. Bug fixed #1262188.
Node would get stuck and required restart if DDL was performed after FLUSH TABLES WITH READ LOCK. Bug fixed #1265656.
FLUSH TABLES WITH READ LOCK behavior on the same connection was changed to conform to MySQL behavior. Bug fixed #1269085.
Read-only detection has been added in clustercheck, which can be helpful during major upgrades (this is used by xinetd for HAProxy etc.) Bug fixed #1269469.
clustercheck script would mark node as down on Debian based systems if it was run with default values because it was looking for the defaults-extra-file in the wrong directory. Bug fixed #1276076.
Deadlock would happen when NULL unique key was inserted. Workaround has been implemented to support NULL keys, by using the md5 sum of full row as key value. Bug fixed #1276424.
Builds now use system Zlib instead of bundled one. Bug fixed #1277928.
Binlog events were created for the statements for non-InnoDB tables, but they were never cleaned from transaction cache, which could lead to node crash. Bug fixed #1277986.
Galera2 is now installed in /usr/lib/galera2/libgalera_smm.so with a compatibility symlink to /usr/lib/libgalera_smm.so. Bug fixed #1279328.
If transaction size exceeds the wsrep_max_ws_size limit, there will appear a warning message in the error log and replication is skipped. However, the transaction was committed in the master node, and cluster would be in inconsistent state. Bug fixed #1280557.
Updating an unique key value could cause server to hang if slave node has enabled parallel slaves. Bug fixed #1280896.
Boostrapping with pc.bootstrap=1 at runtime in a NON-PRIMARY state would lead to crash. Bug fixed #1286450.
Asynchronous replication slave thread is stopped when the node tries to apply next replication event while the node is in non-primary state. But it would then remain stopped after node successfully re-joined the cluster. Bug fixed #1288479.
New versions of xtrabackup SST scripts were ignoring --socket parameter passed by mysqld. Bug fixed #1289483.
Regression in Galera required explicitly setting socket.ssl to Yes even if you set up variables socket.ssl_key and socket.ssl_cert. Bug fixed #1290006.
The mysql-debug UNIV_DEBUG binary was missing from RPM/DEB server packages. Bug fixed #1290087.
When Query Cache was used and a node would go into non-PRIM state, queries which returned results earlier (and cached into query cache) would still return results whereas newer queries (or the ones not cached) would return unknown command. Bug fixed #1296403.
Brute Force abort did not work with INSERTs to table with single unique key. Bug fixed #1299116.
Compiling on FreeBSD 10.0 with CLANG would result in fatal error. Bug fixed #1309507.
Use-after-free memory corruption in one_thread_per_connection_end has been fixed. Bug fixed #1310875.
Xtrabackup wouldn’t copy empty test database during the SST. Bug fixed #1231088.
Xtrabackup SST failed when /tmp/test directory existed, fixed by creating unique directories in SST script. Bug fixed #1294760.
Deadlock during server shutdown has been prevented. Bug fixed #1284670.
Added new option to the init script to restart a node bootstrapped. Bug fixed #1291024.
Percona XtraDB Cluster server package no longer conflicts with mysql-libs package from CentOS repository. Bug fixed #1278516.
Server abort due to BF-BF lock conflict in lock0lock.c has been fixed. Bug fixed #1264809.
Crash due to segfault in gcache::RingBuffer::get_new_buffer() has been fixed. Bug fixed #1152565.
Applier would fail with lock wait timeout exceeded on rsync SST donor. Bug fixed #1255501.
rsync SST could hang due to missing lsof. Bug fixed #1313293.
Other bugs fixed: #1273101, #1297822, #1289776, #1279844, #1279343, #1278516, #1278417, #1277263, #1276994, #1272961, #1272723, #1269811, #1269351, #1269063, #1262887, #1262716, #1261996, #1261833, #1261138, #1269063, #1256887, #1256769, #1255501, and #1254633.
Percona XtraDB Cluster Errata can be found in our documentation.