Stale slave becomes master if no master or slave is available - Source

Revision: 85772
User: Bartosz Piasecki
Date: 2019-06-04 14:24

Hello,

I have configured MaxScale to monitor and perform automatic failover (or rejoin) on cluster of 3 MariaDB servers. Automatic failover is working most of the time except one scenario:

Let servers be M1, M2, M3. M1 is initial master; M2 and M3 are slaves of M1. Replication is GTID-based with `gtid_strict_mode` enabled.
<<code>>
> turn off M1
> M1 becomes down
> M2 becomes master due to automatic failover
> execute some writes to database
> M3 replicated successfully
> turn off M2 and M3 (MaxScale stays ON)
> turn on M1
<</code>>
The problem is that M1 becomes master node when no other database is accessible, even though previous master (M2) has higher GTID value. This makes me assume that MaxScale does not "remember" previous GTID value to tell stale slave (M1) that it has stale data in comparison to newer master (M2).

Is there any option to prevent slave with stale data becoming master node? Problem exists ONLY if no other nodes are available.

I would be grateful for any kind of help.

Best regards,

Bartosz

Answer

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

Stale slave becomes master if no master or slave is available - Source

Answer

Products

Services

Pricing

Resources

About Us

Download MariaDB