Videos from Percona

Michael Benshoof, Technical Account Manager at Percona, brings his talk, Schema Review 101: How and What You Should Be Looking at.

The goal of this talk is to review the key features that would be part of a schema review, including things such as largest tables, index issues and table activity. Since learning how to profile your data is important when looking at capacity planning, architecture, and application design, I'll also...

It is common knowledge that built-in asynchronous active-active replication is not safe. I remember times when the official MySQL User Reference Manual stated that such an installation is not recommended for production use. Some experts repeat this claim even now.

While this statement is generally true, I worked with thousands of shops that successfully avoided asynchronous replication limitations in active-active setups.

...

Broken MySQL means broken Application, so maintaining insights in MySQL operational performance is critical.

Thankfully MySQL 8 offers a lot in terms of observability to resolve problems quickly and get great insights into opportunities for optimization. In this talk, we will cover most important observability improvements in MySQL 8 ranging from Performance Schema and Information Schema to enhanced error logging and optimizer...