Creating an Eon Mode database in AWS with MC

After you deploy Management Console on Amazon Web Services (AWS) with a CloudFormation Template, you can provision a cluster and database. Vertica clusters are provisioned in the same Virtual Private Cloud (VPC) as the Vertica Management Console. You can create an initial cluster of up to 60 hosts.

Prerequisites

Before you begin, complete or obtain the following:

• Deploy MC and AWS resources with a CloudFormation template

• AWS credentials and environment details

• S3 communal storage URL

• Vertica credentials

• Vertica Management Console Credentials

Choose one of the following setup options:

• Quick Setup: Select your cluster size based on your estimated compressed working data size. The Management Console calculates the volume size per node, and reserves part of the disk for catalog and temp storage.

• Advanced Setup: This option provides more granular control over configuration settings related to subnet, Node IP, and depot, temp, and catalog volume sizes.

Quick setup

1. Log in to the Vertica Management Console.

2. On the Management Console home page, select Create new database.

3. On Database Storage Mode, click Eon Mode.

4. Click Next. On Vertica License, select one of the following license mode options:

   • Community Edition: A free Vertica license to preview Vertica functionality. This license provides limited features. If you use a Community Edition license for your deployment, you can upgrade the license later to expand your cluster load. See Managing licenses form more information.

   • Premium Edition: Use your Vertica license. After you select this option, click Browse to locate and upload your Vertica license key file, or manually enter it in the field.

1. Click Next. On Setup Path, select Quick Setup.

2. Click Next. In the Vertica Settings section, select the desired Vertica database version. You can select from the latest hotfix of recent Vertica releases. For each database version, you can also select the operating system. See Choose a Vertica AMI Operating Systems for available OS and major version options.

3. In the AWS EC2 Instance Type section, select from one of the following instance types:

   • Ephemeral Depot

   • EBS Depot

4. In the Cluster Size section, select the number of instances to deploy with your cluster based on your working data size. For details about working data size, see Configuring your Vertica cluster for Eon Mode.
   

   Note

   If you are using a Community Edition license, your cluster size selections are limited to Small, Medium, and Large.

5. In the Database Parameters section, supply the following information:

   • Database Name: The name for your new database. See Creating a database name and password for database name requirements.

   • Administrator Username: The name of the database superuser.

   • Administrator Password: The password for the database administrator user account. For details, see Password guidelines.

   • Confirm Password: Reenter the Administrator Password.

   • Load Sample Data: Optional. Click the slider to the right to preload your database with example clickstream data. This option is useful if you are testing features and want some preloaded data in the database to query.

6. In the AWS Environment section, supply the following information:

   • AWS Key Pair: Your Amazon key pair for SSH access to EC2 instances.

   • IP Access: The cluster IP address range for SSH and client access to cluster hosts.

   • S3 Communal Storage URL: The path to a new subfolder in your existing AWS S3 bucket for Communal Storage of your Eon Mode database. Vertica creates the subfolder in the existing S3 bucket.

     Important

     Use an existing S3 bucket in the same region as your Management Console instance. In addition, you must use the S3 bucket that you specified when you deployed the CloudFormation template.

   • Tag EC2 Instances: Optional. Assign distinct, searchable metadata tags to the instances in this cluster. Many organizations use labels to organize, track responsibility, and assign costs for instances.
     To add a tag, click the slider to the right to display the Tag Name and Tag Value fields. Click Add to create the tag. Added tags are displayed below the fields.

7. Click Create Database Cluster to create a Eon Mode cluster on AWS.

Advanced setup

1. Log in to the Vertica Management Console.

2. On the Management Console home page, select Create new database.

3. On Database Storage Mode, click Eon Mode.

4. Click Next. On Vertica License, select one of the following license mode options:

   • Community Edition: A free Vertica license to preview Vertica functionality. This license provides limited features. If you use a Community Edition license for your deployment, you can upgrade the license later to expand your cluster load. See Managing licenses form more information.

   • Premium Edition: Use your Vertica license. After you select this option, click Browse to locate and upload your Vertica license key file, or manually enter it in the field.

1. Click Next. On Setup Path, select Advanced Setup.
   

2. Click Next. On AWS Environment, supply the following information:

   • AWS Key Pair: Your Amazon key pair for SSH access to EC2 instances.

   • AWS Subnet: The subnet for your cluster. By default, Vertica creates your cluster in the same subnet as your MC instance.
     

     Important

     Use security groups and network access control lists (ACLs) to secure your subnet. For details, see the Amazon documentation.

   • IP Access: The cluster IP address range for SSH and client access to cluster hosts.

   • Node IP Setting: Select Private, Public, or Elastic. For details about each option, see the Amazon documentation.

   • S3 Communal Storage URL: The path to a new subfolder in your existing AWS S3 bucket for Communal Storage of your Eon Mode database. Vertica creates the subfolder in the existing S3 bucket.
     

     Note

     Use an existing S3 bucket in the same region as your Management Console instance.

   • Tag EC2 Instances: Optional. Assign distinct, searchable metadata tags to the instances in this cluster. Many organizations use labels to organize, track responsibility, and assign costs for instances.
     To add a tag, click the slider to the right to display the Tag Name and Tag Value fields. Click Add to create the tag. Added tags are displayed below the fields.

3. Click Next. Database Parameters accepts information about your Vertica license. Supply the following information:

   • Database Name: The name for your new database. See Creating a database name and password for database name requirements.

   • Administrator Username: The name of the database superuser.

   • Administrator Password: The password for the database administrator user account. For details, see Password guidelines.

   • Confirm Password: Reenter the Administrator Password.

   • Vertica Version: Select the desired Vertica database version. You can select from the latest hotfix of recent Vertica releases. For each database version, you can also select the operating system. See Choose a Vertica AMI Operating Systems for available OS and major version options.

   • Load Sample Data: Optional. Click the slider to the right to preload your database with example clickstream data. This option is useful if you are testing features and want some preloaded data in the database to query.

4. Click Next. On AWS Configuration, supply the following information:

   • Number of Nodes: The initial number of nodes for your database.

   • Number of Vertica Database Shards: Sets the number of shards in your database. Vertica suggests a number of shards automatically, based on your node count. After you set this value, you cannot change it later. The shard count must be greater than or equal to the maximum subcluster count. Be sure to allow for node growth. See Configuring your Vertica cluster for Eon Mode for recommendations.
     

   • EC2 Instance Type: The instance types used for the nodes. See Choosing AWS Eon Mode Instance Types for a list of recommended AWS instances. For details about each instance type, see the Amazon EC2 Instance Types documentation.

   • Local Storage: Customize your cluster according to your storage needs. For guidance, see Eon Mode volume configuration defaults for AWS for the Vertica default settings for each supported instance.

5. Click Next. On Review, confirm your selections. Click Edit to return to a previous section and make changes.

6. When you are satisfied with your selections, click the I accept the terms and conditions checkbox.

7. Click Create Cluster to create a Eon Mode cluster on AWS.

After creating the database

After you create the database, click Get Started to view the Databases page. To view your database, select Manage and View Your Vertica Database to go to the database Overview.

You can also view your database from the Recent Databases section of the MC home page.

For additionalinformation about managing your cluster, instances, and database using Management Console, see Managing database clusters .