[MXS-4128] Run demotion.sql when a previous master server starts replicating as slave WITHOUT MariaDB Monitor auto "rejoin" Created: 2022-05-10  Updated: 2023-06-09  Resolved: 2023-06-07

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

Type: New Feature Priority: Major
Reporter: Maria M Pflaum Assignee: Esa Korhonen
Resolution: Won't Do Votes: 0
Labels: None

Sprint: MXS-SPRINT-183, MXS-SPRINT-184

 Description   

Trigger demotion.sql if for some reason a down master comes back up and is replicating from the correct server. Right now since the monitor sees everything working correctly it doesn't execute rejoin and hence the demotion.sql is not triggered.

Here is and example of a sequence events where we would want the demotion.sql script to be triggered.

00:18:19 mariadb-0 MasterDown (this was due to networking issues where maxscale could not communicate with the node)
00:18:23 mariadb-1 NewMaster (mariadb-1 node promoted to Master)
00:18:24 mariadb-0 ServerUp (mariadb-0 original [failed] Master is accessible again without rebooting)
00:18:26 mariadb-0 NewSlave (mariadb-0 original [failed] Master rejoins as Slave)



 Comments   
Comment by Esa Korhonen [ 2023-06-07 ]

Reopen if current answer is not sufficient.

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