Question

Managed Database Disaster Recovery

Posted October 25, 2020 525 views
BackupsDigitalOcean Managed MySQL DatabaseNeeds Product Answer

Hi,

I know that DigitalOcean Guarantee to restore data to any point within the previous seven days.
It will be great if I got more explanation about the following questions:

  • Do you guarantee no data loss ? for example, we restored database to 5 minutes before What’s the data state will be ?
  • How I can get my data in case of disaster recovery, do you have immediate support ?
  • If we backup the database every 5 minutes does this effect The database somehow ?

We are using managed MySql database for Production.

Regards

edited by bobbyiliev

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.

×
Submit an Answer
1 answer

Hi @hamzahamayel,

* Do you guarantee no data loss ? for example, we restored the database to 5 minutes before What’s the data state will be?

If you require data 5 mins before, with help of the Point in time (PIT) option you can restore the entire cluster to 5 mins before data;

If in case you have deleted some data around 11:58 am and you would like to recover that data; you can perform a PIT to restore the entire cluster 5 mins before which will be 11:53 am to recover the deleted data.

Also, note to restore your database, you can restore to any transaction, as far back as 7 days. This will not restore standbys or read-only nodes of the cluster. The restore point can be from the latest transaction or a specific point in time.

The following article provides more information on how to fork a database cluster and how to restore from backup :

https://www.digitalocean.com/docs/databases/mysql/how-to/fork-clusters/

https://www.digitalocean.com/docs/databases/mysql/how-to/restore-from-backups/

* How I can get my data in case of disaster recovery, do you have immediate support ?

All DO managed database clusters have automated failover, meaning they automatically detect and replace degraded or failing nodes.

In other for the failover to happen, The database cluster will have primary and standby nodes. The standby nodes maintain a copy of the primary node. In the event of a failure,

The standby node is immediately promoted to primary and begins serving requests while a replacement standby node is provisioned in the background.

For more information on high availability:

https://www.digitalocean.com/docs/databases/#high-availability

You can add standby nodes during cluster creation as well as to an existing database cluster.

The below link has information on how to add a standby node :

https://docs.digitalocean.com/products/databases/mysql/how-to/add-standby-nodes/

* If we back up the database every 5 minutes does this affect The database somehow?

Running manual database backup every 5 mins from your end might overload the system, If you require manual backups to be taken; I will suggest you plan your manual backup when there is less traffic.

https://www.digitalocean.com/docs/databases/mysql/how-to/import-databases/

I hope this helps!

Regards,
Rajkishore