Restarting Vertica on a host

When one node in a running database cluster fails, or if any files from the catalog or data directories are lost from any one of the nodes, you can check the status of failed nodes using either the Administration Tools or the Management Console.

Restarting Vertica on a host using the administration tools

1. Run Administration tools.

2. From the Main Menu, select Restart Vertica on Host and click OK.

3. Select the database host you want to recover and click OK.

   Note

   You might see additional nodes in the list, which are used internally by the Administration Tools. You can safely ignore these nodes.

4. Verify recovery state by selecting View Database Cluster State from the Main Menu.

After the database is fully recovered, you can check the status at any time by selecting View Database Cluster State from the Administration Tools Main Menu.

Restarting Vertica on a host using the Management Console

1. Connect to a cluster node (or the host on which MC is installed).

2. Open a browser and connect to MC as an MC administrator.

3. On the MC Home page, double-click the running database under the Recent Databases section.

4. Within the Overview page, look at the node status under the Database sub-section and see if all nodes are up. The status will indicate how many nodes are up, critical, down, recovering, or other.

5. If a node is down, click Manage at the bottom of the page and inspect the graph. A failed node will appear in red.

6. Click the failed node to select it and in the Node List, click the Start node button.