Not the answer you need?
Register and ask your own question!

Does LVM Snapshot Backup Technique Really Work?

geekprophetgeekprophet ContributorInactive User Role Beginner
I'll be honest. I backup some of my Percona Server 5.6.28 + XtraDB databases as follows:

-- flush tables with read lock
-- flush logs
-- take LVM snapshot of whole mysql folder tree
-- release locks
-- rsync the snapshot to another server

If we need to recover from a disaster, we simply rsync the whole folder back over from the most recent backup.(We also use rdiff-backup to maintain incremental backups over time.)

Is this a reliable way to do backups? Obviously this technique will only allow full databases to be restored, not individual tables. Other than that, are there potential downfalls?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.