Hello Roshan,
According to this document “ To minimize performance impact on the master, while ensuring that changes are never lost, the replica logs the update events, and then performs the updates in order.” Therefore, I highly doubt that there is specific task that runs every 4- 5 minutes to keep both instances synced, but rather in seconds per order of each operation . You may verify that by checking the replication lag metrics (seconds behind master).
As for stopping/pausing the failover replica, it is not currently possible. As you mentioned, you would have to delete it, and this would render your master not to be configured with high availability. If you choose to recreate the replica, you may check this guide for quick configurations. I hope this helps
Hello Roshan,
The InnoDB page cleaner log message does not seem to be impacting performance, and per the explanation at this Stackoverflow link, it is due to high rate of changes to the database, and innodB should gradually catch up.
That said, I would like to know how you are measuring the performance of your instance. Is it a Google Cloud metric? You may also privately send me a redacted screenshots of it, along with your project ID for a quick inspection (if you like).
As for the replication process, I will check with the Cloud SQL team for best practices, but meanwhile you may check these documents [1] [2].
That said, I would like to know how you are measuring the performance of your instance. Is it a Google Cloud metric? You may also privately send me a redacted screenshots of it, along with your project ID for a quick inspection (if you like).
--
You received this message because you are subscribed to a topic in the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-cloud-sql-discuss/f2WslJAdbmc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-cloud-sql-discuss+unsub...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/09949f74-44b7-404e-822c-6ae269e22038%40googlegroups.com.
That said, I would like to know how you are measuring the performance of your instance. Is it a Google Cloud metric? You may also privately send me a redacted screenshots of it, along with your project ID for a quick inspection (if you like).
Hello Roshan,
You can send me a private message by clicking the drop down next to the reply button ( top- right corner of this message), and then clicking on (Reply privately to author). A better explanation is available at this support article. In this case, I will be the only person checking this message as I would receive it in my email inbox. Hence, no one else would be able to help if I am out of office.
Alternatively, you may create a report at issue tracker with this private component ( Public Trackers > Cloud Platform > GCP Private Issues) (click this link), referencing this thread, and we will be glad to help. This is a preferred method as it is visible to other colleagues, and if I am out of office, another colleague would help.