mariadb cluster 확인

cluster 상태 확인

show global status like 'wsrep%_comment';
show global status like 'wsrep%_size';

• wsrep_local_state_comment : Synced 확인
• 3노드 클러스터 환경일 경우 wsrep_cluster_size : 3 확인

MariaDB [(none)]> show global status like 'wsrep%_comment';
+---------------------------+--------+
| Variable_name             | Value  |
+---------------------------+--------+
| wsrep_local_state_comment | Synced |
+---------------------------+--------+

MariaDB [(none)]> show global status like 'wsrep%_size';   
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| wsrep_cert_index_size | 198   |
| wsrep_cluster_size    | 3     |
+-----------------------+-------+