This comprehensive guide explains MySQL's binary log, undo log, redo log, and ChangeBuffer, covering their concepts, purposes, recording formats, flush timing, recovery processes, and how they interact during transactions and crash‑safe recovery.
The article explains how iQIYI’s order system leverages MySQL binlog and redo log with a two‑phase commit to drive event‑driven processing, reveals hidden consistency gaps where binlog events can precede database state, and proposes retry or direct binlog consumption strategies to ensure reliable order fulfillment.
This article explains the importance of database backup and details MySQL Enterprise Backup (MEB) features—Backup Lock, Redo Log Archiving, and Page Tracking—along with usage commands, performance considerations, and comparisons to xtrabackup for MySQL 8.0 environments.
This article explains the principles of full and incremental MySQL backups using XtraBackup, covering how redo logs, LSN timestamps, global read locks, and recovery steps ensure data consistency for both transactional and non‑transactional information.
