|
The output of show WSREP_STATUS differs from select information_schema.WSREP_STATUS
note :there is not difference regarding the other WSREP_INFO table WSREP_MEMBERSHIP ; both commands 'show WSREP_INFO' and
'select * from information_schema.WSREP_INFO ' return one and the same
install WSREP_INFO plugin on Galera Nodes
MariaDB [foo]> SHOW TABLES FROM information_schema LIKE 'WSREP%';
|
Empty set (0.000 sec)
|
|
MariaDB [foo]> INSTALL SONAME 'wsrep_info';
|
Query OK, 0 rows affected (0.034 sec)
|
|
MariaDB [foo]> SHOW TABLES FROM information_schema LIKE 'WSREP%';
|
+---------------------------------------+
|
| Tables_in_information_schema (WSREP%) |
|
+---------------------------------------+
|
| WSREP_STATUS |
|
| WSREP_MEMBERSHIP |
|
+---------------------------------------+
|
2 rows in set (0.000 sec)
|
|
MariaDB [(none)]> select * from information_schema.WSREP_STATUS \G
|
*************************** 1. row ***************************
|
NODE_INDEX: 1
|
NODE_STATUS: Synced
|
CLUSTER_STATUS: Primary
|
CLUSTER_SIZE: 2
|
CLUSTER_STATE_UUID: 3c15149f-5766-11e8-9a99-22bc53d40581
|
CLUSTER_STATE_SEQNO: 26977
|
CLUSTER_CONF_ID: 37
|
GAP: NO
|
PROTOCOL_VERSION: 3
|
1 row in set (0.000 sec)
|
|
MariaDB [foo]> SHOW WSREP_STATUS \G
|
*************************** 1. row ***************************
|
Node_Index: 0
|
Node_Status: Synced
|
Cluster_Status: Primary
|
Cluster_Size: 2
|
1 row in set (0.000 sec)
|
|
MariaDB [(none)]> SHOW GRANTS ;
|
+----------------------------------------------------------------------------------------------------------------------------------------+
|
| Grants for root@localhost |
|
+----------------------------------------------------------------------------------------------------------------------------------------+
|
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*E6CC90B878B948C35E92B003C792C46C58C4AF40' WITH GRANT OPTION |
|
| GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION |
|
+----------------------------------------------------------------------------------------------------------------------------------------+
|
2 rows in set (0.000 sec)
|
|
|