Percona XtraDB Cluster(PXC) Non blocking operations, what you need to know to avoid pitfalls
summary
Covers Percona XtraDB Cluster (PXC) and how non-blocking operations (NBO) affect DDL like ADD/DROP INDEX. Explains problems caused by cluster-wide metalock and why workarounds such as rolling schema upgrades or Percona online-schema-change have been used, then details how to use NBO correctly for simple operations (adding an index) and what behavior to expect when NBO is not used.
AI-written summary · about
related talks
31mHow to Avoid Pitfalls in Schema Upgrade with Percona XtraDB Cluster
47mMeet Percona XtraDB Cluster 5.7
38mIs Percona XtraDB Cluster Right for Any Application
25mThe future of databases: Combining operational and analytical data at massive scale
47mWhat Is Postgres XC?
24mPercona Server for MySQL Advantage
27mDIY DBaaS with Percona Kubernetes Operators
59mMySQL (NDB) Cluster Best Practices