Re: [google-cloud-sql-discuss] Re: Cloud SQL failovers and read replicas

Thanks both for taking the time to post, but yes I know that read replicas don't provide failover capability. I guess I'll do some more testing and will update if anything relevant comes up.

On Wednesday, September 27, 2017 at 2:08:23 PM UTC-6, Vadim Berezniker wrote:

If I understand correctly, Miguel is asking about what happens to read replicas after a failover.

Read replicas are re-created using the new master.

On Tue, Sep 26, 2017 at 6:20 PM 'Kenworth (Google Cloud Platform)' via Google Cloud SQL discuss <google-cloud...@googlegroups.cYepdfdfdfdfdfom> wrote:

Does anybody have an idea if the read replica attaches to the "new" master automatically in case of a failover?

No, they do not attach to the new master because read replicas do not provide failover capability as you noted. They are used to offload read requests or analytics traffic from the master, not as a failover. You can test this by following these steps:

1- Create a MySQL instance

2- Create a Read replica on #1

3- Run 'gcloud beta sql instances failover <your_master_replica_name>' 

The simulated failover (#3) will return a 400: Requested operation requires a failover replica, as expected.

--
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/197fa20c-1e3e-4af5-ba61-cd7553b0dfcc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/95058343-763b-469a-807c-fd0201f918e8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.