WSREP_INFO Plugin

The WSREP_INFO plugin library contains the following plugins:

• WSREP_MEMBERSHIP

• WSREP_STATUS

The WSREP_MEMBERSHIP plugin creates the WSREP_MEMBERSHIP table in the database. The plugin also adds the statement.

The WSREP_STATUS plugin creates the table in the database. The plugin also adds the statement.

These tables and statements provide information about . Only users with the privilege can access this information.

Installing the Plugin

iAlthough the plugin's shared library is distributed with MariaDB by default, the plugin is not actually installed by MariaDB by default. There are two methods that can be used to install the plugin with MariaDB.

The first method can be used to install the plugin without restarting the server. You can install the plugin dynamically by executing or :

The second method can be used to tell the server to load the plugin when it starts up. The plugin can be installed this way by providing the or the options. This can be specified as a command-line argument to or it can be specified in a relevant server in an :

Uninstalling the Plugin

You can uninstall the plugin dynamically by executing or :

If you installed the plugin by providing the or the options in a relevant server in an , then those options should be removed to prevent the plugin from being loaded the next time the server is restarted.

Example

Options

wsrep_membership

• Description: Controls how the server treats the plugin when the server starts up.

  • Valid values are:

    • OFF - Disables the plugin without removing it from the table.

wsrep_status

• Description: Controls how the server treats the plugin when the server starts up.

  • Valid values are:

    • OFF - Disables the plugin without removing it from the table.

_{This page is licensed: CC BY-SA / Gnu FDL}