- 17
- Episodes
- Weekly
- Cadence
- 2024
- First episode
About 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/@mysqlz Thanks, K
- Publisher
- Kedar Vaijanapurkar
- Category
- technology
- Language
- en
- Explicit
- No
- First episode
- 15 Nov 2024
- Latest episode
- 4 Apr 2026
Latest episodes
17 episodes in the feed.
4 Apr 2026
MySQL Major Version Upgrade Checklist (Zero Downtime Strategy)
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/ (https://www.youtube.com/redirect?event=video_description&redir_token=QUFFLUhqa0N4T21ZU0pfZVAwNmZJdktuU0dfMXZVakhKUXxBQ3Jtc0ttczZyMlA4N25pdmkyemc0Y1pxTHFnRnpQSy1fdndZRXFiRG9fcVFacEpaODFKOUk4SEt4eEE2LXpmNldpNENnRldfRUc0bUNLQmtlbHBMVVpzalJFeWVmRXI3cmtHcUduSV92M095Q3pXYkJ3QzBxcw&q=https%3A%2F%2Fkedar.nitty-witty.com%2Fblog%2F&v=LKilfCJI_y4)💬 Got questions? Drop them in the comments!
6 Sept 2025
MySQL InnoDB Cluster Group Replication - Part 7 - Key Concepts in MySQL Group Replication InnoDB Cluster
🎙️ Welcome to Episode 7 of our MySQL Group Replication Podcast Series! Ep. 7. Key Concepts in MySQL Group Replication InnoDB Cluster 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. Summary of points covered here are as follows: Built-in Consensus Protocol & Peer-to-Peer Architecture Dynamic Membership & Lifecycle Management Group Communication System (GCS) with XCom Global Transaction Identifiers (GTIDs) & Their Critical Role Certification-Based Conflict Detection Mechanism Single-Primary vs Multi-Primary Operational Modes Automatic Primary Election & Failover Process Group Replication Consistency Levels (EVENTUAL to BEFORE_AND_AFTER) Distributed Recovery & Catch-Up Mechanisms Flow Control for Cluster Stability Clone Plugin for Modern Provisioning Network Partition Handling & Split-Brain Prevention The MySQL Group Replication InnoDB Cluster Podcast Series Ep. 1. Introduction to Group Replication Ep. 2. Introduction to MySQL Innodb Cluster Ep. 3. MySQL Group Replication Use Cases Ep. 4. MySQL Group Replication requirements Ep. 5. Limitations of MySQL Group Replication InnoDB Cluster Ep. 6. Comparing MySQL InnoDB Cluster with other solutions Ep. 7. Key Concepts in MySQL Group Replication InnoDB Cluster This series is designed for DBAs, DevOps engineers, architects, and MySQL enthusiasts who want to understand MySQL high availability and clustering technologies. 🔔 Subscribe for more MySQL tips and deep dives! 📖 Blog: https://kedar.nitty-witty.com/blog/ 💬 Got questions? Drop them in the comments!
3 Sept 2025
MySQL InnoDB Cluster Group Replication - Part 6 - Comparing InnoDB Cluster with Other HA Solutions
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 benefits- Percona XtraDB Cluster: open-source, enterprise-ready clustering- MariaDB Galera Cluster: true multi-master with Galera technology and the impact of Codership acquisition- MySQL NDB Cluster: telco-grade, ultra-low latency, mission-critical HA- DIY HA with MySQL + Orchestrator + ProxySQL: flexible but complex- Key considerations for choosing the right HA solution: operational complexity, team expertise, and business needs- Summary of strengths and trade-offs across solutions- Preview of upcoming episodes diving deeper into individual technologies and practical deployment tips#MySQL, #InnoDBCluster, #GroupReplication, #MySQLHighAvailability, #DatabaseClustering, #PXC, #MariaDBGALERA, #NDBCluster, #MySQLReplication, #OpenSourceDatabase, #DatabaseScaling, #MySQLPodcast, #DatabaseArchitecture, #ReplicationSolutionsThe MySQL Group Replication InnoDB Cluster Podcast SeriesEp. 1. Introduction to Group ReplicationEp. 2. Introduction to MySQL Innodb ClusterEp. 3. MySQL Group Replication Use CasesEp. 4. MySQL Group Replication requirementsEp. 5. Limitations of MySQL Group Replication InnoDB ClusterEp. 6. Comparing MySQL InnoDB Cluster with other solutionsEp. 7. Key Concepts in MySQL Group Replication InnoDB ClusterThis series is designed for DBAs, DevOps engineers, architects, and MySQL enthusiasts who want to understand MySQL high availability and clustering technologies.🔔 Subscribe for more MySQL tips and deep dives!📖 Blog: https://kedar.nitty-witty.com/blog/💬 Got questions? Drop them in the comments!
7 Jul 2025
MySQL InnoDB Cluster Group Replication - Part 5 - Limitations
🎙️ 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 filters and certain foreign key setups.This episode is essential for anyone planning to deploy MySQL Group Replication or InnoDB Cluster in production environments — ensuring you’re aware of potential trade-offs and design challenges.#MySQL, #GroupReplication, #InnoDBCluster, #MySQLReplication, #MySQLHighAvailability, #DatabaseClustering, #MySQLLimitations, #MySQLGroupReplication, #MySQLHA, #DatabaseReplication, #DatabaseScaling, #MySQLPodcast, #ReplicationChallenges, #OpenSourceDatabase, #HighAvailabilityThe MySQL Group Replication InnoDB Cluster Podcast Series---------------------------------------------------------------------------------------------------Ep. 1. Introduction to Group ReplicationEp. 2. Introduction to MySQL Innodb ClusterEp. 3. MySQL Group Replication Use CasesEp. 4. MySQL Group Replication requirementsEp. 5. Limitations of MySQL Group Replication InnoDB ClusterEp. 6. Comparing MySQL InnoDB Cluster with other solutionsEp. 7. Key Concepts in MySQL Group Replication InnoDB ClusterThis series is designed for DBAs, DevOps engineers, architects, and MySQL enthusiasts who want to understand MySQL high availability and clustering technologies.🔔 Subscribe for more MySQL tips and deep dives!📖 Blog: https://kedar.nitty-witty.com/blog/💬 Got questions? Drop them in the comments!
7 Jul 2025
MySQL InnoDB Cluster Group Replication - Part 4 - Requirements
🎙️ 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 Multithreaded Appliers & XA Transactions Key Deployment Limitations#MySQL, #GroupReplication, #MySQLReplication, #MySQLHighAvailability, #DatabaseClustering, #MySQLGroupReplication, #MySQLRequirements, #DatabaseConfiguration, #DatabaseNetworking, #MySQLGTID, #MySQLHA, #OpenSourceDatabase, #DatabaseAdministration, #MySQLPodcast, #DatabaseReplicationThe MySQL Group Replication InnoDB Cluster Podcast Series---------------------------------------------------------------------------------------------------Ep. 1. Introduction to Group ReplicationEp. 2. Introduction to MySQL Innodb ClusterEp. 3. MySQL Group Replication Use CasesEp. 4. MySQL Group Replication requirementsEp. 5. Limitations of MySQL Group Replication InnoDB ClusterEp. 6. Comparing MySQL InnoDB Cluster with other solutionsEp. 7. Key Concepts in MySQL Group Replication InnoDB ClusterThis series is designed for DBAs, DevOps engineers, architects, and MySQL enthusiasts who want to understand MySQL high availability and clustering technologies.🔔 Subscribe for more MySQL tips and deep dives!📖 Blog: https://kedar.nitty-witty.com/blog/💬 Got questions? Drop them in the comments!
7 Jul 2025
MySQL InnoDB Cluster Group Replication - Part 3 - Use Cases
🎙️ Welcome to the third episode of our MySQL Group Replication Podcast Series! Ep. 3. MySQL Group Replication Use CasesIn this episode, we explore the best use cases for MySQL Group Replication (GR) — a high availability and fault-tolerant solution for MySQL.You’ll learn: When to use MySQL Group Replication. Key environments where GR excels, including high-availability architectures, cloud deployments, and mission-critical systems. How GR offers zero data loss (RPO = 0), automatic failover, and robust read/write scaling. Real-world scenarios like e-commerce platforms, financial systems, and cloud-native apps. When multi-primary (active-active) setups are suitable — and when they aren’t.We also compare GR with traditional MySQL replication, highlighting its advantages for applications requiring strong consistency, automated failover, and simplified HA operations.#MySQL, #GroupReplication, #MySQLReplication, #MySQLHighAvailability, #DatabaseClustering, #MySQLGroupReplication, #MySQLHA, #DatabaseFailover, #ZeroDataLoss, #MySQLScaling, #DatabaseResilience, #MultiPrimaryReplication, #MySQLPodcast, #OpenSourceDatabase, #CloudDatabasesThe MySQL Group Replication InnoDB Cluster Podcast Series---------------------------------------------------------------------------------------------------Ep. 1. Introduction to Group ReplicationEp. 2. Introduction to MySQL Innodb ClusterEp. 3. MySQL Group Replication Use CasesEp. 4. MySQL Group Replication requirementsEp. 5. Limitations of MySQL Group Replication InnoDB ClusterEp. 6. Comparing MySQL InnoDB Cluster with other solutionsEp. 7. Key Concepts in MySQL Group Replication InnoDB ClusterThis series is designed for DBAs, DevOps engineers, architects, and MySQL enthusiasts who want to understand MySQL high availability and clustering technologies.🔔 Subscribe for more MySQL tips and deep dives!📖 Blog: https://kedar.nitty-witty.com/blog/💬 Got questions? Drop them in the comments!
7 Jul 2025
MySQL InnoDB Cluster Group Replication - Part 2 - Introduction to InnoDB Cluster
🎙️ Welcome to the second episode of our MySQL Group Replication Podcast Series! Ep. 2. Introduction to MySQL InnoDB ClusterIn this episode, we introduce MySQL InnoDB Cluster — a complete, integrated solution for high availability and scalability in MySQL. It combines multiple MySQL technologies to deliver a robust, fault-tolerant database deployment.✅ Summary of points covered here are as follows: What is MySQL InnoDB Cluster? Core Components: MySQL Server, MySQL Shell, MySQL Router Group Replication for High Availability AdminAPI for Cluster Management MySQL Router for Transparent Routing & Load Balancing Instance Provisioning with MySQL Clone Automatic Membership & Failover Single-Primary & Multi-Primary Modes Summary & Next Episode Preview#MySQL, #InnoDBCluster, #MySQLInnoDBCluster, #MySQLHighAvailability, #DatabaseClustering, #MySQLReplication, #MySQLGroupReplication, #MySQLRouter, #MySQLShell, #DatabaseFailover, #DatabaseScalability, #MySQLHA, #OpenSourceDatabase, #DatabaseAdministration, #MySQLPodcastThe MySQL Group Replication InnoDB Cluster Podcast Series----------------------------------------------------------------------------------------------------Ep. 1. Introduction to Group ReplicationEp. 2. Introduction to MySQL Innodb ClusterEp. 3. MySQL Group Replication Use CasesEp. 4. MySQL Group Replication requirementsEp. 5. Limitations of MySQL Group Replication InnoDB ClusterEp. 6. Comparing MySQL InnoDB Cluster with other solutionsEp. 7. Key Concepts in MySQL Group Replication InnoDB ClusterThis series is designed for DBAs, DevOps engineers, architects, and MySQL enthusiasts who want to understand MySQL high availability and clustering technologies.🔔 Subscribe for more MySQL tips and deep dives!📖 Blog: https://kedar.nitty-witty.com/blog/💬 Got questions? Drop them in the comments!
7 Jul 2025
MySQL InnoDB Cluster Group Replication - Part 1 - Introduction
🎙️ Welcome to the first episode of our MySQL Group Replication Podcast Series! Ep. 1. Introduction to Group ReplicationIn this episode, we introduce MySQL Group Replication (GR) — a native, powerful solution for creating highly available, fault-tolerant, and scalable MySQL clusters.Summary of points covered here are as follows:------------------------------------------------------------------------------- Introduction- What is MySQL Group Replication?- Core Concepts & Architecture- Single-Primary vs Multi-Primary Modes- Automatic Failover & Recovery- Network Partition Handling- Open Source & Platform Support- Summary & Next Episode PreviewThe MySQL Group Replication InnoDB Cluster Podcast SeriesEp. 1. Introduction to Group ReplicationEp. 2. Introduction to MySQL Innodb ClusterEp. 3. MySQL Group Replication Use CasesEp. 4. Introduction to MySQL Group Replication requirementsEp. 5. Limitations of MySQL Group Replication InnoDB ClusterEp. 6. Comparing MySQL InnoDB Cluster with other solutionsEp. 7. Key Concepts in MySQL Group Replication InnoDB ClusterThis series is designed for DBAs, DevOps engineers, architects, and MySQL enthusiasts who want to understand MySQL high availability and clustering technologies.🔔 Subscribe for more MySQL tips and deep dives!📖 Blog: https://kedar.nitty-witty.com/blog/💬 Got questions? Drop them in the comments!#MySQL, #GroupReplication, #MySQLReplication, #DatabaseCluster, #HighAvailability, #MySQLGroupReplication, #MySQLHA, #DatabaseReplication, #InnoDBCluster, #MySQLPodcast, #DatabasePodcast, #MySQLTutorial, #DevOps, #DBA, #OpenSourceDatabases
13 Apr 2025
MySQL Archiving Basics - considerations, mistakes, best practices
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 or risking data loss.We'll cover: ✅ Why archiving is essential for performance & cost✅ When and what data to archive✅ Methods like partitioning, pt-archiver, and pt-online-schema-change✅ Best practices to follow and common pitfalls to avoid✅ How to reclaim disk space post-archivalWhether you're a DBA, developer, or performance enthusiast, this guide will help you keep your MySQL databases lean and fast!📖 Read the full blog (https://kedar.nitty-witty.com/blog/mysql-data-archiving-basics-considerations-mistakes-best-practices) 🔔 Subscribe for more MySQL tips and deep dives!💬 Got questions? Drop them in the comments!#MySQL (https://www.youtube.com/hashtag/mysql) #DataArchival (https://www.youtube.com/hashtag/dataarchival) #DatabasePerformance (https://www.youtube.com/hashtag/databaseperformance) #ptarchiver (https://www.youtube.com/hashtag/ptarchiver) #ptonlineschemachange (https://www.youtube.com/hashtag/ptonlineschemachange) #MySQLTuning (https://www.youtube.com/hashtag/mysqltuning) #DBA (https://www.youtube.com/hashtag/dba) #Percona (https://www.youtube.com/hashtag/percona) #Partitioning (https://www.youtube.com/hashtag/partitioning)
4 Mar 2025
Choosing ProxySQL Versions
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 documentation and release notes to prepare a summary.Here is the quick 10 minutes podcast discussion for you to have a quick review.I strongly recommend reviewing Official Documentation and Release Notes before making any decisions.Author: https://kedar.nitty-witty.com/blogReferences:1. https://github.com/sysown/proxysql/releases2. https://proxysql.com/documentation/#MySQL #ProxySQL #databaseconcepts #MySQLPodcast #podcast
29 Nov 2024
Useful scripts for MySQL in Percona Toolkit
In this episode, we explore several key tools within the Percona Toolkit that every database administrator and developer should know. From zero-downtime schema modifications to performance optimization and replication management, we cover essential tools that can improve your MySQL database management process. Key topics covered include: Zero-downtime schema changes with pt-online-schema-change Performance diagnostics and optimization with pt-mysql-summary, pt-summary, pt-kill, pt-query-digest, pt-duplicate-key-checker Replication management and data integrity with pt-slave-restart, pt-table-checksum, pt-table-sync Configuration management with pt-config-diff By the end of the episode, you'll have a clear understanding of how these tools work together to enhance efficiency, performance, and reliability when managing MySQL databases.
29 Nov 2024
MySQL Replication Basics - Part 3 Replica Lag
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 - Remedies and troubleshooting tips Learn how to keep your replicas in sync and ensure high availability! #MySQL #Replication #DatabasePerformance #MySQLTips #HighAvailability #DatabaseAdmin #MySQLTutorial #TechPodcast
20 Nov 2024
MySQL Replication Basics - Part 2 binary logs and more
Tune in to get a deeper understanding of how binary and relay logs are critical to MySQL replication. Whether you're optimizing replication performance or troubleshooting replication issues, this episode will equip you with the knowledge to take control of your MySQL replication environment. #MySQL #Replication #BinaryLogs #RelayLogs #Database #DBA #TechPodcast #MySQLReplication
20 Nov 2024
MySQL Replication Basics - Part 1
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 availability and scalability in your database environments. Introduction to MySQL Replication * What is MySQL Replication? * Overview of replication concepts * Why Use MySQL Replication? * Key Terminology in MySQL Replication Master (Primary) Slave (Replica) Binary Log (binlog) Relay Log I/O Thread SQL Thread Replication Filters (database and table level replication filters)
15 Nov 2024
Low Hanging Fruits of MySQL Performance
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 it. This will be a talk about the low hanging fruits to get the best outcome preferably in a short time or with small efforts. This will include configuration, performance and the most common problem scenarios that you can relate, examine and implement.
15 Nov 2024
Duplicate Indexes in MySQL and more
In this podcast, we’ll explore the issue of duplicate indexes in MySQL; including redundant index, foreign keys, left-prefixed secondary index /w primary key, and how to tackle the issue at hand. Reference: https://kedar.nitty-witty.com/blog/podcast-duplicate-indexes-in-mysql
15 Nov 2024
MySQL Change Buffer - A discussion and FAQ
In the world of database management, efficiency is key. MySQL’s change buffer is a powerful feature that helps optimize how secondary index changes are managed. The idea of introducing a change buffer is an amazing solution for enhancing MySQL performance. Let’s explore the change buffer, how it works, and when you might want to enable or disable it. Reference: https://kedar.nitty-witty.com/blog/mysql-change-buffer-what-when-and-faq
Podcast Authority Score: 29 / 100
A composite of feed quality, social presence, YouTube performance and engagement. Read the methodology.
- Quality
- 58
- Social presence
- 0
- YouTube
- 0
- Engagement
- 0
Contact Deep Dive MySQL
- Guest appearances
- Does not typically book guests
Based on episode analysis; this does not confirm that the show is currently accepting guests.
Host of Deep Dive MySQL?
Claim your podcast to manage its listing and keep your show details accurate.
Pod Engine is an independent podcast discovery and analytics service and is not affiliated with or endorsed by this podcast. Artwork and show content belong to their owners. Full legal notice.
Explore this show
Podcast research with Pod Engine