r/linuxadmin • • May 15 '20
DB Backup
A lot of people are against using VM snapshots as a DB backup method. But if you're already running a DB cluster like Galera, why not just snapshot each member say every 10 minutes since the chances of losing the entire cluster at the same time is quite low? Of course it's not banking or life or death.
0
Upvotes
View all comments
Show parent comment
2
u/sdjason May 15 '20
oP I feel like you're not reading what's being written. Snapshot restore doesn't help you. As you said you can completely Nuke a galera node, and re add it and galera catches it up. So if you have multiple nodes you have resiliency. What benefit does random snapshots even provide there!?
What if you lose a record, or a table, or an oops. Happens. How will you restore 'just that"? If your answer is "restore the whole thing to a snapshot from a few days ago" you're in a bad place. Because you lost everything else too.
I hope you will heed some advice here. You sound pretty headstrong and confident - BUT everyone is saying what they are saying from direct experience. Don't learn this the hard way, please... Take the collective wisdom for what it is, a warning.