Sample Header Ad - 728x90

What to do in times of data inconsistency in Master-Master Replication in MySQL?

0 votes
2 answers
1126 views
I am building an architechture consisting MySQL Master-Master replication with HAProxy in its front. For HAProxy i am using round_robin algorithm to distribute loads between two masters. My question is when there is a heavy write situation as Seconds_Behind_Master will be greater than 0, what should I do for the data inconsistency will arise when HAProxy will go divert to an unupdated Master?
Asked by dragon (95 rep)
Mar 29, 2017, 07:07 AM
Last activity: May 15, 2019, 05:01 AM