API support for transactionsThe MySQL server supports transactions depending on the storage engine used. Since MySQL 5.5, the default storage engine is InnoDB. InnoDB has full ACID transaction support.
Transactions can either be controlled using SQL or API calls.
It is recommended to use API calls for enabling and disabling the
Example #1 Setting
Optional feature packages, such as the replication and load balancing plugin,
can easily monitor API calls. The replication plugin offers transaction
aware load balancing, if transactions are controlled with API calls.
Transaction aware load balancing is not available if SQL statements are
used for setting
Example #2 Commit and rollback
Please note, that the MySQL server cannot roll back all statements. Some statements cause an implicit commit. See also
|