Can one node at a time be stopped for maintenance in a k-safe multi-node cluster

Products

• CA Performance Management
• Network Observability

Issue/Introduction

Can one node at a time be stopped for maintenance in a k-safe multi-node cluster to facilitate patching for example

Environment

Release: All supported releases

Resolution

You can stop a single node in a cluster.

As always, it is *HIGHLY* advisable to have a good backup of each Performance Management component before stopping the nodes.

 

1) To stop a single node:

a) Log in to any node as the dradmin and launch the adminTools UI.

b) Select Option 7 for the Advanced Menu. Select Option 2 to Stop Vertica on Host.

 

2) Perform the necessary operations.

3) Before restarting the database for the node via adminTools, open a vsql session as he DR admin on one of the other nodes and run the update the AHM.

From the /opt/vertica/bin directory as the Data Repository administrator user run:

./vsql -U <dr admin user>

Enter the password when prompted

         Then run this in the vsql> prompt:

select make_ahm_now(true);

Then, run \q to quit the prompt.

This updates the AHM, and reduces the number of small changes that need to be sent to the down node when it restarts.

 

4) Launch adminTools, and from the Main Menu of adminTools select Option 5 to Restart Vertica on Host.