By fmussoni
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?
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!
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
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.