The Ultimate Guide to High Availability with MariaDB

BINLOG_GTID_POS

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

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.