MySQL Forums
Forum List  »  Replication

Re: Master and slave get out of sync
Posted by: Rick James
Date: December 17, 2014 11:17AM

I have seen this problem for more than a decade (since 4.0), yet have never identified a cause nor a solution.

Consider writing a cron job that does the STOP+START every 10 minutes.
Consider monitoring replication delay and paging you when the problem occurs.
Consider Galera / PXC instead of traditional replication.

Options: ReplyQuote


Subject
Views
Written By
Posted
1718
December 16, 2014 07:59AM
Re: Master and slave get out of sync
891
December 17, 2014 11:17AM


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.