[MXS-4842] Avoid selecting servers with excessive replication lag as master Created: 2023-10-30  Updated: 2024-01-30

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

Type: New Feature Priority: Major
Reporter: markus makela Assignee: Joe Cotellese
Resolution: Unresolved Votes: 0
Labels: None


 Description   

In a two node setup with one master and one slave, if the slave starts to severely lag behind the master in terms of GTID (not seconds_behind_master), the monitor should not promote the slave if the last known GTID coordinate of the master is ahead by some configurable amount.

An alternative approach to this would be to avoid failing over if the monitor is able to detect that transactions would be lost in the failover process. To allow for some amount of losses to happen, the number of transactions that are "an acceptable loss" should be configurable. For example, losing a handful of transactions might be a manually recoverable situation but losing thousands of transactions is not.


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