Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list... Question Question
Private connection to Managed DB not working from within same region droplet. Question Question

Question

Managed database standby nodes in different datacenter

Posted November 23, 2020 473 views
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.

Add a comment
arturczapiewskiremi
By:
arturczapiewskiremi

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list... Question Question
Private connection to Managed DB not working from within same region droplet. Question Question

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
priyankamalik May 22, 2021

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

Reply Report

Related

Looking for something else?

Ask a new question Search for more help