Set up a backup scheme that preserves copies of db going back further than 3 days

[patudom]

We currently back up the hubbleds database nightly (3:20am ET), and the 3 most recent copies are saved. This doesn't give us a lot of lead time if something catastrophic happens to the db and it takes us > 3 days to notice that there is a problem.

Short-term solution -

• do the easy thing and set up AWS to keep 2 weeks worth of backups since our db size is currently small (~40 MB).
• set up a job that automatically runs ~once a month to dump a copy of the db into an S3 bucket or store it somewhere locally.

In the longer term, let's see if there is a way to keep a staggered length of backups (1 day ago, 2 days ago, 1 week ago, 2 weeks ago, 1 month ago, etc).

[Carifio24]

So I've set up a backup plan using AWS Backup with daily/weekly/monthly backups, with a retention rate for each backup of 2x the interval. This should in theory do what we want, but I'm going to leave this issue open until the backups are actually created and we can verify that everything is working as expected.