On 1/25/2011 8:00 AM, Robinson, Eric wrote:
>> 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. For this reason, most people agree that it is not
> safe to rely on the slave server as the source for your backups. My
> solution efficiently corrects row drift and makes sure the slaves are
> 100% binary replicas of the slaves, which can then be trusted as backup
> sources. The whole thing is very fast and there is no downtime for
> users, who can continue to work 24x7. I fail to see how this is
> "crippled."
Why don't you use a Maatkit solution like mk-checksum to ensure that
your slaves have identical data with the master?
