Aikesheng Open Source Community

May 18, 2021 · Databases

Update Succeeds but Data Not Changed? Investigating MySQL Binlog vs Redo‑Log and Two‑Phase Commit

This article analyzes a puzzling MySQL update where the operation reports success yet the data remains unchanged, explains the WAL mechanism and two‑phase commit process, and provides a step‑by‑step binlog investigation script to uncover the root cause.