List:Replication« Previous MessageNext Message »
From:Johan De Meersman Date:July 15 2013 2:36pm
Subject:Re: 2 slaves - one Master; continues to fail
View as plain text  
----- Original Message -----

> From: "Jamen McGranahan" <jamen.mcgranahan@stripped>
> 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