MySQL Forums
Forum List  »  Replication

Re: Replication down after disabling / enabling network card adapter
Posted by: Simon Jonhson
Date: April 25, 2014 02:25PM

Hi,

Using the parameter "slave-net-timeout = 30" inside the "my.ini" files seems to work.

So the scenario is the following :

1) Disable the network card adapter on vSphere for the primary server
2) Wait 5 minutes
3) Add 1 record inside the secondary database
4) Wait 5 minutes
4) Enable the network card adapter on vSphere for the primary server

Result : On step 5, the replication is fully working after maximum 30 seconds.

Note :

My issue is solved but I wonder why the parameter is set to 3600 (1 hour) by default? If I didn't change it, it'll take 1 hour for the replication to work again and in a production environment, this is not acceptable.

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.