what is xa transaction in mysql?
The XA implementation of MySQL enables the MySQL server to behave as a resource manager while the client connecting to the MySQL server performs the tasks of a transaction manager. XA uses two phase commit protocol where the first phase is the request for commit followed by the actual commit.