summaryrefslogtreecommitdiff
path: root/How to show the mysql galera cluster status.md
blob: d29dcc3355cde8d0ec0f01e7e064d1b26dd33d2d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
---
tags:
  - mysql
  - galera
  - howto
---
[[MySQL]]
[[GroupVPS Platform]]


Can be queried using `SHOW STATUS`.

`sudo mysql --exec "SHOW STATUS LIKE 'wsrep%'"`

**wsrep_cluster_status:**
- Primary; desired state. Primary component (so the cluster is one big component). Quorum of nodes is present.
- Non-Primary; Part of a partition (the non primary one) of nodes, so the cluster is partitioned. Cluster lost quorum.
- Disconnected: The node is not connected to the cluster at all.