# Percona XtraDB Cluster 5.7.19-29.22 is now available

**URL:** <https://forums.percona.com/t/percona-xtradb-cluster-5-7-19-29-22-is-now-available/5906>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [October 2, 2017, 6:49am UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-19-29-22-is-now-available/5906 "2017-10-02T06:49:55Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![hrvojem](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/hrvojem/32/6_2.png) [@hrvojem](https://forums.percona.com/u/hrvojem)\
**Post date:** [October 2, 2017, 6:49am UTC](https://forums.percona.com/t/percona-xtradb-cluster-5-7-19-29-22-is-now-available/5906/1 "2017-10-02T06:49:55Z")

</div>

Percona announces the release of Percona XtraDB Cluster 5.7.19-29.22 on September 22, 2017. Binaries are available from the [downloads section](http://www.percona.com/downloads/Percona-XtraDB-Cluster-57/) or our [software repositories](https://www.percona.com/doc/percona-xtradb-cluster/5.7/install/index.html).

NOTE: You can also run Docker containers from the images in the [Docker Hub repository](https://hub.docker.com/r/percona/percona-xtradb-cluster/).

Percona XtraDB Cluster 5.7.19-29.22 is now the current release, based on the following:  
[LIST]  
[_][Percona Server 5.7.19-17](http://www.percona.com/doc/percona-server/5.7/release-notes/Percona-Server-5.7.19-17.html)  
[_]Galera Replication library 3.22  
[\*]wsrep API version 29  
[/LIST]  
All Percona software is open-source and free. Upgrade Instructions  
After you upgrade each node to Percona XtraDB Cluster 5.7.19-29.22, run the following command on one of the nodes:  
[TABLE]  
[TR]  
[TD]1[/TD]  
[TD]$ mysql -uroot -p \< /usr/share/mysql/pxc\_cluster\_view.sql[/TD]  
[/TR]  
[/TABLE]

Then restart all nodes, one at a time:  
[TABLE]  
[TR]  
[TD]1[/TD]  
[TD]$ sudo service mysql restart[/TD]  
[/TR]  
[/TABLE]  
New Features  
[LIST]  
[_]Introduced the pxc\_cluster\_view table to get a unified view of the cluster. This table is exposed through the performance schema.  
[TABLE]  
[TR]  
[TD]1  
2  
3  
4  
5  
6  
7  
8[/TD]  
[TD]mysql\> select \* from pxc\_cluster\_view;  
-----------------------------------------------------------------------------  
HOST\_NAME UUID STATUS LOCAL\_INDEX SEGMENT  
-----------------------------------------------------------------------------  
n1 b25bfd59-93ad-11e7-99c7-7b26c63037a2 DONOR 0 0  
n2 be7eae92-93ad-11e7-88d8-92f8234d6ce2 JOINER 1 0  
-----------------------------------------------------------------------------  
2 rows in set (0.01 sec)[/TD]  
[/TR]  
[/TABLE]  
[_][PXC-803](https://jira.percona.com/browse/PXC-803): Added support for new features in Percona XtraBackup 2.4.7:  
[LIST]  
[_][wsrep\_debug](https://www.percona.com/doc/percona-xtradb-cluster/LATEST/wsrep-system-index.html#wsrep_debug) enables debug logging  
[_][encrypt\_threads](https://www.percona.com/doc/percona-xtradb-cluster/LATEST/manual/xtrabackup_sst.html#encrypt_threads) specifies the number of threads that XtraBackup should use for encrypting data (when encrypt=1). This value is passed using the --encrypt-threads option in XtraBackup.  
[_][backup\_threads](https://www.percona.com/doc/percona-xtradb-cluster/LATEST/manual/xtrabackup_sst.html#backup_threads) specifies the number of threads that XtraBackup should use to create backups. See the --parallel option in XtraBackup.  
[/LIST]  
[/LIST]Improvements  
[LIST]  
[_][PXC-835](https://jira.percona.com/browse/PXC-835): Limited wsrep\_node\_name to 64 bytes.  
[_][PXC-846](https://jira.percona.com/browse/PXC-846): Improved logging to report reason of IST failure.  
[_][PXC-851](https://jira.percona.com/browse/PXC-851): Added version compatibility check during SST with XtraBackup:  
[LIST]  
[_]If a donor is 5.6 and a joiner is 5.7: A warning is printed to perform mysql\_upgrade.  
[_]If a donor is 5.7 and a joiner is 5.6: An error is printed and SST is rejected.  
[/LIST]  
[/LIST]Fixed Bugs  
[LIST]  
[_][PXC-825](https://jira.percona.com/browse/PXC-825): Fixed script for SST with XtraBackup (wsrep\_sst\_xtrabackup-v2) to include the --defaults-group-suffix when logging to syslog. For more information, see [#1559498](https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1559498).  
[_][PXC-826](https://jira.percona.com/browse/PXC-826): Fixed multi-source replication to PXC node slave. For more information, see [#1676464](https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1676464).  
[_][PXC-827](https://jira.percona.com/browse/PXC-827): Fixed handling of different binlog names between donor and joiner nodes when GTID is enabled. For more information, see [#1690398](https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1690398).  
[_][PXC-830](https://jira.percona.com/browse/PXC-830): Rejected the RESET MASTER operation when wsrep provider is enabled and gtid\_mode is set to ON. For more information, see [#1249284](https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1249284).  
[_][PXC-833](https://jira.percona.com/browse/PXC-833): Fixed connection failure handling during SST by making the donor retry connection to joiner every second for a maximum of 30 retries. For more information, see [#1696273](https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1696273).  
[_][PXC-839](https://jira.percona.com/browse/PXC-839): Fixed GTID inconsistency when setting gtid\_next.  
[_][PXC-840](https://jira.percona.com/browse/PXC-840): Fixed typo in alias for systemd configuration.  
[_][PXC-841](https://jira.percona.com/browse/PXC-841): Added check to avoid replication of DDL if sql\_log\_bin is disabled. For more information, see [#1706820](https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1706820).  
[_][PXC-842](https://jira.percona.com/browse/PXC-842): Fixed deadlocks during Load Data Infile (LDI) with log-bin disabled by ensuring that a new transaction (of 10 000 rows) starts only after the previous one is committed by both wsrep and InnoDB. For more information, see [#1706514](https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1706514).  
[_][PXC-843](https://jira.percona.com/browse/PXC-843): Fixed situation where the joiner hangs after SST has failed by dropping all transactions in the receive queue. For more information, see [#1707633](https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1707633).  
[_][PXC-853](https://jira.percona.com/browse/PXC-853): Fixed cluster recovery by enabling wsrep\_ready whenever nodes become PRIMARY.  
[_][PXC-862](https://jira.percona.com/browse/PXC-862): Fixed script for SST with XtraBackup (wsrep\_sst\_xtrabackup-v2) to use the ssl-dhparams value from the configuration file.  
[/LIST]  
Help us improve our software quality by reporting any bugs you encounter using our [bug tracking system](https://bugs.launchpad.net/percona-xtradb-cluster/+filebug). As always, thanks for your continued support of Percona!
