Question
Managed database standby nodes in different datacenter
- Posted November 23, 2020
- DigitalOcean Managed MySQL Database
Do you allow standby nodes to work in different datacenters? If not. What is your solution for datacenter failover? If I have servers in 2 different datacenters for failover and managed database is in only one of them my failover won’t work.
Subscribe
Share
Submit an 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 to AnswerThese 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.
Try DigitalOcean for free
Click below to sign up and get $100 of credit to try our products over 60 days!
Hi @arturczapiewskiremi
Standby nodes is only supported for the same region now. We’ve never had a total outage in any of our data centers before, but we have a contingency plan for a situation like that.
We perform two full backups daily. As well, we backup the WAL every 5 minutes. These backups are hosted in a separate datacenter. In the event of a datacenter failure, you will have the option to recreate your database cluster in another data center of your choice using your backup with the risk of losing at most 5 min of data.
Regards Priyanka