Expanding the Database to a Large Cluster
If you have an existing database cluster that you want to expand to a large cluster (more than 120 nodes), follow these steps:
- Log in to the Administration Tools as the database administrator and stop the database.
- As root or a user with sudo privileges, open a BASH shell and run the install_vertica script with the
--add-hosts
argument, providing a comma-separated list of hosts you want to add to an existing Vertica cluster. See Installing Vertica with the Installation Script in Installing Vertica. - Exit the shell and re-establish a vsql connection as the database administrator.
- Log in to the Administration Tools and start the database.
- Use the Administration Tools Advanced Menu > Cluster Management > Add Hosts option to add the standby hosts you created in Step 2.
- Run
SET_CONTROL_SET_SIZE(integer)
to specify the number of control nodes you want on the cluster. See Defining and Realigning Control Nodes on an Existing Cluster. - Optionally create fault groups to further define the layout of the control nodes within the physical cluster. See Fault Groups.