Transaction Logging

政采云技术

Dec 27, 2023 · Databases

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.

Database InternalsMaster‑SlaveMySQL

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 ArchitectureMySQLTransaction Logging

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.

InnoDBLog FlushingMySQL

0 likes · 18 min read

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