Question

Hourly Database Backup Plan

Correct me if i am wrong, but am i right in saying that Digital Ocean only backup your database once a week?

Can anyone suggest a good way to automate a daily or hourly backup… to email, dropbox or some other storage… thank you.


Submit an answer

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!

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

@mosaic

IIRC, there’s not a definite set schedule for backups. When I lasted used them, the backups spanned across a mix of daily and every other day. Without being able to define a schedule, the backups are honestly a last resort until a more fine-tuned and granular option is available.

That said, MySQL backups are finicky and should be treated as such if you value the data. Ideally, you don’t want to backup in the midst of writes being performed as this can result in incomplete data, and that can pose a security risk depending on what data was written and what wasn’t.

As an example, let’s say that a new user is registering. Registration means that data is being written, so if you shutdown and in the process only the username gets written but not the password, and your application / code does not account for this, that user (unless your code accounts for it and prevents it) could technically login with just their username. Not a big deal when it comes to a service that just provides a profile or similar, though if you were selling something (i.e. a service), chances are good that they just got in for free.

How large is the backup and how large is it expected to get over the next few weeks, months etc? If you’re looking for a short-term solution, AutoMySQLBackup works well:

http://sourceforge.net/projects/automysqlbackup/

For critical data, and to prevent the above mishaps from occurring, you’d want to look in to something that would ensure all current writes are complete, shutdown MySQL, perform the backup, and restart.