Created
October 6, 2014 09:43
-
-
Save cstrap/c4f4186abf78c044b1c4 to your computer and use it in GitHub Desktop.
Adding a HP Vertica node outside main cluster
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment