List:General Discussion« Previous MessageNext Message »
From:<andrew.2.moore Date:April 20 2010 9:08am
Subject:RE: better way to backup 50 Gig db?
View as plain text  
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

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