InnoDB Cluster - avoid failover to node not in sync
Hello together,
I have been experimenting with Innodb Cluster for the last few days ... I am enthusiastic about the functionality!
But there is one thing that gives me a headache!
Test environment:
InnoDB cluster with 3 servers
single-master setup
Scenario:
- very high load on the master
- both slaves can not apply the relay logs fast enough and have a larger gap
- the master fails and an automatic failover to one of the slaves occurs
The application now accesses the new master, but it is not yet up to date because not all relay logs have been processed yet!
this means the application reads an outdated state of the data! This should not happen under any circumstances!
Is there a way to prevent the automatic failover to a slave that is not yet synchronous with the master?
No matter how long it takes, but the failover may only happen if the slave is synchronous!
thanks
Sebastian
Subject
Views
Written By
Posted
InnoDB Cluster - avoid failover to node not in sync
910
September 14, 2018 04:56AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.