Marco Tusa (the Grinch)

The constant pressure to move DATA in containers and Kubernetes is creating a lot of confusion and misunderstanding.
This is particularly dangerous when talking about Relational Database Management System.
MySQL, as well as Oracle, Postgres or SQL Server, is a RDBM, as such subject to the erroneous interpretation caused by this new crazy shining things that will solve all. In this short talk we will clarify, that first of all, we are not looking to something new and second why we need to be very careful when talking about using Kubernetes and containers for RDBMS.

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.

Containers, kubernetes and virtualizations are, as never before, the shining objects of our times. While we are used to implementing them in case of stateless situations, it becomes more difficult to see them serve properly in case of stateful solutions like RDBMS. But after I have won some personal reluctance, I started to experiment with the Percona Operator for MySQL. With this presentation, I will bring you a short journey as a result of my experience as DBA in the usage of the Percona Operator for MySQL. We will see from one side failures, misunderstanding and some frustration. From the other side a learning process that brings me to have better comprehension of the possible utilization and the best way to achieve it. Finally my personal considerations.

MySQL 8.0.18 comes (finally) with a long waited and desired hash-join implementation. That was already present in other pseudo MySQL distributions like MariaDb. But, what is has-join, how it works, what problems it solves, when and how to use it. Last but not least are all the different implementations doing the same things, or are they acting and performing differently. We are going to perform a short journey in hash-join implementations and answer all these questions.