GTID in MySQL 8.4+

[renecannao]

• [ ] A clear description of the issue

This issue is to report an incompatibility issue with MySQL 8.4+ if GTID is used with tags.

From https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html :

A GTID is represented as a pair of coordinates, separated by a colon character (:), as shown here: GTID = source_id:transaction_id ... MySQL 8.4 also supports tagged GTIDs. A tagged GTID consists of three parts, separated by colon characters, as shown here: GTID = source_id:tag:transaction_id

ProxySQL's behavior is currently undefined and needs to be investigated.

• [ ] ProxySQL version

All the versions to the latest (2.7.0)

• [ ] OS version

All

• [ ] The steps to reproduce the issue

It should be enough to configure ProxySQL to process GTIDs, and on the backend enable tags in GTIDs.

Note: this affects also the binlog reader: https://github.com/sysown/proxysql_mysqlbinlog