Re: better way to backup 50 Gig db?

[Rob Wultsch]

On Tue, Apr 20, 2010 at 11:03 AM, Gavin Towey <gtowey@stripped> 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
wultsch@stripped