Adding Nodes to a Database

Once you have added one or more hosts to the cluster, you can add them as nodes to the database.

You can add nodes to a database using these methods:

Note: When you add nodes to a database using either the MC or the Administration Tools interface (GUI), Vertica does not always preserve the order of the host and node names. You can preserve the order of the nodes you add by using the admintools command line with the db_add_node tool. An example follows, where the -s option allows you to specify the order of the nodes you are adding.

$ admintools -t db_add_node -d sampleDB -p 'password' -s 192.0.2.1,192.0.2.2,192.0.2.3

To Add Nodes to a Database Using MC

Only nodes in STANDBY state are eligible for addition. STANDBY nodes are nodes included in the cluster but not yet assigned to the database.

You add nodes to a database on MC's Manage page. Click the node you want to act upon, and then click Add node in the Node List.

When you add a node, the node icon in the cluster view changes color from gray (empty) to green as the node comes online. Additionally, a task list displays detailed progress of the node addition process.

To Add Nodes to a Database Using the Administration Tools:

  1. Open the Administration Tools. (See Using the Administration Tools.)
  2. On the Main Menu, select View Database Cluster State to verify that the database is running. If it is not, start it.
  3. From the Main Menu, select Advanced Tools Menu and click OK.
  4. In the Advanced Menu, select Cluster Management and click OK.
  5. In the Cluster Management menu, select Add Host(s) and click OK.
  6. Select the database to which you want to add one or more hosts, and then select OK.

    A list of unused hosts is displayed.

  7. Select the hosts you want to add to the database and click OK.
  8. When prompted, click Yes to confirm that you want to add the hosts.
  9. When prompted, enter the password for the database, and then select OK.
  10. When prompted that the hosts were successfully added, select OK.
  11. Vertica now automatically starts the rebalancing process to populate the new node with data. When prompted, enter the path to a temporary directory that the Database Designer can use to rebalance the data in the database and select OK.
  12. Either press enter to accept the default K-Safety value, or enter a new higher value for the database and select OK.
  13. Select whether Vertica should immediately start rebalancing the database, or whether it should create a script to rebalance the database later. You should select the option to automatically start rebalancing unless you want to delay rebalancing until a time when the database has a lower load. If you choose to automatically rebalance the database, the script is still created and saved where you can use it later.
  14. Review the summary of the rebalancing process and select Proceed.
  15. If you chose to automatically rebalance, the rebalance process runs. If you chose to create a script, the script is generated and saved. In either case, you are shown a success screen, and prompted to select OK to end the Add Node process.