Importing an Existing Database Into MC

If you have already created a Vertica database, you can import it into MC to monitor its health and activity.

When you install MC on the same cluster as the existing database you intend to monitor, MC automatically discovers the cluster and any databases installed on it, whether those databases are currently running or are down.

If you haven't created a database and want to create one through the MC, see Create an Empty Database Using MC.

Import a Database Existing on a Monitored Cluster

The following procedure describes how to import an existing database that is on a cluster MC is already monitoring.

  1. Connect to Management Console and sign in as an MC administrator.
  2. On the MC Home page, click View Your Infrastructure.
  3. On the Databases and Clusters page, click the cluster and click View in the dialog box that opens.

  4. On the left side of the page under the Databases heading, click Import Discovered.

    A running database appears as Monitored; any non-running databases appear as Discovered. MC supports only one running database on a single cluster at a time. You must shut down a running database on a cluster in order to monitor another database on that cluster.

  5. In the Import Database dialog box:

    • Select the database you want to import.
    • Optionally clear auto-discovered databases you don't want to import.
    • Supply the database administrator username and password and click Import. (Supplying a non-administrator username prevents MC from displaying some charts after import.)
    • If the Vertica database is configured for TLS security, you need to configure TLS for all Management Console connections to this database over JDBC. Click Use TLS. Management Console launches the Certificates wizard. See Completing the MC Certificates Wizard.

After Management Console connects to the database it opens the Manage page, which provides a view of the cluster nodes. See Monitoring Cluster Status for more information.

You perform the import process once per existing database. Next time you connect to Management Console, your database appears under the Recent Databases section on the Home page, as well as on the Databases and Clusters page.

The system clocks in your cluster must be synchronized with the system that is running Management Console to allow automatic discovery of local clusters.

Import a Database Existing on a New Cluster

If the database you intend to monitor is on a cluster MC is not currently monitoring, MC cannot automatically discover it. You can import it with the following procedure.

  1. Connect to Management Console and sign in as an MC administrator.
  2. On the MC Home page, click Import a Vertica Database Cluster.
  3. Enter the IP address of one of the database's cluster nodes.
  4. Enter the master API key for the cluster. Find the key here: /opt/vertica/config/apikeys.dat

  5. In the Import Database dialog box:

    • Select the database you want to import.
    • Optionally clear auto-discovered databases you don't want to import.
    • Supply the database administrator username and password and click Import. (Supplying a non-administrator username prevents MC from displaying some charts after import.)
    • To configure TLS security for all Management Console connections to this database over JDBC, click Use TLS. Management Console launches the Certificates wizard. For instructions on completing the wizard, see Configuring TLS While Importing a Database on MC.