Bizarre replication delays
I am running two MySQL servers (5.0.92-community-log). One (host name gw8) is in a SingleHop data center, the other (host name db1) is an Amazon EC2 instance. They are configured for circular replication - gw8 is master to db1, db1 is master to gw8. Both hosts use MyISAM.
They have been running flawlessly for about 3 months. This last Friday we started noticing weird errors in our application, and investigation showed that we were having replication issues. When I insert a row on db1, it immediately shows up on gw8. When I insert a row on gw8 it takes anywhere from 5 minutes to 8 hours to show up on db1.
When I "show full processlist" on both hosts I don't see any queries running for inordinately long times. The slow-query log shows just the normal assortment of occasional non-indexed SELECTs.
Neither machine is showing unusual CPU loading, neither is showing signs of network issues. I can "mysql -h gw8" from db1 with no noticeable delay, and can "mysql -h db1" from gw8 with no noticeable delay.
Suggestions on where I should be looking?
Subject
Views
Written By
Posted
Bizarre replication delays
1942
December 06, 2011 05:03PM
1102
December 07, 2011 04:00PM
901
December 07, 2011 11:30PM
918
December 08, 2011 08:49AM
779
December 08, 2011 01:32PM
619
December 08, 2011 02:06PM
779
December 09, 2011 12:22PM
861
December 09, 2011 12:24PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.