[google-cloud-sql-discuss] Re: Is there a way to get the details of a Google Cloud SQL failover replica instance?

Prior to November 2019, Cloud SQL for MySQL failover instances were configured manually and details for those instances were accessible. Since then, enabling the High Availability feature now enables Regional Persistent Disks which synchronously replicate data at the block-level between two zones in a region. As such, the failover replica is not visible and metrics cannot be accessed for it. This is also the configuration for PosgreSQL instances.

It is possible to set an instance to High Availability using the legacy configuration by following this method [1], which will render the failover instance visible but doesn't take advantage of the benefits of the Regional Persistent Disks (virtually non-existent replication lag among others). Please note that this legacy configuration will only be available until April 2020, as mentioned here [2].

[1] https://cloud.google.com/sql/docs/mysql/configure-ha#ha-existing-legacy
[2] https://cloud.google.com/sql/docs/mysql/high-availability#legacy_mysql_high_availability_option

On Monday, December 30, 2019 at 10:58:57 AM UTC-5, Gerome Ren wrote:

I know I can use gcloud sql instances describe or the Cloud SQL REST API to get the details of a Cloud SQL instance, and that I can also get the secondary zone after failover is done (e.g. gceZone).

After enabling the High Availability (regional) feature for a Cloud SQL instance, is there a way to get the details of Cloud SQL failover replica instance?

Thanks for the help!

--
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/d4f6260e-bdb8-4c4e-ad4a-9d352b3163a4%40googlegroups.com.