Percona XtraDB Cluster 5.7.17-29.20 is now available

Percona announces the release of Percona XtraDB Cluster 5.7.17-29.20 on April 19, 2017. Binaries are available from the downloads section or our software repositories.

NOTE: You can also run Docker containers from the images in the Docker Hub repository.

Percona XtraDB Cluster 5.7.17-29.20 is now the current release, based on the following:

• Percona Server 5.7.17-13
• Galera Replication library 3.20
• wsrep API version 29

All Percona software is open-source and free.

Performance Improvements

This release is focused on performance and scalability with increasing workload threads. Tests show up to 10 times increase in performance.

Fixed bugs

• Fixed gcache page cleanup not triggering when limits are exceeded.
• Excluded the garbd node from flow control calculations.
• Added extra checks to verify that SSL files (certificate, certificate authority, and key) are compatible before opening connection.
• PXC-782: Updated xtrabackup-v2 script to use the tmpdir option (if it is set under [sst], [xtrabackup] or [mysqld], in that order).
• PXC-784: Fixed the pc.recovery procedure to abort if the gvwstate.dat file is empty or invalid, and fall back to normal joining process. For more information, see 1669333.
• PXC-794: Updated the sockopt option to include a comma at the beginning if it is not set by the user.
• PXC-797: Blocked wsrep_desync toggling while node is paused to avoid halting the cluster when running FLUSH TABLES WITH READ LOCK. For more information, see 1370532.
• PXC-805: Inherited upstream fix to avoid using deprecated variables, such as INFORMATION_SCHEMA.SESSION_VARIABLE. For more information, see 1676401.
• Fixed mysqladmin shutdown to correctly stop the server on systems using systemd.
• Fixed several packaging and dependency issues.

Other improvements

• Updated semantics for gcache page cleanup to trigger when either gcache.keep_pages_size or gcache.keep_pages_count exceeds the limit, instead of both at the same time.
• Added support for passing the XtraBackup buffer pool size with the use-memory option under [xtrabackup] and the innodb_buffer_pool_size option under [mysqld] when the --use-memory option is not passed with the inno-apply-opts option under [sst].
• Improved SST and IST log messages for better readability and unification.
• Improved parallelism for better scaling with multiple threads.
• Added validations for DISCARD TABLESPACE and IMPORT TABLESPACE in PXC Strict Mode to prevent data inconsistency.
• Added the wsrep_flow_control_status variable to indicate if node is in flow control (paused).
• PXC-766: Added the wsrep_ist_receive_status variable to show progress during an IST.
• Allowed CREATE TABLE ... AS SELECT (CTAS) statements with temporary tables (CREATE TEMPORARY TABLE ... AS SELECT) in PXC Strict Mode. For more information, see 1666899.
• PXC-783: Improved the wsrep stage framework.
• PXC-795: Set --parallel=4 as default option for wsrep_sst_xtrabackup-v2 to run four threads with XtraBackup.
• PXC-811: Changed default values for the following variables:

  • fc_limit from 16 to 100
  • send_window from 4 to 10
  • user_send_window from 2 to 4

• Moved wsrep settings into a separate configuration file (/etc/my.cnf.d/wsrep.cnf).

Help us improve our software quality by reporting any bugs you encounter using our bug tracking system. As always, thanks for your continued support of Percona!