On 10/25/11 11:03, Jérôme Blion wrote: > With mylvmbackup, you can backup any type of engine which writes on > disk (don't expect to recover memory table...) as long as you flush > buffers to disk.
Yup. The issue is that should you get something NOT completely flushed, InnoDB has built in error recovery; MyISAM does not. > I performed some tests with a 150 GB database (mostly InnoDB + MyISAM). > > mysqldump : to be coherent, we needed to stop the service during 15 > minutes > mylvmbackup : the service was blocked during 3-5 seconds. Indeed. The improvement in available uptime is huge. (To be fair, if using all-InnoDB, you can use mysqldump --single-transaction to avoid locking any tables and still get a consistent dump. However, that doesn't speed mysqldump up any...) -- 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. ------------------------------------------------------------------------------ The demand for IT networking professionals continues to grow, and the demand for specialized networking skills is growing even more rapidly. Take a complimentary Learning@Cisco Self-Assessment and learn about Cisco certifications, training, and career opportunities. http://p.sf.net/sfu/cisco-dev2dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users