By seany
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:
- 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
- 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
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.