conferences | speakers | series

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

home

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

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.

Speakers: Marco Tusa (the Grinch)