On 08/22/10 12:40, Phil Stracchino wrote: > > I'd actually planned at one point to use the bpipe-fd plugin for my > Catalog backup, but I haven't gotten around to setting it up yet because > I made a discovery of something called mysql-snapback. It's a Python > tool that knows how to create snapshots on a couple of different > filesystems, including ZFS, and understands how to FULLY quiesce InnoDB > tables.
Actually, minor correction there; I mentally conflated it with something else. mysql_snapback is specific to ZFS. The tool is here: http://blogs.digitar.com/jjww/2008/01/snapback-the-joys-of-backing-up-mysql-with-zfs/ The page takes a little figuring out, because I think at some point someone inadvertently replaced all the instances of MyISAM with InnoDB, so you have to figure out which is meant at different points. The capsule summary: - mysqldump works with all tables, but is extremely slow, and may be unusably slow on a production database; - ibbackup (InnoBase Hot Backup) is great for backing up InnoDB tables, but is slow on MyISAM tables and is licensed per-server; - filesystem snapshots are screaming fast, typically only a few seconds regardless of database size, BUT the tool has to know how to properly quiesce InnoDB tables to ensure a consistent snapshot. This latter problem is the one mysql_snapback solves. I'm going to try it out on my system, and will report on it. -- Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355 [email protected] [email protected] [email protected] Renaissance Man, Unix ronin, Perl hacker, Free Stater It's not the years, it's the mileage. ------------------------------------------------------------------------------ This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev _______________________________________________ Bacula-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-devel
