Skip to content

Percona XtraDB Cluster 5.7 Documentation

Percona XtraDB Cluster is a database cluster solution for MySQL. It ensures high availability, prevents downtime and data loss, and provides linear scalability for a growing environment.

This documentation is for the latest release: Percona XtraDB Cluster 5.7.44-31.65.4 (Release Notes).

Features of Percona XtraDB Cluster include:

Synchronous replication <Database replication>

Data is written to all nodes simultaneously or not written at all if it fails even on a single node.

Multi-source replication

Any node can trigger a data update.

True parallel replication <Database replication>

Multiple threads on slave performing replication on row level.

Automatic node provisioning**

Add a node and that node automatically syncs.

Data consistency

Percona XtraDB Cluster ensures that data is automatically synchronized on all nodes <Node> in your cluster.

PXC Strict Mode

Avoids the use of experimental and unsupported features.

Configuration script for ProxySQL

Percona provides a ProxySQL package with the proxysql-admin tool that automatically configures Percona XtraDB Cluster nodes.

See also

Load balancing with ProxySQL

Automatic configuration of SSL encryption

Percona XtraDB Cluster includes the pxc-encrypt-cluster-traffic variable that enables automatic configuration of SSL encryption.

Optimized Performance

Percona XtraDB Cluster performance is optimized to scale with a growing production workload.

For more information, see the following blog posts:

Percona XtraDB Cluster is fully compatible with MySQL Server Community Edition, Percona Server.

MySQL 5.7 Post-EOL Support from Percona

Leverage MySQL 5.7 Post-EOL Support from Percona to ensure continued security and performance for your MySQL applications. While this service provides critical bug fixes and security patches, consider migrating to the next major version to unlock a wider range of benefits:

  • Enhanced performance and scalability: Gain access to performance improvements and handle growing data volumes.

  • Improved security features: Benefit from the latest security advancements to effectively safeguard your data.

  • Access to the latest features and functionality: Use the newest features and functionalities to improve your database management experience.

Releases

For Monitoring and Management

Percona Monitoring and Management (PMM )monitors and provides actionable performance data for MySQL variants, including Percona Server for MySQL, Percona XtraDB Cluster, Oracle MySQL Community Edition, Oracle MySQL Enterprise Edition, and MariaDB. PMM captures metrics and data for the InnoDB, XtraDB, and MyRocks storage engines and has specialized dashboards for specific engine details.

Install PMM and connect your server instances to it.