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