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 start" command on the slave machine.
Our DB's don't have a firewall or anything between them. Does anyone know if this is a known "bug" in 3.23.41 that is fixed in later versions? 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: Martin 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 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]
