We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


What's the current status of your Vertica cluster? — Vertica Forum

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.