[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 Many thanks, JFG |
| Comments |
| Comment by Jean-François Gagné [ 2017-02-01 ] |
|
Upstream Bug#84779: https://bugs.mysql.com/bug.php?id=84779 |