BestHub
Sign in
Tagged articles
8 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
Practical DevOps Architecture
Practical DevOps Architecture
Jun 4, 2024 · Databases

Causes and Solutions for MySQL Master‑Slave Replication Lag

This article explains why MySQL master‑slave replication can become delayed—including single‑threaded binlog processing, high load, network latency, and configuration issues—and provides detailed troubleshooting steps and practical solutions such as semi‑synchronous replication, hardware upgrades, and configuration tuning.

Database ArchitectureLatencySemi-synchronous
0 likes · 8 min read
Causes and Solutions for MySQL Master‑Slave Replication Lag
vivo Internet Technology
vivo Internet Technology
Apr 5, 2023 · Databases

Understanding MySQL Replication: Principles, Mechanisms, and Practical Applications

MySQL replication copies data changes from a primary server to one or more replicas using binlog events—supporting statement, row, or mixed formats and GTID positioning—to provide real‑time backup, read‑write separation, high‑availability failover, and integration pipelines via asynchronous, semi‑synchronous, or centralized binlog services.

BinlogData ReliabilityGTID
0 likes · 30 min read
Understanding MySQL Replication: Principles, Mechanisms, and Practical Applications
dbaplus Community
dbaplus Community
Aug 22, 2017 · Databases

How UDB Supercharges MySQL Replication with Deep Kernel Optimizations

This article details UDB's high‑availability architecture and four kernel‑level optimizations—binlog replication, relay‑log recording, master.info handling, and relay‑log locking—that together improve MySQL semi‑synchronous replication performance and reliability.

Database OptimizationReplicationSemi-synchronous
0 likes · 9 min read
How UDB Supercharges MySQL Replication with Deep Kernel Optimizations