Re: Mysql operator multi-primary

[Frederic Descamps]

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,