Question: what is xa transaction in mysql?
Answer: 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.