how to change Vertica DB node IP to use different subnet

let's say for example that you have 3 Vertica nodes and the inteconnect communication subnet was 10.0.0.X
now for some reason you want to change the internal communication between the nodes to use another interface using this subnet:  192.168.1.X

please follow these step by step guide in order to accomplish this target:

-----------------------------------------------------------------

first change network from to use point-to-point mode

1.
select set_control_mode('pt2pt');
select reload_spread(true);

Check in the catalog directory if spread.conf got modified to broadcast mode.

2. Edit admintools.conf  controlmode

controlmode = pt2pt

3. Use admintools to distribute database configuration and metadata to all cluster nodes

4. In order to make spread adjust new configuration you need to restart Vertica DB


for each Vertica node run these steps to change IP used by interconnect

1. Stop Vertica on node

2.  Change hostname through vsql :

alter node <node_name> is hostname '<New IP address>' control hostname '<new IP address of spread> ' broadcast '<broadcast address of spread>';

select reload_spread(true);

alter node v_db_node0001 is hostname '192.168.1.5' control hostname '192.168.1.5 ' broadcast '192.168.1.255';

select reload_spread('true');

3. replace old IP address with new IP address in admintools.conf

4. Use admintools to distribute database configuration and metadata to all cluster nodes

5. On the node that is down run:

/opt/vertica/spread/bin/spmonitor -c spread.conf

select 'r' to reload the spread config
this action will reload the spread config

6. Restart Vertica on the node.

7. Once the node joins the cluster move to the next node