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
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
