MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

Re: Slave didn't resume after machine sleep
Posted by: Rick James
Date: November 11, 2014 05:33PM

A Slave will try repeatedly to reconnect to the Master. There are a couple of settings that say how often to try and how many tries before giving up. It sounds like it got to the "I give up" point. You can change those settings to suit your "network".

MASTER_CONNECT_RETRY in
http://dev.mysql.com/doc/refman/5.6/en/change-master-to.html

and
http://dev.mysql.com/doc/refman/5.6/en/replication-options-slave.html#sysvar_slave_net_timeout

It should not hurt to set the timeout low and the retry high for your situation.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Slave didn't resume after machine sleep
1472
Chadwick Hung
November 10, 2014 07:33PM
Re: Slave didn't resume after machine sleep
948
Rick James
November 11, 2014 05:33PM
Re: Slave didn't resume after machine sleep
859
Chadwick Hung
November 13, 2014 06:52PM


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.