Best of MySQL — October 2025

1. 1
   Article

   ByteByteGo·33w

   How Flipkart Built a Highly Available MySQL Cluster for 150+ Million Users

   Flipkart built Altair, an internally managed MySQL service that maintains high availability for 150+ million daily users through automated failover and primary-replica architecture. The system uses a three-layered monitoring approach (agent, monitor, orchestrator) to detect failures, prevent false positives, and execute failovers with minimal data loss. Altair prioritizes write availability over strong consistency using asynchronous replication, implements DNS-based service discovery for seamless failovers, and includes multiple safeguards against split-brain scenarios. The design balances operational simplicity with reliability, achieving near five-nines availability while managing thousands of database clusters across Flipkart's microservices infrastructure.

   120
2. 2
   Article

   MetalBear·30w

   Introducing DB Branching in mirrord: Run Against a Shared Environment With a Personal, Isolated Database

   mirrord introduces DB Branching, a feature that creates temporary, isolated database branches for testing schema changes and migrations safely. When enabled, it automatically overrides database connection strings to point to a separate branch that mirrors the main database, allowing developers to test changes without affecting shared staging environments. The feature currently supports MySQL databases and is available in mirrord for Teams, with a step-by-step guide demonstrating how to test schema changes using a Go service on Kubernetes.

   36
3. 3
   Article

   FREEK.DEV·33w

   SQL performance improvements: analysing & fixing the slow queries (part 2)

   Learn how to optimize slow SQL queries using indexes in MySQL 8.0. The post covers how indexes work internally, demonstrates using the EXPLAIN keyword to analyze query execution plans, and shows the performance impact of different index configurations on query speed.

   12