BestHub
search
Sign in
Tag

Crash Safety

1 views collected around this technical thread.

Tencent Database Technology
Tencent Database Technology
Feb 22, 2022 · Databases

Analysis of Relay Log Recovery and Crash Safety in MySQL GTID‑Based and Binary‑Log‑File‑Position Replication

This article examines how MySQL slaves recover their replication state in GTID‑based and binary‑log‑file‑position scenarios, identifies unsafe factors that can cause crash‑unsafe behavior, and explains how enabling relay_log_recovery=on mitigates these risks while outlining remaining limitations.

Crash SafetyGTIDMTS
0 likes · 14 min read
Analysis of Relay Log Recovery and Crash Safety in MySQL GTID‑Based and Binary‑Log‑File‑Position Replication
vivo Internet Technology
vivo Internet Technology
May 20, 2020 · Databases

Understanding MySQL Crash‑Safe Mechanism: WAL, Redo/Undo/Binlog, Two‑Phase and Group Commit, and Recovery Process

MySQL achieves crash‑safe durability by employing a write‑ahead log architecture that records changes in redo, undo, and binary logs, coordinates them through two‑phase and group commit to maintain order, and uses a structured recovery process to replay or roll back transactions after any failure.

BinlogCrash SafetyTwo-Phase Commit
0 likes · 17 min read
Understanding MySQL Crash‑Safe Mechanism: WAL, Redo/Undo/Binlog, Two‑Phase and Group Commit, and Recovery Process