On 01/27/2012 04:05 AM, Jérôme Blion wrote:
> For huge databases, a dump is really too slow to restore. mylvmbackup 
> can take a consistent snapshot of the database.
> The backup is a bit longer, the backup file is bigger, restore is much 
> faster !

Snapshot backups are definitely the way to go if you have that option.
(It's the method I actually use.)

> Anyway, I use mydumper for small databases. I used to use 
> mk-parallell-dump until it began to generate OOM errors.
> (maatkit team does not recommend mk-paralle-dump for production use)

Truth to tell, I'm not sure I could in good conscience recommend any of
the maatkit tools for production work.  Too many of them too often don't
work or produce useless results.


-- 
  Phil Stracchino, CDK#2     DoD#299792458     ICBM: 43.5607, -71.355
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT org
  Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
                 It's not the years, it's the mileage.

------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users