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.
No comments:
Post a Comment