Hi, We're replicating databases across a firewall with a 300 second reflective ACL timeout set.
This causes occasional problems with replication, where if the master is idle for more than 300 seconds, the connections are closed by the firewall in such a way that the slaves never notice. That is, "show slave status" reports that the slave is running when in fact it has stalled. I see that in the manual there is a slave_read_timeout option which looks like it might fix this problem ( if I upgrade my servers) - but I'm not sure I'm reading the document properly. Is it the case that if slave_read_timeout is set to 150 seconds, and if the connection goes quiet for 150 seconds, then the slave will close and reopen the connection ? (Which is what I want) regards, Martin --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
