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 replace a row in a special table once per minute - hence keeping the connection open. I think there are some timeout settings in newer MySQL versions which get the slave to reconnect after a period of inactivity. regards, Martin On Mon, 2003-07-07 at 19:20, Jeff McKeon wrote: > 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_Running: Yes > Replicate_do_db: > Replicate_ignore_db: > Last_errno: 0 > Last_error: > Skip_counter: 0 > 1 row in set (0.00 sec) > > ERROR: > No query specified > > mysql> > > > > Jeff McKeon > IT Manager > Telaurus Communications LLC > [EMAIL PROTECTED] > (973) 889-8990 ex 209 > > ***The information contained in this communication is confidential. It > is intended only for the sole use of the recipient named above and may > be legally privileged. If the reader of this message is not the intended > recipient, you are hereby notified that any dissemination, distribution > or copying of this communication, or any of its contents or attachments, > is expressly prohibited. If you have received this communication in > error, please re-send it to the sender and delete the original message, > and any copy of it, from your computer system. Thank You.*** > > > > -----Original Message----- > From: Jeff McKeon > Sent: Monday, July 07, 2003 1:47 PM > To: Mysql List > Subject: Replication stops for no reason... > > > mysql Ver 11.15 Distrib 3.23.41, for pc-linux-gnu (i686) > > I have the following replication setup... > > DB1 --> DB2 --> DB3 > > Every often, replication from DB1 to DB2 just stops. There is no error > messages that I can see. I know it's stopped because I have a check > that runs every 5 minutes to see a certain piece of data in DB1 matches > DB3. > If I issue slave stop and then slave start commnands, it's then fine for > another day or so... > > Any idea how I can track down the cause or where a log may be for this? > > Thanks, > > Jeff > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
