Re: MySQL 8 Group Replication very slow with inserts

[Icaro Orte]

Hi Frederic

Thank you for your reply

With this configuration I seek to maintain an infrastructure for a website, in which to have redundancy of data in two different countries, because the company requires it that way. There are also two web servers in each country that access their "master" of the database infrastructure, a load balancer send traffic to both servers. In principle, it is not planned to add another node. What configuration would you recommend me to reach the quorum?

Regarding the script of 500 inserts, it is only a benchmark to test the efficiency of the system, the problem will be when there are 500 concurrent connections that insert data at the same time. Could the master-master structure be maintained, but making the system more efficient? Something like making both servers not have to wait for each other. Or what solution could we adopt?

Thank you, best regards,
Icaro