MySQL Forums
Forum List  »  MySQL & Kubernetes

Re: Mysql operator multi-primary
Posted by: Frederic Descamps
Date: May 10, 2022 01:07AM


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:

Best regards,

Options: ReplyQuote

Written By
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.