List:General Discussion« Previous MessageNext Message »
From:Gavin Towey Date:April 20 2010 11:26pm
Subject:RE: better way to backup 50 Gig db?
View as plain text  
You can make binary backups from the master using filesystem snapshots.  You only need to
hold a global read lock for a split second.

Regards,
Gavin Towey

From: Claudio Nanni [mailto:claudio.nanni@stripped]
Sent: Tuesday, April 20, 2010 1:19 PM
To: Gavin Towey
Cc: andrew.2.moore@stripped; lists@stripped; mysql@stripped
Subject: Re: better way to backup 50 Gig db?

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<mailto: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>
[mailto:andrew.2.moore@stripped<mailto:andrew.2.moore@stripped>]
Sent: Tuesday, April 20, 2010 2:08 AM
To: lists@stripped<mailto:lists@stripped>
Cc: mysql@stripped<mailto: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<mailto:lists@stripped>]
Sent: 20 April 2010 09:06
Cc: mysql@stripped<mailto: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

________________________________
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

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