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

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

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

关键词：分布式事务；数据库；mysql

mysql-based applications and defects of distributed affairs men wei

(china university of mining&technology,school of computer science&technology,xuzhou 221116,china)

abstract: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.

keywords:distributed affairs;database;mysql

一、分布式事务概述