diff options
| author | Jasper Ras <jaspert.ras@gmail.com> | 2025-04-18 21:01:49 +0200 |
|---|---|---|
| committer | Jasper Ras <jaspert.ras@gmail.com> | 2025-04-18 21:01:49 +0200 |
| commit | a8a8e1f984f20c8008f3a5f57cd39b416eb73104 (patch) | |
| tree | 2262794b52d82c5fd9cbc55b503b52fafbd3af8a /How to show the mysql galera cluster status.md | |
| parent | 5fa69499917fab7a026c90c8321dbcc22734106a (diff) | |
| parent | ab409a3701bf59dd73dc1e0324376bdac8b6d74f (diff) | |
vault backup: 2025-04-18 21:01:49
Diffstat (limited to 'How to show the mysql galera cluster status.md')
| -rw-r--r-- | How to show the mysql galera cluster status.md | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/How to show the mysql galera cluster status.md b/How to show the mysql galera cluster status.md new file mode 100644 index 0000000..27bb50f --- /dev/null +++ b/How to show the mysql galera cluster status.md @@ -0,0 +1,14 @@ +--- +tags: + - mysql + - galera + - howto +--- +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.
\ No newline at end of file |