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

Aikesheng Open Source Community

Sep 24, 2020 · Databases

Modifying mysqldump to Remove DEFINER and Add Progress Display for MySQL 5.7

This article explains why restoring MySQL backups can fail due to missing SUPER privileges, describes the DEFINER and SQL SECURITY concepts, and details how the mysqldump source code was altered for MySQL 5.7 to strip DEFINER clauses, show backup progress, and improve performance testing.

DEFINERmysqldumpperformance

0 likes · 8 min read

Modifying mysqldump to Remove DEFINER and Add Progress Display for MySQL 5.7