Let’s suppose I create a database cluster with a standard configuration, like 1 primary node and 1 stand-by node in AMS3.
What’s happen if there are some networking issue that impacting multiple services in AMS3 region? Or if some servers goes offline?

how the standby nodes (and Automated failover) works?

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 @fmussoni,

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
https://docs.digitalocean.com/products/databases/mysql/#plans-and-pricing

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/

I hope this helps!

Regards,
Rajkishore