Sunday, April 26, 2020

[google-cloud-sql-discuss] MYSQL Read replica

Hi,
I have an issue with GCP Mysql.
I have one master instance with 1 read replica. sometimes when there is maintenance operation on the server some write queries are routed to the read replica instance and therefore I get the following error: The MySQL server is running with the --read-only option so it cannot execute this statement.
How should I handle this situation?
there is an option to route to replica only read queries? thx

--
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/30476b0d-c09a-416f-9b73-f1688370f55d%40googlegroups.com.

No comments:

Post a Comment