List:General Discussion« Previous MessageNext Message »
From:Rob Wultsch Date:April 20 2010 8:20pm
Subject:Re: better way to backup 50 Gig db?
View as plain text  
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
Thread
better way to backup 50 Gig db?Mitchell Maltenfort19 Apr
  • Re: better way to backup 50 Gig db?Shawn Green20 Apr
    • RE: better way to backup 50 Gig db?Gavin Towey20 Apr
      • Re: better way to backup 50 Gig db?Jay Ess20 Apr
        • RE: better way to backup 50 Gig db?andrew.2.moore20 Apr
          • RE: better way to backup 50 Gig db?Gavin Towey20 Apr
            • Re: better way to backup 50 Gig db?Rob Wultsch20 Apr
            • Re: better way to backup 50 Gig db?Claudio Nanni20 Apr
              • RE: better way to backup 50 Gig db?Gavin Towey21 Apr
Re: better way to backup 50 Gig db?Claudio Nanni21 Apr
  • Re: better way to backup 50 Gig db?Johan De Meersman21 Apr
    • Re: better way to backup 50 Gig db?Claudio Nanni21 Apr
      • Re: better way to backup 50 Gig db?Johan De Meersman21 Apr
        • Re: better way to backup 50 Gig db?Claudio Nanni21 Apr
      • RE: better way to backup 50 Gig db?Gavin Towey21 Apr
  • RE: better way to backup 50 Gig db?Jerry Schwartz21 Apr
Re: better way to backup 50 Gig db?Claudio Nanni21 Apr