Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Backup coding system databases #2153

Closed
lucyb opened this issue Nov 19, 2024 · 1 comment
Closed

Backup coding system databases #2153

lucyb opened this issue Nov 19, 2024 · 1 comment

Comments

@lucyb
Copy link
Contributor

lucyb commented Nov 19, 2024

As far as I'm aware, we don't currently back up our coding system databases directly. If we lost these, they might be time consuming and tricky to restore. However, we do back up the Droplet, so we can restore the droplet and get a copy of the databases that way (see #2128).

We have one database per coding system release and generally consider them to be immutable. In total they take up 38G (at the time of writing) and will get larger over time.

We only have 155GB of disk space on dokku3 and are currently using half of it. So, it's probably not a good idea to backup the databases to the same machine. We should consider backing them up to Digital Ocean Spaces Object Storage and also storing the downloaded files there.

We should manage the backups in a similar way to #2151, by using a cron job. However, since the databases aren't written to we should be able to copy the files directly rather than use the sqlite cli.

Acceptance criteria

  • Backup all coding system databases to Digital Ocean Spaces or other filesystem.
  • Check that a local restore (NOT production) works as expected.
  • Document the changes in an ADR.
@lucyb
Copy link
Contributor Author

lucyb commented Dec 11, 2024

I'm closing this as I believe it will be made redundant by #2225 and a move over to Digital Ocean Block Storage.

@lucyb lucyb closed this as completed Dec 11, 2024
@lucyb lucyb closed this as not planned Won't fix, can't repro, duplicate, stale Dec 11, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants