On Thu, 26 Jan 2012 22:28:43 -0500, Phil Stracchino wrote: > Possibly *slightly* off-topic: > > Those using MySQL for their catalog DB (well, actually, any of you > using > MySQL, but that includes Bacula catalogs) may find this interesting: > > http://www.mydumper.org/ > > It is a mysqldump replacement created by a couple of former MySQL AB > support engineers. It is multithreaded, does parallel dumps, can be > told to ignore specified storage engines, has a daemon mode in which > it > does periodic incremental dumps, and automatically generates > consistent > dumps from both transactional and non-transactional storage engines > without the multiple (about 12) options required to achieve the same > ends with mysqldump. It stores schema and data in separate files, > and > supports both file and DB-connection compression. > > In short, it's what mysqldump SHOULD have become by now, but hasn't.
Hello, 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 ! 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) HTH. Jérôme Blion ------------------------------------------------------------------------------ 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