Hi Jeff,
We had similar problems caused by replication crossing a
firewall with a 5 minute timeout on its access control list.
If the replication stream went idle for 5 minutes, the firewall
would drop the connection and MySQL wouldn't notice.
Our workaround was to run a daemon on the master to
4:37 AM
To: Jeff McKeon
Cc: MySQL List
Subject: RE: Replication stops for no reason...
Hi Jeff,
We had similar problems caused by replication crossing a
firewall with a 5 minute timeout on its access control list.
If the replication stream went idle for 5 minutes, the firewall would
drop
Jeff McKeon [EMAIL PROTECTED] wrote:
I've seen one other reference to this exact situation but it didn't have
a resolution. What I've done is created a script that runs every 10
minutes via cron and checks a value from both databases and if it's not
equal then it issues a slave stop and slave
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 7:58 PM
Subject: Re: Replication stops for no reason...
Jeff McKeon [EMAIL PROTECTED] wrote:
I've seen one other reference to this exact situation but it didn't have
UPDATED INFO
mysql show slave status \G;
*** 1. row ***
Master_Host: 10.32.1.10
Master_User: repli
Master_Port: 3306
Connect_retry: 60
Log_File: db01tc0927-bin.034
Pos: 468335571