[google-cloud-sql-discuss] Re: Cloud SQL Zero downtime Maintenance

Hi, We have used an Active-Passive configuration of Cloud SQL postgres. In a sense it means that I have 2 Cloud SQL master in the same region. One is primary which is responsible for the entire application. It has some read replicas. But during maintenance of master 1 and read replicas, I have a HAProxy to switch to a backup server. Our data is high read/less write scenario for which the data syncing to the master 2 can be done with export from master 1 and import into backup master 2. Once the maintenance is over, HAProxy switches it back to master 1. So practically I have zero downtime. There are other partner solutions Google can offer so you can get in touch with your Technical Account Manager.

On Monday, October 28, 2019 at 3:23:43 PM UTC+1, chen levi wrote:

Hi

looks like there is nothing we can do in order to enforce Zero downtime for our GCP Cloud SQL during maintenance window.

from what i've read seems like even adding Failover replicas will not help here as the replicas will have the same maintenance window, meaning they will both get down during maintenance.

also i assume read replicas also wont help here as read replicas are not ment for failover, although they have a different maintenance window (which can be anytime).

am i missing something?

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/1ecc7a3c-ed58-44e3-afa7-954c12e21ada%40googlegroups.com.