Tagged articles
Replication Lag
15 articles · Page 1 of 1

liandkSep 11, 2026 · Databases
This article provides a comprehensive practical guide to MySQL master-slave replication, covering synchronization principles, three replication modes, delay causes and troubleshooting, read-write splitting implementation with common pitfalls, failover strategies, and five production pitfalls to avoid.
Database High AvailabilityDatabase ReplicationFailover
0 likes · 12 min read

This comprehensive guide covers MySQL read-write separation from fundamentals to production implementation, including master-slave replication principles, replication lag causes and three enterprise-grade solutions, one-master-multi-slave architecture patterns, MHA automatic failover, Sharding-JDBC middleware configuration, and five critical production pitfalls to avoid.
Database ArchitectureHigh AvailabilityMHA
0 likes · 10 min read

This article explains why MySQL master‑slave replication lag causes dirty reads, breaks down the asynchronous replication pipeline, and presents three practical mitigation strategies—including semi‑synchronous replication, forcing reads from the master, and cache double‑delete techniques—so you can choose the right solution for your workload.
MySQLReplication LagSemi‑synchronous
0 likes · 9 min read

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.
Large TransactionsMySQLReplication Lag
0 likes · 8 min read

This guide explains how to regularly purge oversized log tables using time‑based DELETE statements, interprets related cloud RDS and ECS alerts, and offers troubleshooting steps and batch‑deletion techniques to address MySQL read‑replica synchronization delays caused by large transactions.
Batch DeleteDatabase MaintenanceMySQL
0 likes · 6 min read

The article explains the design of Meituan’s MySQL autonomous platform, detailing its four‑layer architecture, statistical dynamic‑threshold anomaly detection, model selection based on time‑series distribution, kernel‑level root‑cause analysis for replication lag, large‑transaction diagnostics, and crash investigation using core‑dump and signal analysis.
Autonomous PlatformKernel DiagnosticsLarge Transactions
0 likes · 29 min read


ITPUBNov 11, 2022 · Databases
This article explains how MySQL master‑slave replication enables read/write splitting, details the asynchronous replication process, discusses latency and its impact on business logic, and presents practical mitigation strategies along with middleware options for accessing replicated databases.
DB middlewareMaster-Slave ReplicationMySQL
0 likes · 13 min read


ITPUBNov 6, 2022 · Databases
The article explains why a recent write may be invisible when reading from a MySQL replica, analyzes the replication threads and latency causes, and presents practical solutions such as forcing master reads, lag detection, semi‑sync mode, and GTID‑based waiting, with examples from Sharding‑JDBC, MyCat and MaxScale.
Database MiddlewareGTIDMaster‑Slave
0 likes · 10 min read

This guide explains how to use Percona Toolkit's pt-archiver for MySQL data archiving, covering installation, basic and bulk commands, underlying two‑phase‑commit logic, performance trade‑offs of various parameters, and best‑practice tips for safe, efficient archiving and deletion.
Data ArchivingMySQLReplication Lag
0 likes · 19 min read

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.
Log RotationMongoDBMtools
0 likes · 8 min read

This article explains why MySQL master‑slave replication lag occurs, why it matters for data consistency and high‑availability, and provides six real‑world case studies with root‑cause analysis and practical solutions to eliminate the delay.
Database PerformanceMaster‑SlaveMySQL
0 likes · 13 min read

This article examines the common causes of MySQL master‑slave replication delay, explains how to monitor the issue with SHOW SLAVE STATUS, and provides practical solutions for six typical scenarios ranging from heavy write traffic to hardware mismatches.
Database PerformanceMaster‑SlaveMySQL
0 likes · 13 min read

This article explains the fundamentals of database read‑write separation, compares master‑slave and master‑backup concepts, discusses replication lag issues, and presents code‑level and middleware approaches for routing reads and writes efficiently.
Database ArchitectureMaster-Slave ReplicationReplication Lag
0 likes · 6 min read


ITPUBJul 14, 2017 · Databases
A developer recounts a MySQL master‑slave replication lag issue that caused approved activity data to disappear, walks through the investigation steps, shows the faulty PHP code, and offers practical fixes to avoid similar pitfalls in future database designs.
Master‑SlaveMySQLPHP
0 likes · 5 min read

pt-heartbeat, a Percona Toolkit utility, enables precise monitoring of MySQL and PostgreSQL replication lag by creating a heartbeat table on the master, updating timestamps, and comparing them with slaves, with detailed installation steps, usage examples, and configuration guidance for reliable replication health checks.
MySQLPostgreSQLReplication Lag
0 likes · 5 min read
