Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

What's the current status of your Vertica cluster?

Jim Knicely authored this tip.

You can use the GET_CLUSTER_STATE_SUMMARY function to get a quick view of 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!

Sign In or Register to comment.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.