BINLOG_GTID_POS
You are viewing an old version of this article. View
the current version here.
MariaDB starting with 10.0.2
From version 10.0.2, MariaDB supports global transaction IDs for replication.
Syntax
BINLOG_GTID_POS(binlog_filename,binlog_offset)
Description
The BINLOG_GTID_POS() function takes as input an old-style binary log position in the form of a file name and a file offset. It looks up the position in the current binlog, and returns a string representation of the corresponding GTID position. If the position is not found in the current binlog, NULL is returned.
Examples
SELECT BINLOG_GTID_POS("master-bin.000001", 600);
See also
- SHOW BINLOG EVENTS - Show events and their positions in the binary log
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
