BestHub
search
Sign in
Tag

BinaryLog

0 views collected around this technical thread.

Aikesheng Open Source Community
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
Deep Dive into MySQL Seconds_Behind_Master Calculation in Dual‑Master Replication
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 28, 2020 · Databases

New Features in MySQL 8.0.20 Release

MySQL 8.0.20 introduces a range of enhancements including new SHOW_ROUTINE privilege, hash join improvements, index‑level optimizer hints, performance schema refinements, SQL syntax changes, InnoDB doublewrite buffer relocation, binary log transaction compression, X Plugin and protocol upgrades, and additional replication options.

BinaryLogFeaturesInnoDB
0 likes · 5 min read
New Features in MySQL 8.0.20 Release