BestHub
Sign in
Tagged articles
26 articles
Page 1 of 1
Raymond Ops
Raymond Ops
Apr 25, 2026 · Databases

How to Reduce MySQL Master‑Slave Replication Lag from 30 seconds to Milliseconds

This article walks through the root causes of MySQL master‑slave replication delay, demonstrates step‑by‑step diagnostics using SHOW SLAVE STATUS, pt‑heartbeat, and binlog comparisons, and provides concrete configuration changes, query rewrites, hardware upgrades, and monitoring scripts that can shrink lag from dozens of seconds to sub‑millisecond levels.

LatencyReplicationmonitoring
0 likes · 23 min read
How to Reduce MySQL Master‑Slave Replication Lag from 30 seconds to Milliseconds
Raymond Ops
Raymond Ops
Dec 27, 2025 · Databases

How to Cut MySQL Master‑Slave Lag to 0.2 seconds with Parallel Binlog Replication

This guide explains how to reduce MySQL master‑slave replication delay from seconds to sub‑second levels by configuring LOGICAL_CLOCK parallelism, binlog group‑commit tuning, and slave‑side optimizations, presenting concrete parameter settings, performance test results, monitoring scripts, advanced tips, and common pitfalls.

Database Optimizationmysqlparallel replication
0 likes · 7 min read
How to Cut MySQL Master‑Slave Lag to 0.2 seconds with Parallel Binlog Replication
Efficient Ops
Efficient Ops
Nov 13, 2023 · Databases

Understanding MySQL Parallel Replication: From Lag to Group Commit

This article explains why master‑slave lag occurs in MySQL, describes the evolution of parallel replication schemes—including group‑commit, Commit‑Parent‑Based, Lock‑Based, and WRITESET approaches—shows benchmark results, and provides practical configuration steps to enable high‑performance parallel replication.

BinlogGroup CommitWriteSet
0 likes · 19 min read
Understanding MySQL Parallel Replication: From Lag to Group Commit
Architect
Architect
Aug 19, 2023 · Databases

Deep Dive into MySQL Replication: Mechanisms, Performance, and Real‑World Optimizations

This article thoroughly examines MySQL replication, detailing binlog formats, event types, replication workflows, semi‑synchronous and parallel replication techniques, performance benchmarks, and practical implementation steps such as fake‑slave registration and connection‑pool enhancements, while illustrating each concept with concrete examples and code snippets.

BinlogPerformance OptimizationReplication
0 likes · 30 min read
Deep Dive into MySQL Replication: Mechanisms, Performance, and Real‑World Optimizations
Su San Talks Tech
Su San Talks Tech
Jul 28, 2023 · Databases

Master‑Slave Replication in MySQL: Binlog Mechanics, Parallel Replication & Lag Reduction

This article explains why a single MySQL instance is insufficient for production, introduces binlog concepts and formats, details the master‑slave replication threads and workflow, explores parallel replication mechanisms, analyzes causes of replication lag, and provides practical strategies to minimize that delay.

BinlogDatabase LagMaster‑Slave
0 likes · 14 min read
Master‑Slave Replication in MySQL: Binlog Mechanics, Parallel Replication & Lag Reduction
dbaplus Community
dbaplus Community
May 2, 2023 · Databases

How MySQL Parallel Replication Cuts Slave Lag: Group Commit, Lock‑Based & WRITESET Explained

This article explains why MySQL slave lag is a critical issue, compares the official parallel replication schemes—including Commit‑Parent‑Based, Lock‑Based, and WRITESET—details their internal mechanisms, presents benchmark results, and provides the exact configuration parameters needed to enable high‑performance parallel replication.

Group CommitReplicationWriteSet
0 likes · 17 min read
How MySQL Parallel Replication Cuts Slave Lag: Group Commit, Lock‑Based & WRITESET Explained
MaGe Linux Operations
MaGe Linux Operations
Dec 22, 2022 · Databases

MySQL 5.7 Parallel Replication: Architecture, Config & Performance Gains

This article explains MySQL 5.7’s enhanced multi‑threaded slave (MTS) parallel replication, contrasting it with the schema‑based approach of MySQL 5.6, detailing its group‑commit mechanism, configuration parameters, GTID handling, performance testing, and practical tuning tips for optimal replication throughput.

