[google-cloud-sql-discuss] High Availability Configuration and Connection Patterns

I need to better understand the high availability setup for Cloud SQL with PostGreSQL and MySQL and had the following questions:

1. Given that a failover replica can be treated as a read replica when the Master is up and running, how reliable is the failover instance? I am referring to this: https://cloud.google.com/sql/docs/postgres/replication/tips#read-replica

2. As I understand from https://groups.google.com/forum/#!msg/google-cloud-sql-discuss/WwfY_CwFbVU/IKfo7Rn_BwAJ, when Cloud SQL DB fails over, the master is brought up in the failover zone and the failover instance is moved to another zone.

But what happens if the failover replica goes down (before the master)?

3. Lets say we have a bunch of read replicas in this HA setup. Are read replicas still in sync after the master fails?

4.What are the differences between MySQL and PostGreSQL for the above?

5. This is question is unrelated to the HA setup. Can we connect from a private cluster to Cloud SQL using 

a) Cloud proxy b) Authorized IP

   - Followup question: How about from a centralized VM hosted cloud proxy client?

Ref: 

https://cloudplatform.googleblog.com/2017/11/Cloud-SQL-for-PostgreSQL-adds-high-availability-and-replication.html

https://cloud.google.com/sql/docs/mysql/high-availability

https://cloud.google.com/sql/docs/postgres/replication/tips#read-replica

--
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/fb86b224-61a6-4509-8e05-c08dcd24b6c8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.