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 (e.g., 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.