Deep Dive MySQL
Episodes
MySQL Major Version Upgrade Checklist (Zero Downtime Strategy)
04 Apr 2026
Contributed by Lukas
Upgrading MySQL major versions in production is never just a version bump - it’s a carefully planned process involving compatibility checks, replica...
MySQL InnoDB Cluster Group Replication - Part 7 - Key Concepts in MySQL Group Replication InnoDB Cluster
06 Sep 2025
Contributed by Lukas
🎙️ Welcome to Episode 7 of our MySQL Group Replication Podcast Series!Ep. 7. Key Concepts in MySQL Group Replication InnoDB ClusterIn this episod...
MySQL InnoDB Cluster Group Replication - Part 6 - Comparing InnoDB Cluster with Other HA Solutions
03 Sep 2025
Contributed by Lukas
In this episode, we provide an overview of the leading MySQL high availability (HA) solutions that organizations rely on to ensure fault tolerance, co...
MySQL InnoDB Cluster Group Replication - Part 5 - Limitations
07 Jul 2025
Contributed by Lukas
🎙️ Welcome to the fifth episode of our MySQL Group Replication Podcast Series! Ep. 5. Limitations of MySQL Group Replication & InnoDB Clus...
MySQL InnoDB Cluster Group Replication - Part 4 - Requirements
07 Jul 2025
Contributed by Lukas
🎙️ Welcome to the fourth episode of our MySQL Group Replication Podcast Series! Ep. 4. MySQL Group Replication RequirementsIn this episode, we...
MySQL InnoDB Cluster Group Replication - Part 3 - Use Cases
07 Jul 2025
Contributed by Lukas
🎙️ Welcome to the third episode of our MySQL Group Replication Podcast Series! Ep. 3. MySQL Group Replication Use CasesIn this episode, we exp...
MySQL InnoDB Cluster Group Replication - Part 2 - Introduction to InnoDB Cluster
07 Jul 2025
Contributed by Lukas
🎙️ Welcome to the second episode of our MySQL Group Replication Podcast Series! Ep. 2. Introduction to MySQL InnoDB ClusterIn this episode, we i...
MySQL InnoDB Cluster Group Replication - Part 1 - Introduction
07 Jul 2025
Contributed by Lukas
🎙️ Welcome to the first episode of our MySQL Group Replication Podcast Series! Ep. 1. Introduction to Group ReplicationIn this episo...
MySQL Archiving Basics - considerations, mistakes, best practices
13 Apr 2025
Contributed by Lukas
In this video, we dive into data archival in MySQL — what it is, why it's important, and how you can archive old data without impacting performance ...
Choosing ProxySQL Versions
04 Mar 2025
Contributed by Lukas
Recently I got asked about choosing between #ProxySQL versions. Best way to go about it is review the features and compare them. I reviewed ProxySQL d...
Useful scripts for MySQL in Percona Toolkit
29 Nov 2024
Contributed by Lukas
In this episode, we explore several key tools within the Percona Toolkit that every database administrator and developer should know. From zero-downti...
MySQL Replication Basics - Part 3 Replica Lag
29 Nov 2024
Contributed by Lukas
In this episode, we cover the essentials of MySQL replication lag: - What causes replica lag and how to detect it - Best practices to minimize lag - ...
MySQL Replication Basics - Part 2 binary logs and more
20 Nov 2024
Contributed by Lukas
Tune in to get a deeper understanding of how binary and relay logs are critical to MySQL replication. Whether you're optimizing replication performanc...
MySQL Replication Basics - Part 1
20 Nov 2024
Contributed by Lukas
Welcome to the MySQL Replication Basics podcast, where we take a deep dive into one of the most essential features of MySQL for achieving high availab...
Low Hanging Fruits of MySQL Performance
15 Nov 2024
Contributed by Lukas
MySQL is one of the top used database system and with highly active community. Though without proper configuration you may not squeeze the most out of...
Duplicate Indexes in MySQL and more
15 Nov 2024
Contributed by Lukas
In this podcast, we’ll explore the issue of duplicate indexes in MySQL; including redundant index, foreign keys, left-prefixed secondary index /w pr...
MySQL Change Buffer - A discussion and FAQ
15 Nov 2024
Contributed by Lukas
In the world of database management, efficiency is key. MySQL’s change buffer is a powerful feature that helps optimize how secondary index changes ...