O'Reilly logo

Mastering MariaDB by Federico Razzoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required