节点从集群中移除的状态
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 |