Details
-
Task
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Won't Do
-
None
-
None
Description
Setup
Galera --> maxscale binlog router with second master --> slaves
If a node is down and maxscale switch to second master,
maxscale search for the fake gtid in the old binlog file,
because maxscale work in tree mode.
see example error message:
"server-id 2 reached end of file for binlog file [0/1/mariadb-bin.000005] at 222 which is not the file currently being downloaded " |
To use on every node and wsrep_domain id the same domain id is not a solution, because the binlogs are different, even if the same gtid are included.
Sugggestion:
- Maxscale must handle all transactions in gtid mode with wsrep_gtid_mode differently
- Maxscale must download the binlogs in the treefolder
- search transactions also in the new master folder , forget old poistion (can be different for the same gtid)
the new master and have to use the gtid in the new binlog with the new path. (tree mode)
- failover with do_domain_id (see
MXS-2581=
Attachments
Issue Links
- relates to
-
MDEV-20119 Implement the --do-domain-ids, --ignore-domain-ids, and --ignore-server-ids options for mysqlbinlog
-
- Closed
-
-
MXS-2581 Support DO_DOMAIN_IDS and IGNORE_DOMAIN_IDS for the Binlog Router
-
- Closed
-
-
MDEV-4989 Support for GTID in mysqlbinlog
-
- Closed
-
This was created in the context of the old binlog router, which is not developed anymore. If the issue is relevant also in the context of the new binlog router, please create a new issue.