Sync of Master Master replication when Primary node comes up MySQL 5.7 Enterprise
1
vote
1
answer
514
views
I have a Master (say Node A) - Master (Say Node B) ***asynchronous replication*** setup with ***ROW based logging method***.
Node A has been setup as Write/Read node and Node B has been setup as Read Node Only.
From JBOSS , i am doing switch over that , when A node goes down , all the Write operation will get forward to B node and whenever Node A comes up , JBOSS will forward all the Writes to A node.
Now suppose Node A remains down for long time , then all the Writes will go to B node . When A node comes up , it will remain un-sync for a while till it get complete sync with B . While it is getting sync , write operation is also happening on Node A which might result in locking issues as well.
So my question is :
Is there any method in MySQL that when Node A comes up , it will not be accessible by outer application ( like JBOSS , i have mentioned) till it gets complete sync with Node B .
Can we control it via MySQL_Safe mode so that other application can perceive Node A as still down or is there any other method
Asked by simplifiedDB
(679 rep)
Apr 10, 2017, 06:02 AM
Last activity: Apr 6, 2025, 07:06 PM
Last activity: Apr 6, 2025, 07:06 PM