![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_16461962658.webp)
Mysqlnd replication and load balancing plugin (
mysqlnd_ms
)
2638
Returns the latest global transaction ID
Description
string mysqlnd_ms_get_last_gtid(
mixed connection);
Returns a global transaction identifier which belongs to a write operation no older than the last write
performed by the client. It is not guaranteed that the global transaction identifier is identical to that one
created for the last write transaction performed by the client.
Parameters
connection
A PECL/mysqlnd_ms connection handle to a MySQL server of the
type
PDO_MYSQL
,
mysqli
> or
ext/mysql
. The connection handle is
obtained when opening a connection with a host name that matches
a mysqlnd_ms configuration file entry using any of the above three
MySQL driver extensions.
Return Values
Returns a global transaction ID (GTID) on success. Otherwise, returns
FALSE
.
The function
mysqlnd_ms_get_last_gtid
returns the GTID obtained when executing the SQL
statement from the
fetch_last_gtid
entry of the
global_transaction_id_injection
section
from the plugins configuration file.
The function may be called after the GTID has been incremented.
Notes
Note
mysqlnd_ms_get_last_gtid
requires PHP >= 5.4.0 and PECL mysqlnd_ms
>= 1.2.0. Internally, it is using a
mysqlnd
library C functionality not available
with PHP 5.3.
Examples
Example 20.297.
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));
?>
See Also
Global Transaction IDs
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...