Summary of Cluster State

[Deleted User] · April 2018

Jim Knicely authored this tip.

The GET_CLUSTER_STATE_SUMMARY function can be used to quickly view the current status of your Vertica cluster.

Example:

All nodes are up:

dbadmin=> SELECT get_cluster_state_summary();
                                        get_cluster_state_summary
----------------------------------------------------------------------------------------------------------
Cluster State: test2
UP: 4 of 4 (v_test2_node0001, v_test2_node0002, v_test2_node0003, v_test2_node0004)
(1 row)

One node is down:

dbadmin=> \! admintools -t kill_node -s v_test2_node0004
   Terminating vertica and performing host cleanup 
        Terminating vertica processes on host '192.168.2.203'
All signals sent successfully.

dbadmin=> SELECT get_cluster_state_summary();
                                                 get_cluster_state_summary
---------------------------------------------------------------------------------------------------------------------------
Cluster State: test2
UNKNOWN: 1 of 4 (v_test2_node0004)
UP: 3 of 4 (v_test2_node0001, v_test2_node0002, v_test2_node0003)
(1 row)

Have fun!