Percona XtraDB Cluster 5.5.37-25.10¶
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
Garbdinit script and configuration files have been packaged for CentOS and Debian, in addition, in Debian garbd is packaged separately in
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
New SST options have been implemented:
inno-move-optswhich 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
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_rsyncwould silently fail on joiner when
rsyncserver port was already taken. Bug fixed #1099783.
wsrep_notifyscript failed on node shutdown. Bug fixed #1132955.
grastate.datfile was not getting zeroed appropriately it would lead to RBR error during the IST. Bug fixed #1180791.
gcommexception 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-serverwould 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
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 SELECTwas not replicated, if the select result set was empty. Bug fixed #1246921.
INSERTwould return deadlock instead of duplicate key on secondary unique key collision. Bug fixed #1255147.
Joiner node would not initialize storage engines if
rsyncwas 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.
perldependencies 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
rsyncversion 3.1.0. Bug fixed #1261673.
During the installation of
percona-xtradb-cluster-garbd-3.xpackage, Debian tries to start it, but as the configuration is not set, it would fail to start and leave the installation in
iFstate. 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
DDLwas performed after
FLUSH TABLES WITH READ LOCK. Bug fixed #1265656.
FLUSH TABLES WITH READ LOCKbehavior 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
xinetdfor HAProxy etc.) Bug fixed #1269469.
clustercheckscript would mark node as down on Debian based systems if it was run with default values because it was looking for the
defaults-extra-filein the wrong directory. Bug fixed #1276076.
Deadlock would happen when
NULLunique key was inserted. Workaround has been implemented to support
NULLkeys, by using the
md5sum of full row as key value. Bug fixed #1276424.
Builds now use system
Zlibinstead 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.sowith a compatibility symlink to
/usr/lib/libgalera_smm.so. Bug fixed #1279328.
If transaction size exceeds the
wsrep_max_ws_sizelimit, 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.
pc.bootstrap=1at runtime in a
NON-PRIMARYstate 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
--socketparameter passed by mysqld. Bug fixed #1289483.
Regression in Galera required explicitly setting
Yeseven if you set up variables
socket.ssl_cert. Bug fixed #1290006.
UNIV_DEBUGbinary 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
CLANGwould result in fatal error. Bug fixed #1309507.
Use-after-freememory corruption in
one_thread_per_connection_endhas been fixed. Bug fixed #1310875.
Xtrabackup wouldn’t copy empty
testdatabase during the SST. Bug fixed #1231088.
Xtrabackup SST failed when
/tmp/testdirectory 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-libspackage from CentOS repository. Bug fixed #1278516.
Server abort due to BF-BF lock conflict in
lock0lock.chas 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 exceededon 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.