XA 分布式事务

SQL Statements

• xa begin xid
• insert / update / delete …
• xa end xid
• xa prepare xid
• xa commit xid
• xa rollback xid
• xa recover 查看当前的 xa 事务

Entities

• Transaction Manager (TM)
• Resource Manager (RM)

2PC

• xa prepare xid
• xa commit/rollback xid

Example

mysql> XA START 'xatest';
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO mytable (i) VALUES(10);
Query OK, 1 row affected (0.04 sec)
mysql> XA END 'xatest';
Query OK, 0 rows affected (0.00 sec)
mysql> XA PREPARE 'xatest';
Query OK, 0 rows affected (0.00 sec)
mysql> XA COMMIT 'xatest';
Query OK, 0 rows affected (0.00 sec)

XA 框架

• narayana
• bitronix
• atomikos
• Apache ShadingSphere
• java.sql.XADataSource

参考文献

https://dev.mysql.com/doc/refman/5.7/en/xa.html