Management Console
Management Console (MC) is the Vertica in-browser monitoring and management tool. Its graphical user interface provides a unified view of your Vertica database operations.
Through user-friendly, step-by-step screens, you can create, configure, manage, and monitor your Vertica databases and their associated clusters.
You can use MC to operate your Vertica database in Eon Mode or in Enterprise Mode. You can use MC to provision and deploy a Vertica Eon Mode database.
What You Can Do with Management Console
| Create... |
|---|
| A database cluster on hosts that do not have Vertica installed |
|
Multiple Vertica databases on one or more clusters from a single point of control |
|
MC users and grant them access to MC and databases managed by MC |
| Configure... |
|
Database parameters and user settings dynamically |
|
Resource pools |
| Monitor... |
|
License usage and conformance |
|
Dynamic metrics about your database cluster |
|
Resource pools |
|
User information and activity on MC |
|
Alerts by accessing a single message box of alerts for all managed databases |
|
Recent databases and clusters through a quick link |
|
Multiple Vertica databases on one or more clusters from a single point of control |
| Import or Export... |
|
Export all database messages or log/query details to a file |
|
Import multiple Vertica databases on one or more clusters from a single point of control |
| Troubleshoot... |
|
MC-related issues through a browser |
Management Console provides some, but not all, the functionality that Administration Tools provides. Management Console also includes extended functionality not available in admintools. This additional functionality includes a graphical view of your Vertica database and detailed monitoring charts and graphs. See Administration Tools and Management Console in the Administrator's Guide for more information.
Getting MC
Download the Vertica server RPM and the MC package from myVertica Portal. You then have two options:
- Install Vertica and MC at the command line and import one or more Vertica database clusters into the MC interface
- Install Vertica directly through MC
See the Installation Guide for details.
What You Need to Know
If you plan to use MC, review the following topics in the Administrator's Guide:
| If you want to ... | See ... |
|---|---|
|
Create a new, empty Vertica database |
|
|
Import an existing Vertica database cluster into MC |
|
|
Understand how MC users differ from database users |
|
|
Read about the MC privilege model |
|
|
Create new MC users |
|
|
Grant MC users privileges on one or more Vertica databases managed by MC |
|
|
Use Vertica functionality through the MC interface |
|
|
Monitor MC and Vertica databases managed by MC |
|
|
Monitor and configure Resource Pools |