Information Schema WSREP_MEMBERSHIP Table
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.
The WSREP_MEMBERSHIP
table is part of the WSREP_INFO plugin.
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 | +-------+--------------------------------------+-------+-----------------+
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.