Online / 5 & 6 February 2022


Percona XtraDB Cluster(PXC) Non blocking operations, what you need to know to avoid pitfalls

Performing simple DDL operations as ADD/DROP INDEX in a tightly connected cluster as PXC, can become a nightmare. Metalock will prevent Data modifications for long period of time and to bypass this, we need to become creative, like using Rolling schema upgrade or Percona online-schema-change. With NBO, we will be able to avoid such craziness at least for a simple operation like adding an index. In this brief talk I will illustrate what you should do to see the negative effect of NON using NBO, as well what you should do to use it correctly and what to expect out of it.


Photo of Marco Tusa (the Grinch) Marco Tusa (the Grinch)