Replication Lag

Aikesheng Open Source Community

May 22, 2025 · Databases

Root Cause Analysis of MySQL Replication Lag Caused by Large Transactions in a Sharding Scenario

This article examines a real‑world MySQL master‑slave replication lag issue caused by massive multi‑table transactions during a sharding operation, details the investigative steps using system tables, binlog parsing, and my2sql analysis, and proposes three practical mitigation strategies.

MySQLReplication LagSharding

0 likes · 8 min read

Root Cause Analysis of MySQL Replication Lag Caused by Large Transactions in a Sharding Scenario

Aikesheng Open Source Community

Jun 21, 2021 · Databases

Diagnosing a MongoDB Shard Connection Storm that Caused Replication Lag and Automatic Failover

The article details a MongoDB 3.4 sharded cluster incident where a sudden connection storm overwhelmed the primary, leading to replication lag, automatic failover, and how monitoring, log analysis with mtools, and a custom log‑rotation script were used to diagnose and resolve the issue.

Connection StormDatabase MonitoringMongoDB

0 likes · 8 min read

Diagnosing a MongoDB Shard Connection Storm that Caused Replication Lag and Automatic Failover

Aikesheng Open Source Community

May 13, 2021 · Databases

Understanding exec_time in MySQL Binlog and Its Impact on Replication Lag

This article investigates the meaning of exec_time in MySQL binary logs, demonstrates how row and statement binlog formats record execution times through systematic tests, analyzes the underlying principles, and shows how exec_time can be used to diagnose replication lag caused by CPU, disk, or network bottlenecks.

MySQLReplication LagTroubleshooting

0 likes · 16 min read

Understanding exec_time in MySQL Binlog and Its Impact on Replication Lag