Tag

Pseudo GTID

0 views collected around this technical thread.

37 Interactive Technology Team
37 Interactive Technology Team
Jun 21, 2019 · Databases

Understanding MySQL Flashback: Principles, Tools, and Pseudo GTID

MySQL Flashback leverages the ROW‑format binary log to generate inverse DML statements—turning deletes into inserts, updates into reverse updates, and inserts into deletes—while tools parse WriteRows, UpdateRows, and DeleteRows events, using injected Pseudo GTID markers to delimit change ranges and enable automated rollback despite DDL limitations.

Binlog ParsingDatabase RecoveryFlashback
0 likes · 6 min read
Understanding MySQL Flashback: Principles, Tools, and Pseudo GTID