Is there a way to get the details of a Google Cloud SQL failover replica instance?

[Gerome Ren]

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!

[Pierre-Yves Blain]

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