Re: Replication down after disabling / enabling network card adapter

[Simon Jonhson]

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,