Understanding MySQL Binary Log (binlog): Architecture, Usage, and Implementation

This article explains MySQL's binary log (binlog), a binary format file that records SQL statements for database updates, its role in master-slave replication, crash recovery, and detailed implementation mechanisms including cache management and event writing processes.

BinlogDatabase InternalsDatabase Replication

0 likes · 8 min read

Understanding MySQL Binary Log (binlog): Architecture, Usage, and Implementation

NetEase LeiHuo UX Big Data Technology

Jan 18, 2022 · Databases

Understanding MySQL Logical Architecture and Its Logging Mechanisms (Binlog, Redo Log, Undo Log)

This article explains MySQL's three‑layer logical architecture, the roles of binary log, redo log, and undo log, how they interact during data updates, and the configuration options that affect durability and performance.

Database ArchitectureTransaction Loggingbinary log

0 likes · 11 min read

Understanding MySQL Logical Architecture and Its Logging Mechanisms (Binlog, Redo Log, Undo Log)

Qunar Tech Salon

Feb 12, 2020 · Databases

Understanding MySQL REDO Log: Purpose, Types, and Flush Timing

This article explains the essential role of MySQL REDO logs in ensuring data durability and performance, describes what would happen without logging, details various REDO log record formats, and outlines the multiple moments when InnoDB flushes logs to disk.

Database PerformanceInnoDBLog Flushing

0 likes · 18 min read

Understanding MySQL REDO Log: Purpose, Types, and Flush Timing