MySQL Forums
Forum List  »  Replication

Re: Replication down after disabling / enabling network card adapter
Posted by: Simon Jonhson
Date: April 17, 2014 09:33AM

Hi,

It seems the replication is down because there are too much operations to synchronize.

Scenario 1 :

1. Disable the network card adapter through vSpehre on the primary server
2. Wait for 2-3 minutes
3. Add two entries inside the secondary database
4. Enable the network card adapter through vSpehre on the primary server

Result : The replication is still up and the primary database has been synchronized.

Scenario 2 :

1. Disable the network card adapter through vSpehre on the primary server
2. During 2-3 minutes, add an entry every 10 seconds inside the secondary database
4. Enable the network card adapter through vSpehre on the primary server

Result : If I execute the query "SHOW SLAVE STATUS;" on the primary server, "Slave_SQL_Running" is set to "No" (value is set to Yes if I execute this query on the secondary server) -> I got a replication but only in one way. The primary server send correctly his update bot the secondary does not send them.

This is why this issue is solved with the queries of previous post (stop/start slave).

Regards,

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.