[OSM-dev] MySQL backup
Andreas Brauchli
linux at elementarea.net
Mon Jan 15 16:30:11 GMT 2007
i don't know if this is still an issue on osm but today i stumbled over
this while reading freshmeat:
http://freshmeat.net/projects/mylvmbackup/?branch_id=65575&release_id=245089
mylvmbackup is a Perl script for quickly creating backups of a MySQL
server's data files. To perform a backup, mylvmbackup obtains a read lock
on all tables and flushes all server caches to disk, makes an LVM snapshot
of the volume containing the MySQL data directory, and unlocks the tables
again. The snapshot process takes only a small amount of time. When it is
done, the server can continue normal operations while the actual file
backup proceeds.
could that be a viable option for backup and weekly-dump?
you could then start the weekly dump from the backup from another box.
andreas
More information about the dev
mailing list