List:Replication« Previous MessageNext Message »
From:Jamen McGranahan Date:July 15 2013 3:12pm
Subject:RE: 2 slaves - one Master; continues to fail
View as plain text  
Johan –

Thanks for this message. I’m assuming the percona tool needs to be installed on the MASTER host? Is that correct?

Jamen McGranahan
Systems Services Librarian
Vanderbilt University Library

From: Johan De Meersman [mailto:vegivamp@stripped]
Sent: Monday, July 15, 2013 9:36 AM
To: McGranahan, Jamen
Cc: Replication
Subject: Re: 2 slaves - one Master; continues to fail

________________________________
From: "Jamen McGranahan" <jamen.mcgranahan@stripped<mailto:jamen.mcgranahan@vanderbilt.edu>>
Subject: RE: 2 slaves - one Master; continues to fail
Johan,

Looking at the master’s errorlog, all I see is a bunch of “[Note] Start binlog_dump to slave_server(3), pos(mysql-bin.000468, 818014181)” entries (well, 818014181 number changes for each line).

And yes, most of the tables causing me problems are Drupal sites – and usually the log or cache tables.

Oh, how I loathe Drupal, but that's not something I have room to get into here :-)

I'm familiar with such problems, but I've found that it's all too often caused by developers connecting to the wrong server. If you've already set the slaves read-only, though, that shouldn't be the issue - unless there's already more inconsistencies than you think. The Percona Toolkit is your friend, pt-table-checksum will verify data consistency and pt-table-sync will use the black arts to resync without having to dump/import. Read the manpages carefully, though :-)



--
Unhappiness is discouraged and will be corrected with kitten pictures.
Thread
2 slaves - one Master; continues to failJamen McGranahan14 Jul
  • Re: 2 slaves - one Master; continues to failSuresh Kuna14 Jul
    • RE: 2 slaves - one Master; continues to failJamen McGranahan14 Jul
      • Re: 2 slaves - one Master; continues to failSuresh Kuna14 Jul
  • RE: 2 slaves - one Master; continues to failJamen McGranahan15 Jul
    • RE: 2 slaves - one Master; continues to failJohan De Meersman15 Jul
    • Re: 2 slaves - one Master; continues to failTruls Bergskaug15 Jul
  • Re: 2 slaves - one Master; continues to failJesper Wisborg Krogh15 Jul
    • Re: 2 slaves - one Master; continues to failDivesh Kamra16 Jul
Re: 2 slaves - one Master; continues to failJohan De Meersman15 Jul
  • RE: 2 slaves - one Master; continues to failJamen McGranahan15 Jul
    • Re: 2 slaves - one Master; continues to failJohan De Meersman15 Jul
      • Re: 2 slaves - one Master; continues to failSuresh Kuna15 Jul
        • RE: 2 slaves - one Master; continues to failJamen McGranahan15 Jul
          • Re: 2 slaves - one Master; continues to failSuresh Kuna15 Jul
            • RE: 2 slaves - one Master; continues to failJamen McGranahan15 Jul
              • Re: 2 slaves - one Master; continues to failSuresh Kuna15 Jul
Re: 2 slaves - one Master; continues to failJohan De Meersman17 Jul
Re: 2 slaves - one Master; continues to failJohan De Meersman18 Jul
  • RE: 2 slaves - one Master; continues to failJamen McGranahan18 Jul
    • Re: 2 slaves - one Master; continues to failMarcus Bointon18 Jul
      • RE: 2 slaves - one Master; continues to failJamen McGranahan18 Jul
        • Re: 2 slaves - one Master; continues to failSuresh Kuna18 Jul
          • RE: 2 slaves - one Master; continues to failJamen McGranahan18 Jul
        • Re: 2 slaves - one Master; continues to failMarcus Bointon18 Jul
          • RE: 2 slaves - one Master; continues to failJamen McGranahan18 Jul
            • Re: 2 slaves - one Master; continues to failMarcus Bointon18 Jul
              • RE: 2 slaves - one Master; continues to failJamen McGranahan18 Jul
              • RE: 2 slaves - one Master; continues to failJamen McGranahan22 Jul
                • Re: 2 slaves - one Master; continues to failSuresh Kuna22 Jul