2011/1/25 Robinson, Eric <eric.robin...@psmnv.com>: >> 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) http://www.pythian.com/news/5113/video-building-a-mysql-slave-and-keeping-it-in-sync/ if you watch the movie, at ~40 minutes, you can see a slide "What causes slave to get out of sync"... Greetings, Mattia. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org