wsrep_provider

The wsrep_provider plugin exposes Galera Cluster provider options as individual system variables, allowing for easier configuration and validation of cluster settings.

This plugin is for Galera Cluster. It splits up the wsrep_provider_options setting into individual configuration variables.

The plugin is available from MariaDB 11.4, and built in to the server, but not enabled by default.

Without that plugin, options are grouped together, like this:

wsrep_provider_options="base_dir = /var/lib/mysql/; base_host = node-1;..."

With this plugin loaded, you can configure individual variables, like this:

wsrep_provider_base_dir  = /var/lib/mysql/
wsrep_provider_base_host = node-1
...

This makes managing provider options easier, and helps avoid the problem of wsrep_provider_options exceeding the maximum length of 2048 characters for an individual variable.

To enable the plugin, add the following line to the [mariadbd], [server], or [galera] sections of your server option file:

plugin-wsrep-provider=ON

Alternatively, start the server with the --plugin-wsrep-provider option.

See the wsrep_provider_options page for what you can configure for Galera Cluster.

For plugin version and maturity level, see this page.