Information Schema WSREP_MEMBERSHIP Table
MariaDB 10.1.2
The WSREP_MEMBERSHIP
table was introduced with the WSREP_INFO plugin in MariaDB 10.1.2.
The WSREP_STATUS
table makes Galera node cluster membership information available through the Information Schema. The same information can be returned using the SHOW WSREP_MEMBERSHIP
statement. Only users with the SUPER
can access information from this table.
Example
SELECT * FROM information_schema.WSREP_MEMBERSHIP; +-------+--------------------------------------+-------+-----------------+ | INDEX | UUID | NAME | ADDRESS | +-------+--------------------------------------+-------+-----------------+ | 0 | 46da96e3-6e9e-11e4-95a2-f609aa5444b3 | node1 | 10.0.2.15:16000 | | 1 | 5f6bc72a-6e9e-11e4-84ed-57ec6780a3d3 | node2 | 10.0.2.15:16001 | | 2 | 7473fd75-6e9e-11e4-91de-0b541ad91bd0 | node3 | 10.0.2.15:16002 | +-------+--------------------------------------+-------+-----------------+
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.