[MXS-2589] Adapt binlog router to Created: 2019-07-04  Updated: 2023-05-08  Resolved: 2020-11-24

Status: Closed
Project: MariaDB MaxScale
Component/s: binlogrouter
Affects Version/s: None
Fix Version/s: N/A

Type: Task Priority: Critical
Reporter: Richard Stracke Assignee: Johan Wikman
Resolution: Won't Do Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-20119 Implement the --do-domain-ids, --igno... Closed
relates to MXS-2581 Support DO_DOMAIN_IDS and IGNORE_DOMA... Closed
relates to MDEV-4989 Support for GTID in mysqlbinlog Closed
Epic Link: Pinloki Project

 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=


 Comments   
Comment by Johan Wikman [ 2020-11-24 ]

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.

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