Do you backup your databases offsite?
I'm trying to figure out if offsite backups are worth it and how I would even go about it.
Absolutely! Always do this. I recall the story of a startup with Fortune 500 clients who lost all their data after DigitalOcean banned them.
I use Dokku which allows me to set up a database backup cron. It points to an S3 bucket (in my case, a private DO Spaces instance) where nightly backups are taken of Makerlog's data.
Always do backups. They save butts!
You can take db dumps more frequently if you want, depends on your usecase and how critical it is. If it's critical - AWS Aurora has a replication service, you can replicate the db from anywhere, and they have point in time restores. The only problem it's quite pricey.
But 1 backup a day is still better than 0 :)
depends on the data
we store our customers, invoices, company data once as a normal backup (weekly) in a fireproof safe and additionally once a month on another hard disk which is even located in another house.
online backups are stored on a backup system and on the system itself
my working station and the working station of every employee has a backup hard drive
ask yourself:
- how much depends on when your backup is destroyed. be it hardware failure, fire blight or the like.
- how much time does it take to recover the data if you have no backups
For example i dont backup my image download folder :D
dump the database then use restic to backup to backblaze b2 With regards to actually doing the backups, for mysql i wrote this: https://github.com/digitalsparky/mysql-tools and for postgresql i wrote this: https://github.com/digitalsparky/pgsql-tools
Hope that helps :)
Please sign in to leave a comment.