WSREP_INFO Plugin

You are viewing an old version of this article. View the current version here.
MariaDB 10.1.2

The WSREP_INFO plugin was introduced in MariaDB 10.1.2.

Versions

VersionStatusIntroduced
1.0StableMariaDB 10.1.18
1.0GammaMariaDB 10.1.13
1.0AlphaMariaDB 10.1.2

Description

The WSREP_INFO plugin adds two new tables to the Information Schema, WSREP_MEMBERSHIP and WSREP_STATUS. These provide Galera node cluster membership and status information.

To install it, use:

INSTALL SONAME 'wsrep_info';

After installation, the two new tables will have been added to the Information Schema:

SHOW TABLES FROM information_schema LIKE 'WSREP%';
+---------------------------------------+
| Tables_in_information_schema (WSREP%) |
+---------------------------------------+
| WSREP_STATUS                          |
| WSREP_MEMBERSHIP                      |
+---------------------------------------+

These tables can either be queried directly, or the related SHOW statements used instead. See SHOW WSREP_MEMBERSHIP. Only users with the SUPER privilege can access information from these tables.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.