Understanding cluster status and node states

Quick reference

The cluster status shows two key values that help you understand your cluster's health:

  • cluster_%_status - whether the cluster can accept writes
  • cluster_%_node_state - what this specific node is doing

Status values

‹›
  • SQL
SQL
📋
SHOW STATUS LIKE 'cluster_%_status';
SHOW STATUS LIKE 'cluster_%_node_state';
‹›
Response
+----------------------------+-------+
| Counter                    | Value |
+----------------------------+-------+
| cluster_posts_status       | primary |
| cluster_posts_node_state   | synced |
+----------------------------+-------+

cluster_%_status

  • primary - Normal operation, can read and write
  • non-primary - Lost quorum, writes blocked
  • disconnected - Node isolated, trying to reconnect

cluster_%_node_state

  • synced - Normal operation
  • joining - Node joining cluster (temporary)
  • donor - Helping another node join (temporary)
  • closed - Node stopped
  • destroyed - Node crashed, needs restart

Common scenarios

What happened cluster_%_status cluster_%_node_state What to do
Normal operation primary synced Nothing
Most nodes down non-primary synced Bootstrap or wait
Node starting disconnected joiningsynced Wait
Node crashed varies destroyed Restart node
Network partition (majority) primary synced Continue normally
Network partition (minority) non-primary synced Wait or bootstrap

Recovery from quorum loss

When most nodes are down and status shows non-primary:

‹›
  • SQL
  • JSON
📋
-- Check which node has highest sequence number
SHOW STATUS LIKE 'cluster_%_last_committed';
-- Bootstrap the cluster (run on best node only)
SET CLUSTER posts GLOBAL 'pc.bootstrap' = 1;
‹›
Response
+----------------------------+-------+
| Counter                    | Value |
+----------------------------+-------+
| cluster_posts_last_committed | 1547 |
+----------------------------+-------+
Last modified: September 01, 2026