基于MySQL的分布式事务的应用和缺陷

MySQL-based Applications and Defects of Distributed Affairs

MySQL从5．0．3版本就开始支持分布式事务，并且只有InnoDB存储引擎支持分布式事务。一个分布式事务涉及到多个事务性的活动，这些活动都必须一起完成或者一起被回滚。然而MySQL的分布式事务技术还在建设中，存在一定的漏洞。本文介绍MySQL在分布式事务中的应用并对其漏洞进行浅析。

Distributed Transaction has been supported by MySQL since the 5.0.3 version,and It is only be supported by InnoDB storage engine.A distributed transaction is referred to many transactional activities,and these activities must be finished together, otherwise,they will be rolled back together.However, the technology of Distributed Transaction in MySQL is under construction and it has also some bug.This paper will introduce the use of Distributed Transaction in MySQL and analyse the bugs simply.