This article addresses the steps required to remove unused hosts from a Vertica database cluster. Host removal is often necessary when decommissioning servers, optimizing cluster performance, or reconfiguring the database.
This process involves using Vertica’s Administration Tools and, for larger clusters, requires running specific SQL commands to realign control nodes.
DX NetOps Performance Management
A. Removing Hosts from the Database
Launch Administration Tools
dbadmin
user.Access Advanced Menu
Navigate to Cluster Management
Initiate Host Removal
Select the Database
Choose Hosts to Remove
Confirm Removal
Acknowledge Success
Note: Do not stop the database during this process.
B. Removing Hosts from the Cluster
If the removed hosts are not utilized by any other databases within the cluster, proceed to remove them from the cluster configuration.
update_vertica
Command
host01, host02, host03
with the actual hostnames or IP addresses of the hosts to be removed.Note: The update_vertica
command performs the following tasks:
Important: The database can remain operational during this operation.
By following these steps, you can effectively remove unused hosts from your Vertica database cluster, maintaining an efficient and well-balanced system.