3.
Replace [node-ip-addresses] with a comma-separated list of the Data Node
eth0 routable IPaddresses you want to remove from the Data Store.
4.
Copy the updated command, paste it into the command prompt, and press Enter to
stop Vertica on that Data Node.
Replace a Data Node
Before You Begin
l
Log into a Data Node's console as root.
Procedure
1.
Enter su - dbadmin and press Enter to run the following commands as the
dbadmin user.
2.
Copy the following command and paste it in a plaintext editor:
/opt/vertica/bin/admintools -t db_replace_node -d sw -o
[old-data-node-hostname] -n [new-data-node-hostname]
3.
Replace [old-data-node-hostname] with the Data Node host name that you
want to remove from the Data Store.
4.
Replace [new-data-node-hostname] with the Data Node host name that you
want to add as a replacement to the Data Store.
5.
Copy the updated command, paste it into the command prompt, and press Enter to
replace the prior Data Node with the new Data Node.
6.
Copy /opt/vertica/bin/admintools -t distribute_config_
files, paste it into the command prompt, and press Enter to distribute
configuration files to the new Data Node.
7.
Copy the following command and paste it in a plaintext editor:
/opt/vertica/sbin/update_vertica --remove-hosts [old-data-
node-hostname]
8.
Replace [old-data-node-hostname] with the Data Node host name that you
want to remove from the Data Store.
9.
Copy the updated command, paste it into the command prompt, and press Enter to
remove the prior Data Node from the Data Store.
10.
Copy the following command and paste it in a plaintext editor:
/opt/vertica/bin/admintools -t restart_node -s [new-data-
node-hostname]
© 2021 Cisco Systems, Inc. and/or its affiliates. All rights reserved. - 54 -
Data Store Maintenance