Skip to content
Tagged articles

binlog

305 articles · Page 4 of 4
ITPUB
ITPUB
Mar 17, 2016 · Databases

Why MySQL Relay Log Settings Cause Duplicate Key Errors and How to Fix Them

The article explains how MySQL replication parameters such as expire_logs_days, relay-log-recovery, and relay-log-info-repository affect binlog cleanup, SQL and I/O thread consistency, and why crashes can produce duplicate‑key errors, then offers configuration fixes including the critical relay‑log cleaning option and the super_read_only setting.

Data ConsistencyDatabase ConfigurationRelay Log
0 likes · 5 min read
Why MySQL Relay Log Settings Cause Duplicate Key Errors and How to Fix Them
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.

Database ReplicationMTSWorker Threads
0 likes · 17 min read
Understanding MySQL 5.6 Parallel Replication (MTS) Architecture and Implementation
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.

Version Comparisonbinlogmysql
0 likes · 14 min read
How MySQL Parallel Replication Evolved: From 5.5 to 5.7 and Beyond