ConfigurationDatabase PerformanceGTID
0 likes · 14 min read
MySQL 5.7 Parallel Replication: Architecture, Config & Performance Gains
Java Interview Crash Guide
Java Interview Crash Guide
Jul 16, 2021 · Databases

Master‑Slave MySQL Replication: Core Principles, Common Pitfalls, and Advanced Strategies

This article explains MySQL master‑slave replication fundamentals, including basic synchronization, circular replication issues, lag handling, failover strategies, parallel replication techniques, GTID usage, and read‑write splitting, providing practical guidance for reliable high‑availability database deployments.

GTIDMaster‑SlaveReplication
0 likes · 33 min read
Master‑Slave MySQL Replication: Core Principles, Common Pitfalls, and Advanced Strategies
Selected Java Interview Questions
Selected Java Interview Questions
Jul 15, 2021 · Databases

Fundamentals and Advanced Strategies of MySQL Master‑Slave Replication

This article explains the basic principles of MySQL master‑slave architecture, the role of read‑only replicas, loop‑replication problems, master‑slave delay measurement, various failover strategies, parallel replication mechanisms across MySQL versions and MariaDB, GTID usage, and read‑write splitting techniques, providing practical commands and diagrams for each concept.

Database LagGTIDMaster‑Slave
0 likes · 31 min read
Fundamentals and Advanced Strategies of MySQL Master‑Slave Replication
Liangxu Linux
Liangxu Linux
Jan 31, 2021 · Databases

Why MySQL Replication Lags and How to Eliminate It

This article explains the root causes of MySQL master‑slave replication lag—including random replay, high master concurrency, and lock waits—and presents practical solutions such as parallel replication, reducing master load, and reading from the master to ensure data consistency.

LagMaster‑SlaveReplication
0 likes · 8 min read
Why MySQL Replication Lags and How to Eliminate It
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 11, 2020 · Databases

Understanding MySQL Parallel Replication: Schema‑based MTS, Logical Clock, Write‑Set and Fairness Metrics

This article explains the evolution of MySQL parallel replay from schema‑based MTS to logical‑clock and write‑set mechanisms, shows how to configure and tune parallel replication, and introduces a Jain‑index based fairness metric for evaluating the optimal number of slave_parallel_workers.

fairness metricmysqlparallel replication
0 likes · 8 min read
Understanding MySQL Parallel Replication: Schema‑based MTS, Logical Clock, Write‑Set and Fairness Metrics
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 2, 2019 · Databases

Understanding MySQL Write‑Set Based Parallel Replication and Last‑Commit Handling

This article explains MySQL's write‑set based parallel replication, detailing how writeset hashes are generated, stored in a historical map, and used to adjust the last‑commit value for improved parallel replay, including configuration parameters, code examples, and the impact of different dependency‑tracking modes.

BinlogDatabase InternalsTransaction Dependency
0 likes · 15 min read
Understanding MySQL Write‑Set Based Parallel Replication and Last‑Commit Handling
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 12, 2019 · Databases

Understanding MySQL MTS (Enhanced Multi‑Threaded Slave) and DTLE Configuration for Parallel Replication

This article explains how MySQL's enhanced multi‑threaded slave (MTS) feature, introduced in 5.6.3 and refined in 5.7, reduces replication lag, describes the DTLE component that enables MTS parallel replay, shows the required configuration parameters, and presents performance test results demonstrating up to six‑fold speed improvement.

DTLEGroup CommitMTS
0 likes · 6 min read
Understanding MySQL MTS (Enhanced Multi‑Threaded Slave) and DTLE Configuration for Parallel Replication
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 15, 2019 · Databases

Understanding and Solving MySQL Slave Lag: Causes, Scenarios, and Optimizations

This article analyzes common MySQL slave‑lag scenarios—including missing indexes, large master transactions, high write rates, and MyISAM backups—explains their risks, and provides practical solutions such as index tuning, hardware upgrades, configuration changes, and enabling parallel replication to improve replication performance.

ReplicationSlave Lagmysql
0 likes · 13 min read
Understanding and Solving MySQL Slave Lag: Causes, Scenarios, and Optimizations
dbaplus Community
dbaplus Community
Aug 13, 2018 · Databases

How MySQL 8.0’s WriteSet Parallel Replication Eliminates Replication Lag

