(PECL mysqlnd_ms >= 1.2.0)
mysqlnd_ms_get_last_gtid — 锟斤拷锟斤拷锟斤拷锟斤拷全锟斤拷同锟斤拷 ID (GTID)
锟斤拷锟斤拷锟斤拷锟揭伙拷锟叫达拷锟斤拷锟斤拷院锟斤拷 GTID锟斤拷锟斤拷锟斤拷锟斤拷锟杰憋拷证一锟斤拷锟斤拷锟角达拷写锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 GTID锟斤拷锟斤拷锟角得碉拷锟斤拷 GTID 一锟斤拷锟斤拷锟斤拷锟叫达拷锟斤拷锟斤拷锟斤拷锟斤拷锟� GTID 锟斤拷
锟缴癸拷锟斤拷锟斤拷 GTID锟斤拷失锟杰凤拷锟斤拷 FALSE
锟斤拷
锟斤拷锟斤拷通锟斤拷锟斤拷锟斤拷锟侥硷拷锟斤拷 global_transaction_id_injection 锟铰节讹拷锟斤拷锟� fetch_last_gtid 锟斤拷锟斤拷锟斤拷锟斤拷取 GTID锟斤拷
锟节猴拷锟斤拷锟斤拷锟矫碉拷时锟斤拷GTID 锟斤拷锟斤拷锟窖撅拷锟斤拷锟斤拷锟剿★拷
Note:
锟斤拷锟斤拷锟斤拷要 PHP >= 5.4.0 锟芥本锟斤拷PECL/mysqlnd_ms >= 1.2.0 锟芥本锟斤拷锟斤拷 PHP 5.3 锟芥本锟斤拷 mysqlnd 锟解不锟斤拷使锟矫★拷
Example #1 mysqlnd_ms_get_last_gtid() example
<?php
/* Open mysqlnd_ms connection using mysqli, PDO_MySQL or mysql extension */
$mysqli = new mysqli("myapp", "username", "password", "database");
if (!$mysqli)
/* Of course, your error handling is nicer... */
die(sprintf("[%d] %s\n", mysqli_connect_errno(), mysqli_connect_error()));
/* auto commit mode, transaction on master, GTID must be incremented */
if (!$mysqli->query("DROP TABLE IF EXISTS test"))
die(sprintf("[%d] %s\n", $mysqli->errno, $mysqli->error));
printf("GTID after transaction %s\n", mysqlnd_ms_get_last_gtid($mysqli));
/* auto commit mode, transaction on master, GTID must be incremented */
if (!$mysqli->query("CREATE TABLE test(id INT)"))
die(sprintf("[%d] %s\n", $mysqli->errno, $mysqli->error));
printf("GTID after transaction %s\n", mysqlnd_ms_get_last_gtid($mysqli));
?>