BestHub
search
Sign in
Tag

XA Transaction

1 views collected around this technical thread.

Tencent Database Technology
Tencent Database Technology
Feb 28, 2023 · Databases

Understanding InnoDB Undo Segment States and MySQL XA Transaction Crash Recovery (MySQL 8.0.30)

This article explains how InnoDB uses undo segment states for crash‑safe recovery, details the XA transaction protocol, describes bugs in earlier MySQL versions, and shows how MySQL 8.0.30 introduces a new undo state and revised prepare order to make external XA transactions crash‑safe, including code examples and recovery steps.

Crash RecoveryDatabaseInnoDB
0 likes · 11 min read
Understanding InnoDB Undo Segment States and MySQL XA Transaction Crash Recovery (MySQL 8.0.30)
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jun 28, 2020 · Databases

Understanding and Practicing MySQL XA Distributed Transactions

This article explains MySQL's support for XA distributed transactions, describes the two‑phase commit process, details the XA syntax, and walks through a complete hands‑on example that transfers money between two databases using XA START, END, PREPARE, RECOVER and COMMIT commands.

DatabaseMySQLSQL
0 likes · 11 min read
Understanding and Practicing MySQL XA Distributed Transactions