Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » replication has "selective hearing"
replication has "selective hearing" [message #2066] Mon, 15 October 2007 14:35 Go to next message
gnujerk is currently offline gnujerk
Messages: 3
Registered: October 2007
Location: cleveland, ohio
Junior Member
seeing a very odd problem which has become very tough to diagnose.
I have a 1-master-many-slave setup where the master is running mysql 4.1 and slaves are on mysql 5.0.

some (not all) records which are updated or inserted on the master aren't replicating down. The problem is that this only happens with certain records, almost at random.

I am prepared to disclose any information you may need pertaining to configs, etc.

wondering if this has happened to anyone else.

Thanks,

Nick
Report message to a moderator
Re: replication has "selective hearing" [message #2069 is a reply to message #2066 ] Tue, 16 October 2007 09:45 Go to previous messageGo to next message
sterin is currently offline sterin
Messages: 324
Registered: March 2007
Location: Sweden
Senior Member
gnujerk wrote on Mon, 15 October 2007 20:35


some (not all) records which are updated or inserted on the master aren't replicating down. The problem is that this only happens with certain records, almost at random.


Do you have any example of which queries that doesn't get replicated?
Report message to a moderator
Re: replication has "selective hearing" [message #2071 is a reply to message #2069 ] Tue, 16 October 2007 11:00 Go to previous messageGo to next message
gnujerk is currently offline gnujerk
Messages: 3
Registered: October 2007
Location: cleveland, ohio
Junior Member
sterin,

Thank you so much for your concern, i really appreciate it.

The problem was strictly pebcak. It hit me like a ton of bricks. I was using a deadly combination of replicate-* rules. I just rebuilt the slaves and corrected the replicate-* entries and everything is back to normal!

Again, thank you for your concern

Nick
Report message to a moderator
Re: replication has "selective hearing" [message #2072 is a reply to message #2066 ] Tue, 16 October 2007 12:19 Go to previous messageGo to next message
sterin is currently offline sterin
Messages: 324
Registered: March 2007
Location: Sweden
Senior Member
Good thing that it wasn't anything worse! Smile
Report message to a moderator
Re: replication has "selective hearing" [message #2074 is a reply to message #2072 ] Tue, 16 October 2007 13:53 Go to previous message
gnujerk is currently offline gnujerk
Messages: 3
Registered: October 2007
Location: cleveland, ohio
Junior Member
yes, thankfully!
The funny thing is, replication was working *perfectly* the whole time!
Report message to a moderator
Previous Topic:120million records - scaling up/out advice?
Next Topic:Design Very large database(15 TeraByte)
Goto Forum:
  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 10 07:03:01 EDT 2009

Total time taken to generate the page: 0.03095 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.