Does MySQL support distributed transaction?

Are transactions supported by MySQL?

MySQL supports local transactions (within a given client session) through statements such as SET autocommit , START TRANSACTION , COMMIT , and ROLLBACK . See Section 13.3. 1, “START TRANSACTION, COMMIT, and ROLLBACK Statements”. XA transaction support enables MySQL to participate in distributed transactions as well.

Is MySQL a transactional database?

Properties Of MySQL TRANSACTION MySQL supports the ACID properties for a transaction-safe Relational Database Management System.

What is distributed database transaction?

A distributed transaction is a set of operations on data that is performed across two or more data repositories (especially databases). It is typically coordinated across separate nodes connected by a network, but may also span multiple databases on a single server.

How distributed transactions work in SQL Server?

Distributed transactions ensure that data changes within databases on multiple servers are kept in sync within the context of the single T-SQL transaction. This ensures that applications made up of multiple databases on multiple servers are transactionally consistent with each other.