MySQL Distributed transaction

For a description of MySQL distributed transactions, refer to: http://blog.csdn.net/luckyjiuyi/article/details/46955337

It is divided into two phases: the preparation and execution phases. There are two roles: the manager of the transaction (TM) and the transaction performer (Rm,mysql Server).

XA start transaction starts the identity so that the transaction is in the active state

XA End Transaction End identity, leaving the transaction in an idle state

An XA PREPARE notification prepares the identity when the transaction is in an idle state, in the prepared state

For the prepared state, an XA commit commits the transaction

For the prepared state, the XA ROLLBACK rolls back the transaction

XA RECOVER See which transactions are in the Ready (PREPARED) state.

Also refer to: Http://www.tuicool.com/articles/B3UZri2

MySQL Distributed transaction