Thursday, February 13, 2020

[google-cloud-sql-discuss] Cloud SQL HA maintenance

Hi

we've recently enabled HA on our Cloud SQL.
this enables the standby instance along with the primary instance for our DB.

until now during scheduled maintenance windows we've encountered downtime of few minutes.
i know that failover replica (the previous HA solution) did not helped in such cased and im trying to understand if this standby instance also does not help in achieving zero downtime.

i understand per the documentation , that during maintenance for the primary instance, there will be no failover to the standby instance as described here : 

For Cloud SQL to allow a failover, the configuration must meet the following requirements:

- The primary instance must be in a normal operating state (not stopped, undergoing maintenance, or performing a long-running operation).
- The secondary zone and standby instance must both be in a healthy state. When the standby instance is unhealthy and/or replication to the secondary zone is interrupted, failover operations are blocked. After Cloud SQL repairs the standby instance and the secondary zone is available, replication resumes and Cloud SQL allows failover.

the thing is , i still have 2 questions:
- during the primary instance maintenance windows, does the standby instance also being upgraded?
- if its not , does it make sense to initiate manually failover right before the maintenance to the standby instance to prevent downtime?  is it duable?

thanks
Chen

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/cc9f65dc-50f5-45e1-b16d-ec56b480aef9%40googlegroups.com.

No comments:

Post a Comment