Re: your advice on backup procedure

[Bent Terp <bent@xxxxxxx>]

On Sat, Mar 24, 2012 at 2:28 AM, Steven Crothers
<steven.crothers@xxxxxxxxx>wrote:

> 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
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos