Administration Tools and Management Console

You can perform most database administration tasks using the Administration Tools, but you have the additional option of using the more visual and dynamic Management Console.

The following table compares the functionality available in both interfaces. Continue to use Administration Tools and the command line to perform actions not yet supported by Management Console.

Vertica Functionality Management Console Administration Tools

Use a Web interface for the administration of Vertica

Yes

No

Manage/monitor one or more databases and clusters through a UI

Yes

No

Manage multiple databases on different clusters

Yes

Yes

View database cluster state

Yes

Yes

View multiple cluster states

Yes

No

Connect to the database

Yes

Yes

Start/stop an existing database

Yes

Yes

Stop/restart Vertica on host

Yes

Yes

Kill a Vertica process on host

No

Yes

Create one or more databases

Yes

Yes

View databases

Yes

Yes

Remove a database from view

Yes

No

Drop a database

Yes

Yes

Create a physical schema design (Database Designer)

Yes

Yes

Modify a physical schema design (Database Designer)

Yes

Yes

Set the restart policy

No

Yes

Roll back database to the Last Good Epoch

No

Yes

Manage clusters (add, replace, remove hosts)

Yes

Yes

Rebalance data across nodes in the database

Yes

Yes

Configure database parameters dynamically

Yes

No

View database activity in relation to physical resource usage

Yes

No

View alerts and messages dynamically

Yes

No

View current database size usage statistics

Yes

No

View database size usage statistics over time

Yes

No

Upload/upgrade a license file

Yes

Yes

Warn users about license violation on login

Yes

Yes

Create, edit, manage, and delete users/user information

Yes

No

Use LDAP to authenticate users with company credentials

Yes

Yes

Manage user access to MC through roles

Yes

No

Map Management Console users to a Vertica database

Yes

No

Enable and disable user access to MC and/or the database

Yes

No

Audit user activity on database

Yes

No

Hide features unavailable to a user through roles

Yes

No

Generate new user (non-LDAP) passwords

Yes

No

Management Console Provides some, but Not All of the Functionality Provided By the Administration Tools. MC Also Provides Functionality Not Available in the Administration Tools.

See Also