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:
Any comment and suggestion on this?
Thanks, Sean
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.
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.
Yes.
This comment has been deleted