Backup Central

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.


--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
alaric < at > caerllewys.net alaric < at > metrocast.net phil < at > 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 < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

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 < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

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.net alaric < at > metrocast.net phil < at > 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 < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users