List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:April 20 2010 8:19pm
Subject:Re: better way to backup 50 Gig db?
View as plain text  
Where is Falcon!!!! (Sorry)

the only way to have a really consistent binary backup is to shut down the
server.
the best way to shut down a server is to have a slave dedicated to backups
that you can shutdown any time.

if you have only the content of the database folders under [datadir] it is
not enough, you need the full [datadir] to 'dream' to restore
your db, unless you only use MyISAM tables, then you are more lucky.

The bottom line is:  Don't Dream, Prove it. Or it will become a nightmare
sooner or later.


Ciao!

Claudio



2010/4/20 Gavin Towey <gtowey@stripped>

> 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
>
> -----Original Message-----
> From: andrew.2.moore@stripped [mailto:andrew.2.moore@stripped]
> Sent: Tuesday, April 20, 2010 2:08 AM
> To: lists@stripped
> Cc: mysql@stripped
> Subject: RE: better way to backup 50 Gig db?
>
> I would also recommend looking into some 3rd party tools.
>
> http://www.percona.com/docs/wiki/percona-xtrabackup:start - Backup Innodb,
> MyISAM and XtraDB engines.
> http://www.maatkit.org/ - Packed with useful features inc a parallel
> dump/import.
>
> There's some great features in both products. I will leave you to do your
> own research into the tools as knowing their features will benefit you.
>
> Best wishes
>
> Andy
> ________________________________________
> From: ext Jay Ess [lists@stripped]
> Sent: 20 April 2010 09:06
> Cc: mysql@stripped
> Subject: Re: better way to backup 50 Gig db?
>
> Gavin Towey wrote:
> > What Shawn said is important.
> >
> > Better options:
> > 1. Use InnoDB, and then you can make a consistent backup with `mysqldump
> --single-transaction > backup.sql`  and keep your db server actively
> responding to requests at the same time.
> >
> > 2. Use something like LVM to create filesytem snapshots which allow you
> to backup your database, while only keeping a read lock on the db for a
> second or so.
> >
> 3. Set up replication and backup the replicated data using any of the
> above method.
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
> This message contains confidential information and is intended only for the
> individual named.  If you are not the named addressee, you are notified that
> reviewing, disseminating, disclosing, copying or distributing this e-mail is
> strictly prohibited.  Please notify the sender immediately by e-mail if you
> have received this e-mail by mistake and delete this e-mail from your
> system. E-mail transmission cannot be guaranteed to be secure or error-free
> as information could be intercepted, corrupted, lost, destroyed, arrive late
> or incomplete, or contain viruses. The sender therefore does not accept
> liability for any loss or damage caused by viruses or errors or omissions in
> the contents of this message, which arise as a result of e-mail
> transmission. [FriendFinder Networks, Inc., 220 Humbolt court, Sunnyvale, CA
> 94089, USA, FriendFinder.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Claudio

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