Meet Percona XtraDB Cluster 5.7
summary
Percona XtraDB Cluster 5.7 GA (six months) adds concrete controls and tooling: cluster safe mode blocks non-transactional DDL/DML and missing PK writes; performance schema now exposes PXC internals for profiling; IST progress monitoring and explicit flow‑control status reveal join and throttling progress; logging unifies SST/IST errors; packaging consolidates Galera; ProxySQL gets a one‑step autodiscover installer and ProxySQL assisted maintenance mode for graceful node shutdowns; encryption moves to encrypt=4 with xtrabackup re‑encryption for encrypted tablespaces; benchmarks show roughly 3–10x throughput gains (peaks ~22k TPS).
AI-written summary · about
chapters (12)
- 0:00Introduction to PXC
- 3:41PXC 5.7 overview
- 4:48PXC strict mode
- 9:34Performance schema
- 13:31Security enhancements
- 17:43ProxySQL integration
- 22:12Important statistics
- 26:08Logging and state changes
- 30:01Stage framework
- 31:57PXC performance improvements
- 40:15PMM integration
- 41:16Miscellaneous and Q&A
related talks
38mIs Percona XtraDB Cluster Right for Any Application
24mPercona Server for MySQL Advantage
27mThe State of ProxySQL, 2020 Edition
31mHow to Avoid Pitfalls in Schema Upgrade with Percona XtraDB Cluster
47mMy SQL 5 6 - Online Operations and Improved Diagnostics
15mPercona Database Distributions - An Overview
56mDeploying MySQL on Kubernetes & Openshift
57mMariaDB 10.5 Tutorial - New Features for Troubleshooting