Deep Dive MySQL

Welcome to Deep Dive MySQL — your podcast for MySQL and related technologies! Whether you're starting out or an experienced DBA, even managers handling DBAs this podcast will help you understand the basics and concepts of MySQL. We explore MySQL specific topics in depth, covering replication, high availability, backups, performance tuning, Group Replication, and more. Gain practical insights, tips, and real-world techniques to strengthen your MySQL skills. Subscribe now and join the community of MySQL professionals and enthusiasts!Youtube: https://www.youtube.com/@mysqlzThanks,K

Deep Dive MySQL is a technology podcast hosted by Kedar Vaijanapurkar, with 16 episodes on record and a Required Pod Score of 80. PitchCentric scores this show on Booking Probability, Listen Score, and live audience signals refreshed every 24 hours.

Kedar Vaijanapurkar hosts Deep Dive MySQL, a technology show with 16 episodes published.

Our AI reads these to draft pitches. Use them as grounding for a pitch that cites a real guest and a specific topic.

• 

  Episode #1

  MySQL Major Version Upgrade Checklist (Zero Downtime Strategy)

  Apr 4, 202618 minS2

  Upgrading MySQL major versions in production is never just a version bump - it’s a carefully planned process involving compatibility checks, replication strategy, testing, and controlled cut-over.In this episode, we walk through a practical MySQL Major Version Upgrade Checklist based on real-world DBA workflows. We are covering MySQL replication as base setup for upgrade. It is possible having other approaches though this is one of the time tested. From testing to final cutover and rollback planning, this podcast covers the essential steps needed for a safe and zero-downtime upgrade.Who this is forMySQL DBAsDBA ManagersAnyone working with MySQL or hosting MySQL in their environment🔔 Subscribe for more MySQL tips and deep dives!📖 Blog: https://kedar.nitty-witty.com/blog/ 💬 Got questions? Drop them in the comments!

  ListenShow Notes
• 

  Deep Dive MySQL

  MySQL InnoDB Cluster Group Replication - Part 7 - Key Concepts in MySQL Group Replication InnoDB Cluster

  Sep 6, 202518 minS0

  <p>🎙️ Welcome to Episode 7 of our MySQL Group Replication Podcast Series!</p><p>Ep. 7. Key Concepts in MySQL Group Replication InnoDB Cluster</p><p><br></p><p>In this episode, we dive deep into the fundamental concepts that make MySQL Group Replication the powerful high availability solution it is today. We explore the core architectural components, from its consensus-based foundation to the intelligent features that ensure data consistency and fault tolerance across your MySQL cluster.</p><p>Summary of points covered here are as follows:</p><p><br></p><p> Built-in Consensus Protocol & Peer-to-Peer Architecture</p><p><br></p><p> Dynam...

  ListenShow Notes
• 

  Deep Dive MySQL

  MySQL InnoDB Cluster Group Replication - Part 6 - Comparing InnoDB Cluster with Other HA Solutions

  Sep 3, 202523 minS0

  <p>In this episode, we provide an overview of the leading MySQL high availability (HA) solutions that organizations rely on to ensure fault tolerance, continuous uptime, and data durability. We explore five prominent options — MySQL InnoDB Cluster, Percona XtraDB Cluster, MariaDB Galera Cluster, MySQL NDB Cluster, and a DIY stack combining MySQL with Orchestrator and ProxySQL. Each solution offers its own unique blend of features, complexity, and ideal use cases tailored to different organizational needs and technical capabilities.Summary of points covered here are as follows:- Introduction to MySQL High Availability- Overview of MySQL InnoDB Cluster: architecture, setup, and be...

  ListenShow Notes
• 

  Deep Dive MySQL

  MySQL InnoDB Cluster Group Replication - Part 5 - Limitations

  Jul 7, 202516 minS0

  <p>🎙️ Welcome to the fifth episode of our MySQL Group Replication Podcast Series! Ep. 5. Limitations of MySQL Group Replication & InnoDB ClusterIn this episode, we explore the key limitations and constraints of deploying MySQL Group Replication (GR) and MySQL InnoDB Cluster in real-world environments.You'll learn: Important limitations of MySQL Group Replication that affect deployment choices. Specific challenges with multi-primary mode and high-concurrency scenarios. GTID-related restrictions and upgrade compatibility issues. Locking limitations, including gap locks, table locks, and named locks. Issues with large transactions, transaction size limits, and network constraints. Group size limits and performance considerations. Unsupported features such as replication filte...

  ListenShow Notes
• 

  Deep Dive MySQL

  MySQL InnoDB Cluster Group Replication - Part 4 - Requirements

  Jul 7, 20257 minS0

  <p>🎙️ Welcome to the fourth episode of our MySQL Group Replication Podcast Series! Ep. 4. MySQL Group Replication RequirementsIn this episode, we explain the infrastructure and server configuration requirements necessary to successfully deploy MySQL Group Replication (GR) in production environments.You’ll learn the essential prerequisites to ensure your group replication setup is stable, consistent, and high-performing — covering both hardware/network factors and MySQL server settings.✅ Summary of points covered here are as follows: InnoDB Storage Engine Requirement Primary Key Requirement for Tables Network Performance & Protocols Unique Server Identifiers Binary Log & Replication Settings Global Transaction Identifiers (GTIDs) Consistent Encryption & Case Sensitivity Multithread...

  ListenShow Notes

Based on semantic analysis of episode topics and host coverage, this show is a strong guest fit for executives in:

Industry fit is computed by PitchCentric using vector embeddings of the show's episode catalog.