Mydbops Podcasts

Check out Mydbops Podcasts for some cool tips and tricks on MySQL, MariaDB, MongoDB, PostgreSQL, and TiDB.

PostgreSQL

PostgreSQL Disaster Recovery

Protecting your PostgreSQL database from failures, crashes, and cyber threats is critical. A strong PostgreSQL disaster recovery (DR) strategy ensures minimal downtime, quick recovery, and business continuity.

March 17, 2025

Listen Now

MongoDB

MongoDB Index Fragmentation

Index fragmentation in MongoDB can significantly slow down queries and increase resource consumption. In this episode, we explore how frequent writes, schema changes, and sharding contribute to fragmented indexes.

March 15, 2025

Listen Now

PostgreSQL

PostgreSQL Schema Explained

Learn how PostgreSQL schemas prevent naming conflicts, enhance security, and support multi-tenancy.

March 15, 2025

Listen Now

TiDB

Zero Downtime Upgrades in TiDB - TiProxy

TiProxy, a powerful proxy component in TiDB, designed to streamline connection management, load balancing, and service discovery. Learn how TiProxy enables zero downtime upgrades, ensures connection persistence, and optimizes dynamic workload management

March 15, 2025

Listen Now

MySQL

MySQL Partitioning

Partitioning is a game-changer for handling large datasets efficiently in MySQL. In this podcast, we break down MySQL Partitioning in 8.0.

March 1, 2025

Listen Now

TiDB

TiDB 8.5: The Game-Changing Features You Need to Know

TiDB 8.5.0 LTS is here, packed with groundbreaking features that redefine database performance, scalability, and security.

February 25, 2025

Listen Now

MongoDB

MongoDB 8 0 Slow Query Analysis

MongoDB 8.0 introduces a game-changing approach to slow query analysis! Instead of measuring total duration, the new workingMillis metric focuses on actual query execution time—helping you identify real performance bottlenecks.

February 25, 2025

Listen Now

MongoDB

MongoDB Data Fragmentation Explained

Learn how to identify and manage fragmentation in MongoDB, and discover the best strategies to keep your database efficient.

February 18, 2025

Listen Now

TiDB

TiDB's Garbage Collection

Garbage Collection plays a pivotal role in optimizing TiDB’s storage management by cleaning up outdated and obsolete data. We cover the entire GC lifecycle, including its core functions, the configuration options available to fine-tune the process, and best practices.

January 27, 2025

Listen Now

MongoDB

MongoDB Storage Optimization

Join us in this informative podcast episode as we dive deep into MongoDB storage optimization strategies. Learn about the best practices for reducing storage costs and improving database performance.

January 27, 2025

Listen Now

TiDB

TiDB Sync-Diff Inspector

Discover how TiDB Sync-Diff Inspector, an open-source tool, empowers you to compare and synchronize data across different databases effortlessly.

January 7, 2025

Listen Now

MongoDB

Protect MongoDB from Linux OOM Killer

In this episode, we dive deep into one of the most critical challenges facing MongoDB deployments on Linux: Out of Memory (OOM) situations.

December 30, 2024

Listen Now

MySQL

MySQL Binary Log Sequence Number Exhaustion

Did you know that reaching the maximum sequence number can lead to catastrophic server crashes? Join us as we explore the critical role of binary logs in MySQL, revealing how they impact replication and point-in-time recovery.

December 30, 2024

Listen Now

MySQL

MySQL Binlog Purge Error

Tune in now to learn from Mydbops' expert approach to MySQL troubleshooting - MySQL Binlog Purge Error

December 23, 2024

Listen Now

TiDB

TiDB Lightning

Discover the secrets to high-speed data imports with TiDB Lightning in this podcast

December 17, 2024

Listen Now

MySQL

MySQL 8.4 Tagged GTID

Learn how Tagged GTID feature in MySQL 8.4 innovative capability allows you to streamline replication, ensure data consistency, and manage complex setups like InnoDB Clusters and Group Replication.

December 17, 2024

Listen Now