Book Image

Mastering MariaDB

By : Federico Razzoli
Book Image

Mastering MariaDB

By: Federico Razzoli

Overview of this book

Table of Contents (19 chapters)
Mastering MariaDB
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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

Generic cluster settings

The following list shows us what the generic cluster settings stand for:

  • wsrep_provider: This is the path of the wsrep library.

  • wsrep_cluster_address: This is the address of one or more cluster nodes. As explained...