Oct 30, 2020 · Databases

Understanding MySQL Binlog and Relaylog: Viewing Events, Formats, and Replication Mechanics

This article explains how to view MySQL binlog and relaylog events, interpret their formats using commands like SHOW BINARY LOGS, SHOW RELAYLOG EVENTS, hexdump and mysqlbinlog, and describes the underlying replication code paths, parameters, and source‑level handling of binlog transmission and processing.

RelayLogdatabasessource-code

0 likes · 17 min read

Understanding MySQL Binlog and Relaylog: Viewing Events, Formats, and Replication Mechanics

dbaplus Community

Jul 18, 2017 · Databases

Why MySQL Relay Logs Lost Thousands of Rows: A Real‑World Investigation

A senior MySQL engineer recounts a puzzling case where a custom script flushing relay logs caused the first transaction in each relay log to be skipped, leading to daily loss of nearly ten thousand rows in a rapidly growing production environment.

DataLossDatabaseOperationsRelayLog

0 likes · 8 min read

Why MySQL Relay Logs Lost Thousands of Rows: A Real‑World Investigation