Thanks for this message. I’m assuming the percona tool needs to be installed on the MASTER host? Is that correct?
Systems Services Librarian
Vanderbilt University Library
From: Johan De Meersman [mailto:vegivamp@stripped]
Sent: Monday, July 15, 2013 9:36 AM
To: McGranahan, Jamen
Subject: Re: 2 slaves - one Master; continues to fail
From: "Jamen McGranahan" <jamen.mcgranahan@stripped<mailto:email@example.com>>
Subject: RE: 2 slaves - one Master; continues to fail
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.