search

ACCESS-NRI / experiment-metadb

Prototype metadata database and associated exploratory tools and web interfaces
https://experiment-metadb-seven.vercel.app
Apache License 2.0
0 stars 0 forks source link

Database backups #9

Open aidanheerdegen opened 8 months ago

aidanheerdegen commented 8 months ago

Any DBs on NECTAR need to be backed up.

An ideal back-up strategy might be something like weekly snapshots, with daily incremental back-ups between. With 4 weeks of snapshots retained, older ones deleted but keeping one snapshot per month?

Could probably delete snapshots older than 6 months, or just keep one every 6 months for the "oh no, didn't notice this corrupt part of the DB until now" scenario.

Those timings are just an example. It could be monthly snapshots with daily incremental backups, and keeping the last six months of snapshots, and one per six month period.

Is this even possible? Are there better options?

aidanheerdegen commented 1 month ago

FYI @tmcadam This is the issue I made a while ago about the DB backups.