cstrap
10/6/2014 - 9:43 AM

Adding a HP Vertica node outside main cluster

Adding a HP Vertica node outside main cluster

-- First setup Vertica node. 
-- When it's up'n'running launch from vsql:

CREATE SUBNET my_subnet with '192.168.0.0'; -- IP of your subnet may differs

-- The above statement creates a subnet between Vertica main clusters and the Vertica node.
-- NOTE: they must be in the same network

ALTER DATABASE VERTICA_DB EXPORT ON my_subnet;

-- At this point the Vertica node exposes VERTICA_DB database to subnet.