my29_PXC集群状态查看

节点从集群中移除的状态

show status like '%wsrep%';
wsrep_cluster_status为Disconnected则表示该节点已经不在集群中了，示例如下

> show status like '%wsrep%';
+--------------------------+----------------------+
| Variable_name            | Value                |
+--------------------------+----------------------+
| wsrep_cluster_conf_id    | 18446744073709551615 |
| wsrep_cluster_size       | 0                    |
| wsrep_cluster_state_uuid |                      |
| wsrep_cluster_status     | Disconnected         |
| wsrep_connected          | OFF                  |
| wsrep_local_bf_aborts    | 0                    |
| wsrep_local_index        | 18446744073709551615 |
| wsrep_provider_name      |                      |
| wsrep_provider_vendor    |                      |
| wsrep_provider_version   |                      |
| wsrep_ready              | ON                   |
+--------------------------+----------------------+
11 rows in set (0.00 sec)

正常的集群节点状态

>show status like '%wsrep%';
+----------------------------------+-----------------------------------------------------+
| Variable_name                    | Value                                               |
+----------------------------------+-----------------------------------------------------+
| wsrep_local_state_uuid           | 5a290219-fcfc-11e8-b8b9-13c62e5c16f1                |
| wsrep_protocol_version           | 8                                                   |
| wsrep_last_applied               | 6611991575                                          |
| wsrep_last_committed             |