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
