Aug 26, 2020 · Databases

Deep Dive into MySQL Seconds_Behind_Master Calculation in Dual‑Master Replication

This article investigates why the Seconds_Behind_Master metric fluctuates in a dual‑master MySQL setup, explains the underlying replication logic, reproduces the issue, and analyses the handling of ROTATE_EVENT and other binlog events in both parallel and non‑parallel replication modes using source code excerpts.

BinaryLogDatabasePerformanceParallelReplication

0 likes · 27 min read

Deep Dive into MySQL Seconds_Behind_Master Calculation in Dual‑Master Replication

dbaplus Community

Jan 31, 2018 · Databases

How to Systematically Diagnose and Fix MySQL Master‑Slave Replication Lag

This article walks through a real‑world case of MySQL 5.7 replication delay after switching to TokuDB, presenting a step‑by‑step methodology that examines network, hardware, large transactions, locks, configuration parameters, and multi‑threaded replication to identify and resolve the root cause.

DBALagParallelReplication

0 likes · 12 min read

How to Systematically Diagnose and Fix MySQL Master‑Slave Replication Lag