On Tue, Apr 20, 2010 at 11:03 AM, Gavin Towey <gto...@ffn.com> wrote: > More good ideas from Andrew! > > Just a note though, I noticed someone added replication to a slave as a > backup option. I really discourage that. Replication makes no guarantees > that the data on your slave is the same as the data on your master. Unless > you're also checking consistency, a slave should be treated as a somewhat > unreliable copy of your data. > > Regards, > Gavin Towey >
I would like to second this sentiment. Once you start looking for data inconsistencies on slaves you will be surprised how often you find them. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org