We use mysqldump and logrotate to keep a week of DB dumps on the local
filesystem, we perform daily backups to a VTL and then tape, and we also
perform nightly SAN snapshots on the RT host's LUN (making sure to lock
the databases before the snapshot, and then unlocking after so the MySQL
DB files are in a consistent state during the snap).
Wow, you have a complicated system. I was considering backing up the
whole machine with LVM snapshots, but I don't think I have the space
overall to deal with full machine snapshots.
If I ever ended up doing LVM snaps, do I need to lock the db first...
or can I get away with not locking the db with LVM snaps?
You use logrotate to manage your mysqldumps! Excellent idea.
I need to learn logrotate. I was wondering how I can keep mysqldumps
from each day and not lose control of them. I'm excited.
Thank you for your response. (I need to google VTL)
-Andy
