Galera cluster performance, node count, and where to write?
0
votes
1
answer
683
views
As far I understand Galera does not scale **write** performance, best case it does not degrade it, compared to one single server, so we use Galera for **HA**.
(read performance may benefit and it can be load balanced across every nodes)
In Galera the **write** performance will be the performance of the weakest node.
In light of that, who wants to got more HA than 3-4 nodes can provide? If one or two nodes fail the **write** performance will not degrade, even it is possible it increasing... so it seems to over guard HA with more than 4 nodes. (I am aware the WAN use case and multiple datacenters, but that case we have two or mode Galera clusters)
It is not clear for me, if given a particular write transaction, is there any significant load difference on node that actually the client use to write, compared to the load on all other nodes, who also needs to complete synchronously the very same transaction?
I try to decide, that should I have a dedicated node to write (btw it is single point of error, so I should use some infra to react), and only use the others to read, or try to load balance the writes also across all nodes?
How many nodes are optimal? Is it depends on my application read load/write load ratio?
Asked by g.pickardou
(187 rep)
Jan 21, 2023, 07:46 PM
Last activity: Jan 27, 2023, 07:08 AM
Last activity: Jan 27, 2023, 07:08 AM