Mastering MariaDB

Configuring the cluster

MariaDB Galera Cluster nodes can be configured by setting generic MariaDB system variables and Galera-specific variables. The most important variable is wsrep_provider_options; it can be used to set many wsrep parameters, separated by a semicolon. This variable is dynamic.

The most important variables and parameters are explained in this section. A complete list of options and parameters can be found in the MariaDB Knowledge Base.

Explaining the important Galera system variables

All Galera-specific variables have a 'wsrep_' suffix. To list them, we can use the following query:

SHOW VARIABLES LIKE 'wsrep%';

A discussion follows about the most important Galera system variables. They have been split into groups to make the discussion ...