Power up with new SaaS Add-Ons from the DigitalOcean Marketplace

Question

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

  • Posted October 12, 2014

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

Subscribe
Share
Zachary DuBois • October 12, 2014

This comment has been deleted

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Zachary DuBois • October 12, 2014

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.

Woet • October 12, 2014

Yes.