This article explains the evolution of MySQL replication, from the classic master‑slave model to schema‑level and group‑commit parallelism in 5.7, and finally the WriteSet‑based parallel replication introduced in MySQL 8.0, including configuration parameters, conflict‑detection logic, and performance test results.

Database ReplicationWriteSetmysql
0 likes · 19 min read
How MySQL 8.0’s WriteSet Parallel Replication Eliminates Replication Lag
Tencent Database Technology
Tencent Database Technology
Dec 5, 2017 · Databases

Understanding MySQL Multi‑Threaded Slave (MTS) Parallel Replication: Schema, Commit‑Parent, and Lock‑Interval Methods

This article explains MySQL's evolution of parallel replication—from schema‑based MTS in 5.6, through commit‑parent based replication in 5.7, to the more efficient lock‑interval approach—detailing the underlying binlog group‑commit mechanisms, master‑side support, and the slave‑side worker coordination that together reduce replication lag.

MTSmysqlparallel replication
0 likes · 19 min read
Understanding MySQL Multi‑Threaded Slave (MTS) Parallel Replication: Schema, Commit‑Parent, and Lock‑Interval Methods
dbaplus Community
dbaplus Community
Nov 7, 2016 · Databases

Master‑Slave MySQL Replication: Multi‑Source and Parallel Techniques Explained

This article explains MySQL replication fundamentals, explores multi‑source master‑slave architectures, details step‑by‑step configuration for both basic 1‑master‑1‑slave and multi‑source setups, introduces parallel replication to boost performance, and presents Sysbench‑based testing results that demonstrate the efficiency gains.

Database ArchitecturePerformance TestingReplication
0 likes · 13 min read
Master‑Slave MySQL Replication: Multi‑Source and Parallel Techniques Explained
21CTO
21CTO
Feb 25, 2016 · Databases

Inside MySQL 5.6 Parallel Replication: Code Walkthrough and Design

This article explains how MySQL 5.6 introduced parallel replication to overcome the bottleneck of a single SQL thread, detailing the underlying binlog events, configuration parameters, key data structures, worker coordination, checkpoint mechanisms, and potential limitations, all from a source‑code perspective.

MTSReplicationmysql
0 likes · 20 min read
Inside MySQL 5.6 Parallel Replication: Code Walkthrough and Design
Architect
Architect
Feb 25, 2016 · Databases

Understanding MySQL 5.6 Parallel Replication (MTS) Architecture and Implementation

This article explains the design, configuration parameters, core data structures, initialization, coordinator distribution, worker execution, checkpointing, and shutdown procedures of MySQL 5.6's Multi‑Threaded Slave (MTS) parallel replication, providing a code‑level walkthrough for developers and DBAs.

BinlogCheckpointDatabase Replication
0 likes · 17 min read
Understanding MySQL 5.6 Parallel Replication (MTS) Architecture and Implementation
ITPUB
ITPUB
Jan 22, 2016 · Databases

How MySQL Parallel Replication Evolved: Strategies from 5.5 to 5.7

This article examines MySQL's shift from single‑threaded replication to parallel replication across versions 5.5, 5.6, MariaDB, and 5.7, comparing dispatch strategies, their trade‑offs, and practical scenarios where each approach improves or hinders replication performance.

5.7mysqlparallel replication
0 likes · 10 min read
How MySQL Parallel Replication Evolved: Strategies from 5.5 to 5.7
dbaplus Community
dbaplus Community
Jan 21, 2016 · Databases

How MySQL Parallel Replication Evolved: From 5.5 to 5.7 and Beyond

This article examines the evolution of MySQL parallel replication across versions 5.5, 5.6, MariaDB, and 5.7, comparing their threading strategies, binlog handling, performance trade‑offs, and practical deployment considerations for reducing replication lag.

Binlogmysqlparallel replication
0 likes · 14 min read
How MySQL Parallel Replication Evolved: From 5.5 to 5.7 and Beyond
MaGe Linux Operations
MaGe Linux Operations
Apr 17, 2015 · Databases

Why MySQL Slaves Lag Behind Masters and How to Speed Up Replication

This article explains the fundamental reasons why MySQL slave servers experience higher latency than masters and provides practical optimization techniques—including parallel replication, proper indexing, I/O improvements, and hardware choices—to reduce replication lag.

Database OptimizationReplicationSlave Lag
0 likes · 6 min read
Why MySQL Slaves Lag Behind Masters and How to Speed Up Replication