Import and Monitor in a Hadoop Environment

You can use Management Console to connect to and monitor a Vertica database that resides in an Apache Hadoop environment.

Connecting to Ambari and Importing Vertica Within a Hadoop Environment

To import your Vertica database that resides in a Hadoop environment, connect to that Hadoop environment in Management Console through an Apache Ambari server. Then,through that connection, import Vertica.

Before you connect and import, you must:

To connect to an Ambari server:

  1. From the Management Console home page, select Provisioning. Then, click Connect using an Ambari server to import Vertica within a Hadoop environment.

  2. In the Provision Access within Hadoop Environment window, enter a new Ambari connection with your username and password . If have already have an existing connection,a window opens that allows you to select an existing connection from the drop-down menu.

  3. In the next window, select the Hadoop cluster where the Vertica database you want to monitor resides. MC will discover Hadoop clusters that are currently monitored by the Ambari server you specify.

    A window appears confirming that your Hadoop cluster is saved. If MC currently does not monitor Vertica clusters in the specified Hadoop environment, you have the option to import Vertica clusters at this time.

  4. Enter the IP address for the Vertica database you want to import and monitor. If Vertica is running on multiple hosts, enter the IP address of one of them.

  5. Enter the API key for the Vertica cluster. The API key is generated during Vertica installation and you can find it in the /opt/vertica/config/apikeys.dat file.

  6. When the next window displays the discovered databases, select one or more database you want to import, along with the database username and password.

  7. Confirm that the import is successful. If it is, a success message appears. Click Done to go to the Existing Infrastructure page.

To import an additional Vertica cluster within a Hadoop environment, click Import Cluster or database using IP address discovery under Provisioning. Management Console will automatically associate the cluster with the existing Hadoop environment.

Monitoring Vertica Within a Hadoop Environment

To monitor the Vertica clusters in a Hadoop environment, navigate to the Existing Infrastructure page:

Click to select the Hadoop environment, and then click View Vertica Databases.

The resulting screen displays information about the Vertica databases that reside in a Hadoop environment:

You can monitor information like resource usage, Hadoop services, and database and connection status.

Updating and Removing an Ambari Connection

To update or remove an existing Ambari connection, go to the MC Existing Infrastructure page, and click on the relevant Hadoop environment.

To update a connection, click Update Ambari Connection. Step through the wizard to update the connection.

To remove a connection, select Update Ambari Connection and choose Remove Connection, or click Discontinue Monitoring and then confirm that you want to remove the connection. Removing the connection also removes all Vertica databases associated with this connection from MC monitoring. You can re-import the databases later if needed.

See Also:

Integrating with Apache Hadoop