Hello, I set up a bi-directional binary replication with mysql. It is very nice: some tables go one direction, some in the other direction. Everything over a ssh tunnel (stunnel). But: It seems that the slave thread is "pausing", without reason. "SHOW SLAVE STATUS" shows normal: no error, slave is running. But it is still behind the master. I changed connect-retry to 5 sec and I monitored the connection. Everything looks normal. The server is not very loaded. The only solution is to do "SLAVE STOP; SLAVE START". After that, in one second they are in sync. For the moment I set a cron job to do this. But I really don't like it. Can anyone tell me something about it? Thanks, Gabriel Corneanu --------------------------------------------------------------------- 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
