seany
By:
seany

Should I do my own database backup in addition to the DO's automatic backup?

October 12, 2014 1.6k views

I run a small LAMP stack application, and I would like periodically back-up my database in case the physical machines hosting my droplet goes down.

If I enabled the automatic backup provided by DO, should I run my own daily backup utilities in addition to that? My current thinking is like this:
1) even I run my own backup utilities (e.g., mysqldump etc), I probably run it nightly every 24 hours, so I have not seen the additional benefit than relying on the daily automatic backup offered by DO
2) on the other hand, I heard ppl saying 'you must run your own backup to avoid putting all the eggs into one basket'

Any comment and suggestion on this?

Thanks,
Sean

2 Answers

Yes.

  • Can you elaborate a bit more, after give a simple 'yes'?

    Thanks,

  • Backups you rely on for disaster recovery should always be off-site. Backups offered by the one and the same provider can be useful but you can not rely on them.

    Hypothetical scenarios where you will lose them:

    • Provider gets hacked, vms and backups are wiped
    • Provider goes bankrupt and equipment goes offline
    • Provider suspends your account permanently

Yeah, I'd highly recommend it. Because even with the DigitalOcean live backups, it could catch MariaDB or whatever DB engine mid updating, etc and you would still have a corrupted table/etc from the backup. Running a mysql-dump on a Cronjob should do the trick. Then DigitalOcean will back that up.

Have another answer? Share your knowledge.