[lug] mysqldump versus snapshot versus..

[steve at badcheese.com]

>>> 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...

If you change the tabel type to innodb, this locking is not necessary, but 
slower, so you can do it either way depending on the table type.

- Steve

-- 
EMAIL: (h) steve at badcheese.com  WEB: http://badcheese.com/~steve