BestHub
Sign in
Tagged articles
13 articles
Page 1 of 1
Architecture Digest
Architecture Digest
Sep 25, 2025 · Databases

How to Tackle MySQL Master‑Slave Replication Lag and Prevent Dirty Reads

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.

Replication LagSemi-synchronouscache invalidation
0 likes · 9 min read
How to Tackle MySQL Master‑Slave Replication Lag and Prevent Dirty Reads
Aikesheng Open Source Community
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.

Large TransactionsPerformance OptimizationReplication Lag
0 likes · 8 min read
Root Cause Analysis of MySQL Replication Lag Caused by Large Transactions in a Sharding Scenario
Open Source Tech Hub
Open Source Tech Hub
Sep 25, 2024 · Databases

How to Safely Delete Large Log Tables and Resolve MySQL Read‑Replica Lag

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 MaintenanceRDS
0 likes · 6 min read
How to Safely Delete Large Log Tables and Resolve MySQL Read‑Replica Lag
Meituan Technology Team
Meituan Technology Team
Jul 6, 2023 · Databases

Meituan Database Fault Detection, Diagnosis, and Kernel Observability Practices

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
Meituan Database Fault Detection, Diagnosis, and Kernel Observability Practices
ITPUB
ITPUB
Nov 11, 2022 · Databases

Master‑Slave Replication & Read/Write Splitting in MySQL: Benefits, Pitfalls, Tips

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 middlewareReplication Lagmaster-slave replication
0 likes · 13 min read
Master‑Slave Replication & Read/Write Splitting in MySQL: Benefits, Pitfalls, Tips
ITPUB
ITPUB
Nov 6, 2022 · Databases

Why Can’t You Read Your Recent Write? Understanding Master‑Slave Lag and Fixes in MySQL

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
Why Can’t You Read Your Recent Write? Understanding Master‑Slave Lag and Fixes in MySQL
dbaplus Community
dbaplus Community
Jul 26, 2022 · Databases

Master MySQL Data Archiving with pt-archiver: Install, Run, and Optimize

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.

Replication LagSQLbulk operations
0 likes · 19 min read
Master MySQL Data Archiving with pt-archiver: Install, Run, and Optimize
Aikesheng Open Source Community
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
Architecture Talk
Architecture Talk
May 16, 2019 · Databases

Why MySQL Replication Lag Happens and How to Fix It: Real-World Cases

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‑SlaveReplication Lag
0 likes · 13 min read
Why MySQL Replication Lag Happens and How to Fix It: Real-World Cases
UCloud Tech
UCloud Tech
Mar 28, 2019 · Databases

Why MySQL Replication Lag Happens and How to Fix It: Real-World Cases

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‑SlaveReplication Lag
0 likes · 13 min read
Why MySQL Replication Lag Happens and How to Fix It: Real-World Cases
Java High-Performance Architecture
Java High-Performance Architecture
Nov 7, 2016 · Databases

How to Monitor MySQL & PostgreSQL Replication Lag with pt-heartbeat

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.

Database MonitoringPostgreSQLReplication Lag
0 likes · 5 min read
How to Monitor MySQL & PostgreSQL Replication Lag with pt-heartbeat