[MXS-4819] Failover for async replication between 2 galera cluster Created: 2023-10-19  Updated: 2024-02-02

Status: Open
Project: MariaDB MaxScale
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: New Feature Priority: Major
Reporter: Richard Stracke Assignee: Joe Cotellese
Resolution: Unresolved Votes: 0
Labels: failover_issues, galera, replication

Issue Links:
Relates
relates to MDEV-20720 Galera: Replicate MariaDB GTID to oth... Closed
relates to MXS-2123 Please add support for hybrid galera ... Closed
relates to MXS-2885 Group slaves with failover Closed

 Description   

Since original GTID will be forwarded to all nodes (MDEV-20720),
such feature should be possible.

Given a setup like
https://mariadb.com/kb/en/configuring-mariadb-replication-between-two-mariadb-galera-clusters/

Also this setup with additional async replciation between the nodes.

A workaround is to establish a maxscale readconnrouter between both galera cluster,
with router_options=master, but this will only affect an outage of the master node, not slave node.

So feature request here is a mechanism, that Maxscale check async replication between both galera cluster and switch slave and master node in case of a failure
and take into account, that binlog position can be different and can determine the correct GTID.


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