Hi Simon,
I checked the suggested flag on my end on Cloud Console and noticed that it is currently not supported.
As for the replication lag, it happens when the SQL thread on the replica is unable to keep up with the updates it is receiving from the master instance as well as slow queries on slave.
I suggest the following to mitigate the replication lags:
- If the primary is under a considerable read traffic load, increasing instance Tiers size may help.
- Send read traffic to the replica which can help reduce traffic on the master instance.
If You still experience the the Replica lag issue, I'd suggest to create a private Public Issue Tracker, and provide us with additional information such as Project Id and Cloud SQL instance name, and we shall investigate the issue further.
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/631c6b3e-63ac-4a13-b201-5f2f66dddff1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment