On 02/11/10 01:08 PM, Dan Langille wrote:
> JanJaap Scholing wrote:
>> Thanks for all the input.
>>
>> I think a lvm snapshot is the best way to go for us.
>
> Be aware of the potential risks of backing up a database at the file
> system level. What you may be backing up is a database in an
> inconsistent state (e.g. part way through a transaction).  When you use
> mysqldump, you do not encounter this situation.

Normally, you would quiesce/lock your tables, take a snapshot and unlock 
which would give you consistent backups of your DB.

Using snapshots is just much, much faster when dealing with large tables 
/ databases and can be just as safe as using mysqldump.

As an example, the backup of a ~200GB InnoDB database using ZFS 
snapshots is done in ~3 seconds.

>
> ------------------------------------------------------------------------------
> SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
> Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
> http://p.sf.net/sfu/solaris-dev2dev
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users


-- 
Med venlig hilsen / Best Regards

Henrik Johansen
henrik AT scannet DOT dk
Tlf. 75 53 35 00

ScanNet Group
A/S ScanNet

------------------------------------------------------------------------------
SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
http://p.sf.net/sfu/solaris-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users