Single Primary Setup¶
Length: 81 words; Published: June 24, 2015; Updated: October 22, 2019; Category: Topology; Type: Best Practices
If a cluster uses only one node as a primary, there are certain requirements (for example, the replica queue size) that can be relaxed.
Recommendations
To relax flow control, you might use the settings below:
wsrep_provider_options = "gcs.fc_limit = 256;
gcs.fc_factor = 0.99;
gcs.fc_master_slave = YES"
By reducing the rate of flow control events, these settings may improve replication performance.
Note
You can also use this setting as sub-optimal in a multi-primary setup.