MySQL Forums
Forum List  »  Replication

Re: Replication down after disabling / enabling network card adapter
Posted by: Rick James
Date: April 12, 2014 05:29PM

I'm confused... The title says "Replication down"; the text says "MySQL replication is still working".

I would expect MySQL to recover from the temporary network outage. However, there are a few parameters that control how frequently and how often it will retry before giving up totally.

No "CHANGE MASTER" is needed in a normal situation of a network failure/recovery. If fact, CHANGE MASTER is likely to lead to a messed up replication.

Do SHOW MASTER STATUS and SHOW SLAVE STATUS on each machine after it fails.

Options: ReplyQuote




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.