Question

Database configuration change

Posted April 16, 2020 733 views
DigitalOcean Managed MySQL Database

We currently have a MySQL cluster and we need to upgrade it, will we suffer any downtime ? and how long will it take ?
We have the 2 Core 4GB RAM cluster with a standby node.

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
2 answers

Hello,

As there is a standby node, I believe that there should be minimal to no downtime during the upgrade.

Hi,

The standby nodes maintain a copy of the primary node. In the event of a failure or maintenance.
The standby node is immediately promoted to primary and begins serving requests while a replacement standby node is provisioned in the background; so there won’t be any downtime.

For more information on high availability:

https://www.digitalocean.com/docs/databases/#high-availability
https://docs.digitalocean.com/products/databases/mysql/#managed-database-cluster-features

I hope this helps!

Regards,
Rajkishore