Aikesheng Open Source Community
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.
BinaryLogDatabasePerformanceDebugging
0 likes · 27 min read