Sep 2, 2024 · Databases

Master MySQL Logs: Redo, Binlog, Undo & Crash‑Safe Mechanisms Explained

This article compiles 15 classic MySQL log interview questions and provides detailed explanations of redo log, WAL, binlog, undo log, two‑phase commit, crash‑safe mechanisms, and related configuration parameters, helping readers understand database recovery and replication fundamentals.

BinlogCrash SafeDatabase Recovery

0 likes · 17 min read

Master MySQL Logs: Redo, Binlog, Undo & Crash‑Safe Mechanisms Explained

Youzan Coder

Mar 27, 2019 · Databases

MySQL Slave Crash-Safe Feature Analysis

The article examines MySQL 5.6’s crash‑safe slave replication, explaining how earlier versions’ unsafe relay‑log handling could corrupt position data, describing the atomic update of mysql.slave_relay_log_info via table‑based relay‑log info and transaction coordination, and covering configuration options, recovery behavior, GTID implications, performance trade‑offs, and implementation guidance.

BinlogCrash SafeGTID

0 likes · 9 min read