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
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users