> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/plugins/mariadb-replication-cluster-plugins/wsrep_provider.md).

# 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](https://mariadb.com/docs/galera-cluster/). It splits up the `wsrep_provider_options` setting into individual configuration variables.

{% hint style="info" %}
The plugin is available from MariaDB 11.0, and built in to the server, but not enabled by default.
{% endhint %}

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

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

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

```ini
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](/docs/server/server-management/install-and-upgrade-mariadb/configuring-mariadb/configuring-mariadb-with-option-files.md):

```ini
plugin-wsrep-provider=ON
```

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

## Changing Provider Options at Runtime

When the plugin is enabled, `wsrep_provider_options` can no longer be changed while the server is running. A `SET GLOBAL wsrep_provider_options=...` statement fails, even for options that are dynamic. Set the individual system variable for the option instead. Its name is `wsrep_provider_` followed by the option name, with dots replaced by underscores. For example, to bootstrap a new Primary Component:

```sql
-- Fails when the plugin is enabled:
SET GLOBAL wsrep_provider_options='pc.bootstrap=YES';

-- Use this instead:
SET GLOBAL wsrep_provider_pc_bootstrap=ON;
```

The failing statement returns this error from MariaDB 11.4.13, 11.8.9, 12.3.3, and 13.0.2:

```
ERROR 1210 (HY000): wsrep_provider_options cannot be changed while the wsrep-provider plugin is loaded
```

Earlier releases report the variable as read-only instead:

```
ERROR 1238 (HY000): Variable 'wsrep_provider_options' is a read only variable
```

The same applies to every other dynamic option. For example, set `wsrep_provider_pc_weight` instead of `pc.weight` in `wsrep_provider_options`.

See the [wsrep\_provider\_options](/docs/galera-cluster/reference/wsrep-variable-details/wsrep_provider_options.md) page for what you can configure for Galera Cluster.

For plugin version and maturity level, see [this page](/docs/server/reference/plugins/list-of-plugins.md).

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>