Question

Managed database and backups

Hi,

We are a happy user of the DO Managed Database offering. Nevertheless, backup are still not 100% clear for me. I understand you make WAL backups every 5 mins or so and a full backup every 24 hours. So get that you can do PIT restores, etc.

But, what happens if something “catastrophic” happens to the underlying cluster my database is running on? In other words what’s the worst that can happen to my database if WE ourselves are not causing the database to be destroyed/corrupted/made unavailable. In that case would I still have a backup to restore. Or would I need to have standby nodes active for that database?

Is there any recommendation to have a separate backup process back up my database to an external cloud provider for example? (I guess this is always a good practice, but want to be able to make a proper assessment of the urgency for this).

Thanks!


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.

Hi @HappyBlueGreenKelp

Daily backups are available with our managed database service at this time. We maintain 7 days worth of backups for each database cluster.

To ensure data safety we use offsite backups for database cluster(s). Since the service is managed, we handle all backup operations on our end. Since the database is managed completely by us, we’ll re-try the backup multiple times. If things continue to fail we’ll investigate directly with our engineering team; meanwhile the database should continue to perform as expected. All of this activity would be invisible on your end. Any additional issues would be considered a larger bug where communication directly to you would follow.

Regards Priyanka