Re: MySQL 8 Group Replication very slow with inserts
Hi Icaro,
First of all be warned that HA is not automated with only 2 nodes. You will need to decide which site needs to take (or keep) the lead in case of network issue. Quorum won't be reached and the cluster won't take any decision on itself to avoid split-brain.
That said, Are your 500 inserts different statements in auto_commit ? If yes, you should try to put them on a single transaction (watch out the size of that transaction that must not be too big). Because currently 500 x 50 ms it's already 25seconds one way out.
Cheers.
Subject
Views
Written By
Posted
1857
April 09, 2020 09:31AM
Re: MySQL 8 Group Replication very slow with inserts
787
April 09, 2020 11:04AM
828
April 10, 2020 04:52AM
623
April 17, 2020 05:25AM
Sorry, you can't reply to this topic. It has been closed.
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.