The use of MySQL distributed transactions

Assume that you have a table on MySQL instance 1

CREATE TABLE person (    int,     varchar(+))

MySQL Instance 2 also has a same table, now from the person table in instance 1 to delete a piece of data and insert this data into the table of instance 2, both operations in the same transaction, because across the database instance, involves a distributed transaction.

MySQL implements a distributed transaction to see if the database is enabled for XA transactions:

 like ' Innodb_support_xa ';

MySQL commands for XA:

 ' A ' a ' a ' ;

The above command is a method of operation for a distributed transaction, and entering the above command on a command line is not a real distributed transaction. You can use JTA to control the xa of MySQL.

The example will be added later:

The use of MySQL distributed transactions