[MDEV-11970] Expose binlog file and position of last transaction. Created: 2017-02-01  Updated: 2018-02-14

Status: Open
Project: MariaDB Server
Component/s: Replication
Fix Version/s: None

Type: Task Priority: Major
Reporter: Jean-François Gagné Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Hi,

the GTID of the last transaction is exposed via the last_gtid session variable ([1]).

[1]: https://mariadb.com/kb/en/mariadb/gtid/#last_gtid

In a Binlog Server deployment ([2]), the binlog file and position is a GTID. So knowing the binlog file and position of the last transaction is as valuable as knowing the GTID of the last transaction.

[2]: https://blog.booking.com/abstracting_binlog_servers_and_mysql_master_promotion_wo_reconfig...

So please consider exposing the binlog file and position of the last transaction in a session variable.

Also please consider exposing that in at the protocol level in the OK packet (related to MDEV-11956).

Many thanks,

JFG



 Comments   
Comment by Jean-François Gagné [ 2017-02-01 ]

Upstream Bug#84779: https://bugs.mysql.com/bug.php?id=84779

Generated at Thu Feb 08 07:54:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.