Comments - Cluster Overall Memory Requirements (compared to multiple stand-alone nodes)

9 years, 3 months ago Daniel Black

galera doesn't use that much more memory. Its got an apply queue which in theory can be up to gcs.fc_limit ( wsrep_provider_options) entries of up to wsrep_max_ws_size size. If you're not doing large and multiple row updates (row based replication) updates hitting this limit will be hard.

wsrep_thread_count are full connection threads and in theory can consume about the same as real connection threads however as they are processing row based events some of the usual connection based buffers will never be used.

There are some other memory allocations but they are quite minor.

Unless you doing some massive updates where the hardware on the receiving node is significantly less than the update node, I wouldn't consider Galera usage to be any more than 1-2G (very conservative estimate with increased gcs.fc_limit at 1K).

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.