← All tools

Galera Health Check

Paste SHOW STATUS LIKE 'wsrep%' output and read the cluster's verdict.

Why this exists

The daily health check on a Galera cluster is one query and nine variables — quorum, sync state, flow control. Paste the raw mysql output and get the verdict with the exact next command per finding, plus the MaxScale commands for the proxy's view of the same cluster.

🔒 Runs in your browser — nothing is sent anywhere
9 variables parsed
  • OKwsrep_cluster_status = Primary — this node is in the quorum component.
  • OKwsrep_local_state_comment = Synced — fully caught up and serving.
  • OKwsrep_cluster_size = 3 — odd member count, clean quorum.
  • OKFlow control near zero — no node is holding the cluster back.
★ The commands — Galera and the MaxScale in front of it
  • SHOW GLOBAL STATUS LIKE 'wsrep%';Full wsrep status (paste its output above)
  • SHOW GLOBAL STATUS WHERE Variable_name IN ('wsrep_cluster_status','wsrep_ready','wsrep_local_state_comment','wsrep_cluster_size','wsrep_flow_control_paused');The five that matter, in one query
  • cat /var/lib/mysql/grastate.datLast known seqno when the cluster is down
  • galera_new_clusterBootstrap the most-advanced node (only after checking every node's seqno)
  • maxctrl list serversMaxScale: server states as the proxy sees them
  • maxctrl show server <name>MaxScale: why a server is not being routed to
  • maxctrl show monitorsMaxScale: monitor diagnostics