GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

replication has "selective hearing"

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • replication has "selective hearing"

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

    Comment


    • #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

      Comment


      • #4
        Good thing that it wasn't anything worse! )

        Comment


        • #5
          yes, thankfully!
          The funny thing is, replication was working *perfectly* the whole time!

          Comment

          Working...
          X