What’s New in Management Console 9.0

Posted October 31, 2017 by Soniya Shah, Information Developer

This blog post was authored by Lisa Donaghue.

In Vertica 9.0, Management Console (MC) provides tools to provision and manage clusters and databases on an AWS environment. You can get started easily with a guided Cluster Creation wizard on AWS. The new Fast Tasks page introduces new users to a few fundamental MC tasks to get started.

MC now supports Eon Mode Beta databases. Use MC to create and monitor an Eon Mode Beta database, including monitoring for shard distribution and storage allocation.

Provision a Cluster and Database on AWS Using MC

Management Console with Provisioning is a new deployment of Management Console (MC) that allows you to provision, manage, and monitor Vertica on AWS resources. Launch Management Console with Provisioning and its associated AWS resources through the AWS Marketplace.

After launching MC through the AWS Marketplace, use the new Cluster Creation wizard in MC to deploy Vertica cluster instances and create an Eon Mode Beta or Enterprise Mode database.

See the documentation for launching MC with Provisioning.

Manage Clusters in an AWS Environment

If you create your cluster on AWS resources using the Cluster Creation wizard, the Cluster page in MC now shows additional AWS cluster and instance management options.

Without switching to the AWS console, you can still perform AWS instance operations like stop, start, reboot and terminate. You can perform these operations on the whole cluster, or just one instance at a time.

For example, if your database’s workload is about to increase for a day and you need to improve query throughput, you can use the Cluster page to add extra instances to your cluster, and to remove them again when your workload returns to normal.

See the documentation for managing a cluster created with the Cluster Creation wizard.

Fast Tasks

The Fast Tasks page offers a few important tasks to get you started managing your database through MC. When you successfully create a new database using the Cluster Creation wizard, this is the first page you’ll see. Reference this page if you’re not sure where to begin with MC—it introduces you to your monitoring dashboard, the in-browser query runner, and S3 data loading with MC.

To view the Fast Tasks page after cluster creation, click Fast Tasks in the Actions column of any available database on the MC home page.

See Fast Tasks in the documentation.

Monitor Database Storage

MC now provides a Storage View tab with a summary of the amount of data stored across your database, and where that data is persistently located. The storage summary offers insight into both Enterprise Mode and Eon Mode Beta database storage usage. Use this view to monitor how much of your storage capacity your databases are using.

See Monitoring Database Storage in the documentation.

Monitor Shard Subscription Status on Eon Mode Beta Databases

For databases running in Eon Mode Beta, the Storage View page also displays bar charts that illustrate the subscription status of shards and nodes, respectively.

Each node in an Eon Mode Beta database subscribes to a subset of the database’s shards, which are segments of the data in your database’s communal storage location. Subscriptions tell the nodes when to populate its depot with new data from communal storage. When your cluster is actively subscribed to all the database’s shards, the depot can remain up-to-date and serve your queries more quickly.

Use the new Sharding Subscription and Node Subscription charts in MC to monitor the status of all shard subscriptions and how many nodes in your cluster are successfully subscribed to a shard.

The Sharding Subscription chart, available for Eon Mode Beta databases on the Storage View tab:

The Node Subscription chart, also available on the Storage View tab for Eon Mode Beta databases:

See Monitoring Subscription Status in Eon Mode Beta in the documentation.