Percona Distribution for MySQL 9.7.1 using Percona XtraDB Cluster (2026-09-10)¶
Percona Distribution for MySQL is more than just a version of MySQL; it is a comprehensive solution that combines Percona Server for MySQL with additional tools to create a cohesive environment. This distribution is reliable, scalable, and secure, ensuring that all components have been tested to work seamlessly together. You can choose from two download options: one that uses Percona Server for MySQL and another that utilizes Percona XtraDB Cluster. Refer to Install Percona Distribution for MySQL.
Percona Distribution for MySQL 9.7.0 using Percona XtraDB Cluster was not released; 9.7.1 is the next build in this series. This release includes enhancements and bug fixes from MySQL 9.7.0 and MySQL 9.7.1.
This release is based on Percona XtraDB Cluster 9.7.1-1 that includes all the features and bug fixes available in the MySQL 9.7.0 Community Edition and enterprise-grade features developed by Percona.
Release highlights¶
Percona Server for MySQL 9.7.1-1¶
Percona Server for MySQL 9.7.1-1 introduces the following new features and improvements:
-
Integrates the new Key Management Interoperability Protocol (KMIP) library into the key management component.
-
Adds JSONL (JSON Lines) output format for Audit Log Filter.
-
Increases the verbosity of the data dictionary upgrade process, making it easier to diagnose issues that occur during upgrade.
-
Logs SQL statements for the Audit Log Filter
table_accessclass and thereadandinsertsubclasses. -
Flushes the audit log buffer on server shutdown when the
ASYNCHRONOUSlogging strategy is in use, preventing the loss of buffered events. -
Reduces memory pressure in the Audit Log Filter component caused by VFS buffering.
-
Aligns the
audit_log_filter.format=NEWoutput between the 8.0 plugin and the 8.4 component. -
Optimizes performance for
mem_root_deque.
This release addresses the list of Common Vulnerabilities and Exposures (CVE). Find the list of CVEs in Percona Server for MySQL 9.7.1-1 release notes.
MySQL 9.7.0¶
Improvements and bug fixes provided by Oracle for MySQL 9.7.0 and included in Percona Server for MySQL are the following:
-
Connection attribute parsing could read a length-encoded size field before verifying that the complete field was present in the packet, leading to an out-of-bounds read. A size check is now performed before reading the field. (Bug #39116965)
-
A regression in row size estimation for
ROW_FORMAT=COMPRESSEDtables could causeCREATE TABLEto fail withRow size too largefor tables that were accepted in earlier releases. (Bug #39129182, Bug #120323)
Find the complete list of bug fixes and changes in the MySQL 9.7.0 Release Notes.
Builds and packaging¶
-
Percona XtraDB Cluster uses Profile-Guided Optimization (PGO) builds to improve runtime performance. PGO uses profiling data from representative workloads to guide compiler optimizations, which can improve throughput and reduce latency. Percona XtraDB Cluster packages are built with PGO enabled.
See Profile-Guided Optimization (PGO) and non-PGO builds for more information about PGO benefits and considerations.
-
In Percona XtraDB Cluster 9.7, packaging was reorganized to align more closely with upstream MySQL, consistent with the equivalent change in Percona Server for MySQL 9.7. Several packages were split into separate components, which may affect upgrades and dependency resolution compared with earlier Percona XtraDB Cluster releases.
The APT packages (Debian and Ubuntu) are:
- percona-xtradb-cluster-client-core
- percona-xtradb-cluster-client-plugins
- percona-xtradb-cluster-client
- percona-xtradb-cluster-common
- percona-xtradb-cluster-server-core
- percona-xtradb-cluster-server
- percona-xtradb-cluster-garbd
- percona-telemetry-agent
The YUM packages (RHEL, CentOS, Oracle Linux) are:
- percona-xtradb-cluster-client
- percona-xtradb-cluster-client-plugins
- percona-xtradb-cluster-server
- percona-xtradb-cluster-shared
- percona-xtradb-cluster-garbd
- percona-xtradb-cluster-icu-data-files
- percona-telemetry-agent
Known issues¶
-
This release does not include the Percona Toolkit component. We will add it once a Percona Toolkit version compatible with MySQL 9.7 becomes available.
-
In 9.7.x environments, the ProxySQL binlog reader can fail to initialize because it uses legacy commands, such as SHOW MASTER STATUS. Some internal counters also use outdated terminology. To address most terminology issues, enable the terminology_use_previous system variable on the database server. This workaround addresses only terminology compatibility and may not fix all failures.
Supplied components¶
Review each component’s release notes for What’s new, improvements, or bug fixes. The following is a list of the components supplied with the Percona Server for MySQL-based variation of the Percona Distribution for MySQL.
| Component | Version | Description |
|---|---|---|
| Percona XtraBackup | 9.7.1-rc1 | An open-source hot backup utility for MySQL-based servers that doesn’t lock your database during the backup. |
| HAProxy | 3.4.4 | A high-availability and load-balancing solution for Percona XtraDB Cluster. This is a default proxy. |
| ProxySQL | 3.0.9 | A high performance, high-availability, protocol-aware proxy for MySQL. |
| replication_manager.sh | 1.0 | A tool to manage multi-source replication between multiple Percona XtraDB Cluster clusters. |