[lug] mysqldump versus snapshot versus..

[George Sexton]

dio2002 at indra.com wrote:
>> I think that if you use LVM snapshots, you'll also have to lock the tables
>> before and unlock after the snapshot, but it may be so fast, that
>> locking/unlocking may not be an issue for you.
> 
> you nailed it.  LVM DOES require table lock on mysql backup.  the benefit
> is that it apparently is a lot faster which only keeps your prod db down
> for a very short time.

How primitive. PostgreSQL doesn't block read/update when the pg_dump 
command runs. I know SQL server doesn't either. Yet another case where 
the MySQL designers mindlessly chose speed over correctness...



-- 
George Sexton
MH Software, Inc.
Voice: +1 303 438 9585
URL:   http://www.mhsoftware.com/