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.

DatabaseInnoDBMySQL
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.

AtomikosJTAJava
0 likes · 34 min read
Deep Dive into ShardingSphere XA Distributed Transaction Support and Atomikos Integration