Dawnshard's database is backed up nightly to the server it runs on and the cloud. But as the database has grown larger, these backups have too. At present each backup takes up approximately 500MB of space. This means they need to be regularly pruned to prevent the server from running out of space. It's likely that without attendance for a few months the server would run out of space.
We should consider employing one or more of the following strategies:
- continuous archiving: do a full backup at a reduced rate, e.g. once a week, and then each day back up the write-ahead log so that that day's database state can be restored
- automation to clean up old backups
If implementing continuous archiving some system to automatically test backups may be desirable.
Dawnshard's database is backed up nightly to the server it runs on and the cloud. But as the database has grown larger, these backups have too. At present each backup takes up approximately 500MB of space. This means they need to be regularly pruned to prevent the server from running out of space. It's likely that without attendance for a few months the server would run out of space.
We should consider employing one or more of the following strategies:
If implementing continuous archiving some system to automatically test backups may be desirable.