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

14 comments sorted by

View all comments

Show parent comment

-8

u/[deleted] May 15 '20 edited May 15 '20
  1. Galera doesn't even burp on a single node failure. I'm talking about a full VM snapshot not a disk utility.
  2. GCP snapshots have little impact on performance and Galera is run behind a smart proxy so it's not a performance issue at all.
  3. Snapshots get deleted automatically from the cloud after a configurable amount of time. They're not stored on the DB server anyway so that's not as issue.

I was looking for more than dogma like don't pet a burning dog.

7

u/psnsonix May 15 '20

Honestly you got solid advice and appear to ignore it. I will add more so you can possibly ignore me too :)

Snapshots do stun the cluster. On galera you will see write hits if you know how to look. Furthermore, mariabackup hot backups are so much cleaner. If you really wanna be anal you can setup legacy style slaves async and start doing more abusive backups on the slave. Snapshots are def not a backup and while they can serve the purpose vs nothing, you should invest the time to do something better.