Re: Mysql operator multi-primary
Hello,
Using Multi-Primaries doesn't have many benefits, it's even more the reverse.
Allow writes on multiple nodes won't scaled up the writes are this is almost (depending of the consistency level) "synchronous" replication which mean that all writes happening to one member also happen to all the other ones.
So if one server can perform 100 writes max (io capcity), if you write on another node, the max capacity is already reached, and the overhead might even reduce that amount of writes.
The only valid scenario in my opinion is you have small writes that are the result of a long read. Otherwise it doesn't make many sense.
Take a look at this (now old) post:
https://lefred.be/content/mysql-group-replication-single-primary-or-multi-primary/
Best regards,
Subject
Written By
Posted
Re: Mysql operator multi-primary
May 10, 2022 01:07AM
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.