Sunday, April 29, 2018

[google-cloud-sql-discuss] Can I drop the failover CloudSQL instance and re-create it?

Hi,

I have a cloud-sql instance setup with a failover. It's noticed that there is a drop in the performance of db queries every 4-5 minutes. It's very regular. There is a feeling that it could be due to some internal operations that need to be done to keep the failover instance in sync.

In order to verify or refute that, I was thinking of dropping the failover instance temporarily and see whether the dip in queries-performance goes away and then bring it back.

Is it a bad idea to do this experiment - other than the fear that for the duration of this experiment, there won't be a failover instance?

My requirement is just to temporarily get rid of the failover instance. If, instead of deleting this failover instance, I can detach it and then re-attach it later, that might be even better. As that may result in less work it'll need to do to bring an up-to-date failover.

Any vies / inputs will be highly appreciated.

Regards,
Roshan

--
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/98ced34f-20e9-4e76-925a-87ad57a095a4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment