The Ultimate Guide to High Availability with MariaDB

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.

The WSREP_INFO plugin adds two new tables to the Information Schema, WSREP_MEMBERSHIP and WSREP_STATUS.

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.

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.