XA Transactions are transactions which span multiple databases and or applications. XA Transactions use 2-phase commit, which is also the same method which MySQL Cluster uses.
Internal XA Transactions are used to keep the binary log and InnoDB in sync.
Demo 1: XA Transaction on 1 node:
mysql55-tokudb6> XA START 'demo01';[Read more...]
Query OK, 0 rows affected (0.00 sec)
mysql55-tokudb6> INSERT INTO xatest(name) VALUES('demo01');
Query OK, 1 row affected (0.01 sec)
mysql55-tokudb6> SELECT * FROM xatest;
+----+--------+
| id | name |
+----+--------+
| 3 | demo01 |
+----+--------+
1 row in set (0.00 sec)
