A Book on MySQL by the Founder of BreachDirectory is Just Around the Corner! Register for Access

MySQL Performance & Security Training

In the words of those I've worked with


Your database instances are probably broken. Many developers face slow-running queries, issues related to database architecture, replication, or database security—and that's only the beginning.

Enter exclusive MySQL security & performance training conducted by a database expert: during the training, you will discover the sorts of actions, minor and major, that degrade databases so you can fix and ultimately preempt them. MySQL sometimes acts according to its own rules, and this training will help you keep your databases working on your terms. At the same time, you will learn to optimize your backup and recovery procedures, determine when and which data to index to achieve maximum performance, and choose the best database configurations, among other essential skills.

The training will be conducted by Lukas Vileikis, the founder of BreachDirectory, former DevRel engineer @ Severalnines (former MySQL staff), international speaker, security evangelist, and the author of the book Hacking MySQL: Breaking, Optimizing, and Securing MySQL for Your Use Case.

The price of the training for a single individual is 750 EUR.

The price of the training for groups of people is adjusted based on the number of participants and specific needs. The training can be performed in-person or remotely and the exact details of the training will be provided upon contact.

The preliminary structure of the training can be seen below.

Module About
Preface A high-level overview of the workshop.
MySQL & MariaDB Storage Engines High-level overview of the storage engines available in MySQL and MariaDB.
The Architecture of MySQL & MariaDB Walkthrough of the architecture of MySQL and MariaDB.
Storage Engine Deep Dive Walkthrough of the storage engines available in MySQL & MariaDB.
Types of Queries in MySQL & MariaDB Deep dive into the types of SQL queries in MySQL and MariaDB. Optimization.
Structuring Databases & Tables for Performance Deep dive into the structure of your databases and tables.
Indexing for Performance Deep dive into the indexes available within MySQL & MariaDB.
Character Sets & Collations Deep dive into the character sets and collations that make MySQL & MariaDB tick.
Partitioning Deep dive into the ins and outs of partitioning.
Backups A deep ive into physical and logical backup types & more.
Wrap-up Key takeaways are presented to the attendees & wrapping up the workshop.