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@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users -- Med venlig hilsen / Best Regards Henrik Johansen hen...@scannet.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users