On 12/4/09 3:14 PM, "Gavin Towey" <gto...@ffn.com> wrote: > I would say that it's very important to know why data is getting out of sync > between your master and slave. Fixing those root causes would eliminate the > need for this.
i very much agree. the only instances of slaves getting out of whack that i've experienced was when i screwed something up administratively. > There are cases where non-deterministic queries will produce > different results, but that's what row based replication is supposed to solve > =) 16.3.1 lists some interesting cases to consider: http://dev.mysql.com/doc/refman/5.0/en/replication-features.html > There are ways to resync data that don't involve all this as well: Maatkit > has some tools that compare data between servers, and can fix them with > queries. No stopping the slave or locking the master necessary. I've used > them in production with good results. thanks for the pointer. looks handy. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
