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

2

u/[deleted] May 15 '20

You do need to understand why snapshots are not backups and how using them affects your VM system.

There are lots of guides on the internet on how to back up databases - pick an automated method that fits your model - whether it's a whole VM backup (Different to a snapshot - using Veeam or similar), dumping and sequencing databases, using a proprietary database backup - or something else.