MySQL Forums
Forum List  »  Replication

Re: Group Replication - how to find queries causing replication lag?
Posted by: Frederic Descamps
Date: March 03, 2021 04:20PM

Hi Aurélien,

There is no accurate answer to give you in this situation.
Some more details are needed:
- Are you using Single Primary ?
- Are you using the default EVENTUAL consistency ?
- What is the latency between nodes ?
- Does reducing the amount of members help ?
- How big is that number of trx ?
- Are you using parallel appliers ?
- Which version of MySQL ?

You could also take a look at this plugin: https://github.com/lefred/mysqlshell-plugins/wiki/innodb_cluster#showgroupreplicationspeed that could help you identify the problem.

Cheers,

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Group Replication - how to find queries causing replication lag?
132
March 03, 2021 04:20PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.