Tagged articles
parallel-replication
33 articles · Page 1 of 1
A comprehensive guide to diagnosing and resolving MySQL master-slave replication delay, covering root causes like large transactions, parallel replication misconfiguration, hardware bottlenecks, lock contention, missing indexes, network issues, and semi-sync replication, with practical tools, monitoring setup, and real-world case studies.
GTIDLAGMySQL
0 likes · 88 min read

This article details a systematic approach to diagnose and resolve MySQL 8.0 replication lag by enabling WRITESET on the source, configuring LOGICAL_CLOCK with optimal worker count on the replica, and preserving commit order, complete with diagnostic queries, configuration steps, and validation metrics.
GTIDLOGICAL_CLOCKMySQL
0 likes · 31 min read

This guide provides a systematic methodology to diagnose and resolve MySQL replication lag spikes, covering evidence collection, replication status analysis, parallel replication tuning, large transaction mitigation, topology isolation, safe configuration changes, replica rebuild procedures, and proactive monitoring setup.
GTIDLAGMySQL
0 likes · 43 min read

To address MySQL master‑slave replication lag, the article explains enabling parallel replication (setting slave_parallel_workers), routing reads to the master for latency‑sensitive operations, and using a Redis short‑term marker to direct recent writes to the master, while outlining configuration steps and trade‑offs.
Database LagMySQLRead Routing
0 likes · 6 min read

When MySQL replication latency jumps from milliseconds to 10 seconds, blindly raising replica_parallel_workers won’t help; the article walks through diagnosing the delay, then applies three concrete parallel‑replication optimizations—enabling WRITESET on the source, configuring LOGICAL_CLOCK with appropriate applier workers, and optionally preserving commit order—while showing the required SQL commands, monitoring queries, and rollback steps.
GTIDLOGICAL_CLOCKMySQL
0 likes · 21 min read

This comprehensive guide explains why MySQL master‑slave replication can fall behind, walks through systematic diagnosis of common lag scenarios, and provides concrete configuration tweaks, parallel replication settings, GTID usage, monitoring queries, and upgrade paths to eliminate delay and improve reliability.
GTIDLAGMySQL
0 likes · 34 min read

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.
MySQLReplicationlatency
0 likes · 23 min read

The article examines common MySQL replication failures, explains why traditional position‑based replication is insufficient, and walks through a step‑by‑step evolution from file/position to GTID, asynchronous to semi‑synchronous, single‑threaded to parallel apply, culminating in a production‑grade architecture that achieves near‑zero data loss.
GTIDHigh AvailabilityMySQL
0 likes · 35 min read

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.
MySQLPerformance Tuningdatabase optimization
0 likes · 7 min read

Learn how to reduce MySQL 8 master‑slave replication delay from seconds to sub‑second levels by tuning five key parameters and applying three layers of parallel binlog replication, with detailed configuration examples, performance test results, troubleshooting tips, and ready‑to‑use scripts.
MySQLPerformance TuningReplication
0 likes · 8 min read

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.
Group CommitMySQLWRITESET
0 likes · 19 min read

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.
High AvailabilityMySQLReplication
0 likes · 30 min read

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.
Database LagMaster‑SlaveMySQL
0 likes · 14 min read

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 CommitMySQLPerformance Tuning
0 likes · 17 min read

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

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‑SlaveMySQL
0 likes · 33 min read

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

This article explains MySQL master‑slave replication, covering replication modes, use cases, required configurations, underlying mechanisms, common issues, and solutions such as semi‑synchronous and parallel replication, along with practical configuration examples and monitoring commands.
Master‑SlaveMySQLReplication
0 likes · 7 min read

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‑SlaveMySQL
0 likes · 8 min read

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.
MySQLfairness metricparallel-replication
0 likes · 8 min read

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.
Database InternalsMySQLTransaction Dependency
0 likes · 15 min read

This article provides a comprehensive, step‑by‑step analysis of MySQL’s binlog commit workflow, covering key parameters such as binlog_group_commit_sync_delay, sync_binlog, and binlog_transaction_dependency_tracking, and explains how last_commit and seq_number are generated and used in parallel replication.
Commit ProcessGTIDMySQL
0 likes · 15 min read

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

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.
MySQLReplicationSlave Lag
0 likes · 13 min read

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 ReplicationMySQLWRITESET
0 likes · 19 min read

The article analyzes a rare three‑thread deadlock caused by FLUSH TABLES WITH READ LOCK during parallel replication on MySQL 5.7, explains the MDL lock interactions, shows how to reproduce the issue, and provides practical kill‑thread and configuration solutions to avoid it.
MDL lockMySQLXtraBackup
0 likes · 11 min read

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

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 ArchitectureMySQLReplication
0 likes · 13 min read


21CTOFeb 25, 2016 · Databases
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.
MTSMySQLReplication
0 likes · 20 min read

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.
Database ReplicationMTSMySQL
0 likes · 17 min read


ITPUBJan 22, 2016 · Databases
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

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.
MySQLVersion Comparisonbinlog
0 likes · 14 min read

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.
MySQLReplicationSlave Lag
0 likes · 6 min read
