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:

  1. Log in to the Administration Tools as the database administrator and stop the database.
  2. 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.
  3. Exit the shell and re-establish a vsql connection as the database administrator.
  4. Log in to the Administration Tools and start the database.
  5. Use the Administration Tools Advanced Menu > Cluster Management > Add Hosts option to add the standby hosts you created in Step 2.
  6. 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.
  7. Optionally create fault groups to further define the layout of the control nodes within the physical cluster. See Fault Groups.