Import an Existing Database Into MC
If you have already upgraded your database to the current version of Vertica, MC automatically discovers the cluster and any databases installed on it, regardless of whether those databases are currently running or are down.
Note: If you haven't created a database and want to create one through the MC, see Create an Empty Database Using MC.
How to Import an Existing Database on the Cluster
The following procedure describes how to import an existing database into the MC interface so you can monitor it.
- Connect to Management Console and sign in as an MC administrator.
- On the MC Home page, click Existing Infrastructure.
- On the Databases and Clusters page, click the cluster and click View in the dialog box that opens.
-
On the left side of the page under the Databases heading, and click Import Discovered.
Tip: A running database appears as Monitored, and 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.
-
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.)
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.
Note: The system clocks in your cluster must be synchronized with the system that is running Management Console to allow automatic discovery of local clusters.