Tagged articles
2 articles
Page 1 of 1
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
21CTO
21CTO
Mar 11, 2016 · Databases

How to Build Reliable MySQL HA: Replication, Monitoring, and Failover Strategies

This article explores practical MySQL high‑availability solutions, covering asynchronous and semi‑synchronous replication, monitoring with keepalived or Zookeeper, failover decision criteria, GTID and pseudo‑GTID techniques, and lessons learned from real‑world deployments.

GTIDHAPseudo GTID
0 likes · 13 min read
How to Build Reliable MySQL HA: Replication, Monitoring, and Failover Strategies