Write-Set Caching during State Transfers¶
Length: 156 words; Published: June 24, 2015; Updated: October 22, 2019; Category: Performance; Type: Best Practices
Under normal operations, nodes do not consume much more memory than the regular standalone MySQL database server. The certification index and uncommitted write-sets do cause some additional usage, but in typical applications this is not usually noticeable. Write-set caching during state transfers is the exception.
Scenario
When a node receives a state transfer, it cannot process or apply incoming write-sets as it does not yet have a state to apply them to. Depending on the state transfer method, (mysqldump, for instance), the sending node may also be unable to apply write-sets.
Recommendations
The Write-set Cache, (or GCache), caches write-sets on memory-mapped files to disk and Galera Cluster allocates these files as needed. In other words, the only limit for the cache is the available disk space. Writing to disk in turn reduces memory consumption.
Note
See Also: For more information on configuring write-set caching to improve performance, see Configuring Flow Control.
Related Documents
