Return the GTID of the most recent write transaction. This function helps determine the transaction ID to use for synchronization waiting.
WSREP_LAST_SEEN_GTID()Returns the Global Transaction ID of the most recent write transaction observed by the client.
The result can be useful to determine the transaction to provide to for waiting and unblocking purposes.
This page is licensed: CC BY-SA / Gnu FDL
Interact with the Galera Cluster plugin. These functions provide internal status information and control mechanisms specific to synchronous multi-master replication nodes.
Wait for a specific GTID to be applied. This function blocks the client until the node has committed the transaction with the specified Global Transaction ID.
WSREP_SYNC_WAIT_UPTO_GTID(gtid[,timeout])Blocks the client until the transaction specified by the given Global Transaction ID is applied and committed by the node.
The optional timeout argument can be used to specify a block timeout in seconds. If not provided, the timeout will be indefinite.
Returns the node that applied and committed the Global Transaction ID, ER_LOCAL_WAIT_TIMEOUT if the function is timed out before this, or ER_WRONG_ARGUMENTS if the function is given an invalid GTID.
The result from can be useful to determine the transaction to provide to WSREP_SYNC_WAIT_UPTO_GTID for waiting and unblocking purposes.
This page is licensed: CC BY-SA / Gnu FDL
Return the GTID of the client's last write. This function identifies the specific transaction ID generated by the current client's most recent write operation.
WSREP_LAST_WRITTEN_GTID()Returns the Global Transaction ID of the most recent write transaction performed by the client.
This page is licensed: CC BY-SA / Gnu FDL