BestHub
Sign in
Tagged articles
4 articles
Page 1 of 1
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.

InnoDBXA Transactioncrash recovery
0 likes · 11 min read
Understanding InnoDB Undo Segment States and MySQL XA Transaction Crash Recovery (MySQL 8.0.30)
Programmer DD
Programmer DD
Nov 28, 2020 · Backend Development

Deep Dive into ShardingSphere XA Distributed Transaction Support and Atomikos Integration

This article provides a comprehensive technical analysis of ShardingSphere's XA distributed transaction capabilities, covering the CAP theory, X/Open DTP model, MySQL XA support, JTA mapping, Atomikos initialization, transaction lifecycle (begin, getConnection, commit, rollback), and the recovery mechanism with detailed code snippets and diagrams.

AtomikosDistributed TransactionsJTA
0 likes · 34 min read
Deep Dive into ShardingSphere XA Distributed Transaction Support and Atomikos Integration
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.

XA Transactiondatabasedistributed-transaction
0 likes · 11 min read
Understanding and Practicing MySQL XA Distributed Transactions