MySQL supports local transactions (within a given client session)
through statements such as
Section 13.3.1, “START TRANSACTION, COMMIT, and ROLLBACK Syntax”. Beginning with MySQL 5.0, XA transaction
support is available, which enables MySQL to participate in
distributed transactions as well. See Section 13.3.7, “XA Transactions”.