Page MenuHomePhabricator

Make backups of Quarry's main database on quarry-main-01
Open, Needs TriagePublic

Description

There are no redundancy or regularly scheduled backups of database quarry on quarry-main-01. If that instance fails (could be any reason), we lose all of the SQL queries, which would be terrible.

There was past manual backups to /data/project NFS:

zhuyifei1999@quarry-main-01:/data/project$ ls -lh backup* dump* *.sql | uniq
-rw-r--r-- 1 root root  29M Jul 17  2015 backup.sql
-rw-r--r-- 1 root root 108M Aug  3  2016 dump-2016-08-03.sql
-rw-r--r-- 1 root root 128M Sep 23  2016 dump-2016-09-23.sql
-rw-r--r-- 1 root root 224M Sep  6 00:06 dump-2017-09-05.sql
-rw-r--r-- 1 root root  89M May 20  2016 dump.sql

@chasemp said NFS is a bad idea and it's better to use something like rsync to another instance on another labvirt.

Event Timeline

I'm wondering, would it make sense for a separate instance to connect to quarry-main-01 to do the backups to its instance local storage? Or the backup process should be done on quarry-main-01 and rsync-ed to the separate instance?