MySQL Performance & Security Training

In the words of those I've worked with

As a database expert myself, I found Lukas's book perfect for both junior database admins looking to build foundational knowledge and experienced DBAs seeking fresh insights. There’s a piece of wisdom for everyone, and every developer or database admin should have it in their book collection.
This cornerstone book is a must-read for anyone serious about mastering MySQL performance, securing their database, and protecting it against malicious users.
In two words: Read it! You won't regret it. 5/5.

Lukas explained what the "bin" folder consists of, his speech improved my knowledge of indexing in general, especially how it works in MariaDB. Speaking was clear, enough to understand the topic and didn't have too many details that can distract from the main subject.

Nice and detailed presentation for the time you've got allocated.

During the event, their performance was outstanding. They demonstrated excellent skills and a strong commitment, contributing significantly to the success of the event.

Lukas has made extensive security tests and disclosed several issues (CSRF, XSS) on our site. He is professional, kind, and responsive. It is a pleasure working with him!

Get Started

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.

I'm Interested

MySQL Performance & Security Training

In the words of those I've worked with

Secure Your Team