- 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 o
"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"
rtin Waite [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 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 replica
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
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
Slave_R
