4 ms·
I created this tool a while ago, but since it's apparently world backup day I thought it a good time to submit it here. It was created out of the fact that we r
by lloydpick 11y ago
I created this tool a while ago, but since it's apparently world backup day I thought it a good time to submit it here. It was created out of the fact that we run automated backups of our various databases, yet we very rarely attempted a restore. This allows me to know for sure that the backup was created and that it's available, accessible & restorable. You can then if you want to, programmatically test the contents of the database using RSpec, just so that you make sure you aren't backing up the wrong one inside. So now we have the backup rubygem (https://github.com/backup/backup https://github.com/backup/backup) triggering Uphold to fully test the backup after it's finished being made through the API.
- jdhendrickson 11y agoThis is a really cool project, thanks for sharing it. One of the challenges I've faced as part of the movement to a devops workflow/culture is verifying DB backups. This could speed up the process extensively. Cheers man!
- cdubzzz 11y agoVery cool. Ever thought about including default test suites with the tool? E.g. I have multiple nightly backups of Drupal databases and could think of some obvious default tests against the core tables that would be useful for all of them.
- lloydpick 11y agoSure, if you PR some example tests in I can make that happen.
- cdubzzz 11y agoI'll look in to it. I have never used Docker or Ruby but RSpec looks pretty straight forward from a quick scan.
- lloydpick 11y agoEven if you just write the SQL I can translate it into RSpec if it'll save you time.
- code_research 11y agodo you have a tool that does this translation or is the tool your brain? :)
- asmx 11y agoI would love this to be working with 3rd party backup tools such as barman or pgbackman.