mysql+分布事务_Mysql分布事务的探索

由于项目需要,对mysql分布事务有一定要求.这里先简单说明必要.

假设,日常财务中,要完成一个拥护订购,必须将定单操作和财务操作封在一个事务中才能保证交易完整性.

如果定单和财务数据都分布在各自的实例中,则必须用分布事务才能满足.

废话不多，进入分布事务探索。

(本文例子来自网络，本文只注重探索)

1.在本机 localhost和另一台机器上192.168.123.xxx上支持分布事务的数据库test里建下表:

CREATE TABLE `test_transation1` (

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

`name` varchar(255) DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

2.然后每个表分别插入数据

insert into test_transation1  (name) value('jonhn2');

insert into test_transation1  (name) value('jonhn');

3.用下脚本测试

$mapfarm = new mysqli("192.168.123.xx","test","testtest","test");

$map     = new mysqli("localhost","root","","test");

$age = rand(1, 255);

$grid = uniqid("");

$map->query("XA START '$grid'");

$mapfarm->query("XA START '$grid'");

$values = array(1,"");

$id = rand(1,2);

try {

$sql="UPDATE test_transation1 SET name=$age WHERE id=$id";

print $sql." 113
";

$return = $map->query($sql);

if($return == false) {

throw new Exception("113更新失败!$sql ");

}

$sql="UPDATE test_transation1 SET name=$age WHERE id=$id";

print $sql." 116
";

$return = $mapfarm->query($sql);

if($return == false) {

throw new Exception("116更新失败! ");

}

$map->query("XA END '$grid'");

$map->query("XA PREPARE '$grid'");

$mapfarm->query("XA END '$grid'");

$mapfarm->query("XA PREPARE '$grid'");

$mapfarm->query("XA COMMIT '$grid'");

$map->query("XA COMMIT '$grid'");

} catch (Exception $e) {

$mapfarm->query("XA ROLLBACK '$grid'");

$map->query("XA ROLLBACK '$grid'");

print "roll