Removing Hosts From a Cluster

If a host that you removed from the database is not used by any other database, you can remove it from the cluster using the update_vertica script. You can leave the database running (UP) during this operation.

You can remove hosts from a database on the MC interface, but you cannot remove those hosts from a cluster.

Prerequisites

The host must not be used by any database.

Procedure to Remove Hosts

From one of the hosts in the cluster, run update_vertica with the –-remove-hosts switch. Provide a comma-separated list of hosts to remove from an existing Vertica cluster. You can specify a host by the host name or IP address of the system.

This example removes host01, host02, and host03 from the cluster:

# /opt/vertica/sbin/update_vertica --remove-hosts host01,host02,host03

Note: See Installing Vertica with the Installation Script for the full list of parameters.

The update_vertica script uses all the same options as install_vertica and:

Important Tips