Percona XtraDB Cluster 8.0 Documentation Percona XtraDB Cluster 8.0 Documentation¶
Percona XtraDB Cluster is a database clustering solution for MySQL. It ensures high availability, prevents downtime and data loss, and provides linear scalability for a growing environment.
Features of Percona XtraDB Cluster
| Feature | Details |
|---|---|
| Synchronous replication** | Data is written to all nodes simultaneously, or not written at all in case of a failure even on a single node |
| Multi-master replication | Any node can trigger a data update. |
| True parallel replication | Multiple threads on slave performing replication on row level |
| Automatic node provisioning | You simply add a node and it automatically syncs. |
| Data consistency | No more unsynchronized nodes. |
| PXC Strict Mode | Avoids the use of experimental and unsupported features |
| Configuration script for ProxySQL | Percona XtraDB Cluster includes the proxysql-admin tool that automatically configures
Percona XtraDB Cluster nodes using 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 |
Percona XtraDB Cluster 8.0 is fully compatible with MySQL Server Community Edition 8.0 and Percona Server for MySQL 8.0.
See also
- Overview of changes in the most recent Percona XtraDB Cluster release
- Important changes in Percona XtraDB Cluster 8.0
- MySQL Community Edition
- https://www.mysql.com/products/community/
- Percona Server for MySQL
- https://www.percona.com/doc/percona-server/LATEST/index.html
- How We Made Percona XtraDB Cluster Scale
- https://www.percona.com/blog/2017/04/19/how-we-made-percona-xtradb-cluster-scale
- Data compatibility
- You can use data created by any MySQL variant.
- Application compatibility
- There is no or minimal application changes required.
Getting Started¶
PXC Security¶
User’s Manual¶
- State Snapshot Transfer
- Percona XtraBackup SST Configuration
- Restarting the cluster nodes
- Cluster Failover
- Monitoring the cluster
- Certification in Percona XtraDB Cluster
- Percona XtraDB Cluster threading model
- Understanding GCache and Record-Set Cache
- Perfomance Schema Instrumentation
- Data at Rest Encryption
How-tos¶
- Upgrading Percona XtraDB Cluster
- Crash Recovery
- Configuring Percona XtraDB Cluster on CentOS
- Configuring Percona XtraDB Cluster on Ubuntu
- Setting up Galera Arbitrator
- How to set up a three-node cluster on a single box
- How to set up a three-node cluster in EC2 enviroment
- Load balancing with HAProxy
- Load balancing with ProxySQL
- The proxysql-admin Tool with ProxySQL v2
- Setting up PXC reference architecture with ProxySQL
