From: Date: September 12 2005 2:30pm
Subject: RE: LVM-snapshot + mysqldump -- is this a reasonable backup
 strategy?
List-Archive: http://lists.mysql.com/mysql/188996
Message-Id: <3432461.1126528235376.JavaMail.oss@volga.spikesource.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

> This recipe is intended to minimize the impact on ongoing database
> operations by inhibiting writes only during a relatively speedy
> operation (creating a snapshot). The long dump operation can ...

This seems to be a rather long winded way of doing this.  Why not 
replicate the database and therefore not have to bring it down ever.

I wrote a blog entry about this very thing, and had some interesting 
comments back on

  http://blog.spikesource.com/mysql_hotbackup.htm

Hope this helps,

alan

-- 
 Alan Williamson, Technology Evangelist
 SpikeSource Inc.
 Daily OS News @ http://compiledby.spikesource.com/