2011/1/25 Robinson, Eric <eric.robinson@stripped>:
>> your whole solution is crippled because why in the world are
>> you killing your salves and reinit them without any reason daily?
> There is a very good reason: it is the phenomenon of row drift. The
> master and slave can appear to be in good sync, but often it is not
> actually the case.
... sounds interesting; have you got any document explaining
this phenomenon? AFAIK, the things that (silently) break replication are:
- non-deterministic functions in statement-based replication
- hand-made updates on the slave db
is this enough to justify a *daily* resync?!
However, this could be a solution for your problem (maybe)
if you watch the movie, at ~40 minutes, you can see a slide
"What causes slave to get out of sync"...