replication has "selective hearing"

MySQL & MariaDB Other MySQL® Questions
1

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

2
[B]gnujerk wrote on Mon, 15 October 2007 20:35[/B]

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?
3

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

4

Good thing that it wasn’t anything worse! )

5

yes, thankfully!
The funny thing is, replication was working perfectly the whole time!