Re: [CentOS] your advice on backup procedure

On Sat, Mar 24, 2012 at 2:28 AM, Steven Crothers steven.crothers@gmail.comwrote:

Snapshot the lvm and rsync it to your house. Then wipe out the snap. Seems easiest. Though it won't be the best for things like running databases.

How about you lock all tables and flush buffers, then do the snapshot, and release the lock. Now backup then snapshot and remove it. Shouldn't take more than a few seconds for the lock-snapshot-release part, and you avoid the problem of inconsistent data in your db.

In other places, I've seen people do master-slave replication and using mysqldump on the slave (cuz mysqldump locks tables as well)

BR Bent