Using MC to Provision and Create an Eon Mode Database in AWS

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:

• Launch MC and AWS Resources with a CloudFormation Template
• AWS credentials and environment details
• S3 communal storage URL
• Vertica credentials
• VerticaManagement Console Credentials

Provisioning a Cluster and Database

1. Log in to the Vertica Management Console.
2. On the Management Console home page under Provision, click 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.
5. Click Next. On AWS Environment, supply the following information:
   • AWS Access Key ID: Displayed if MC was configured to use the AWS Access Keys authentication method. Enter your access key.
   • AWS Secret Access Key: Displayed if MC was configured to use the AWS Access Keys authentication method. Enter the password associated with the AWS Access Key ID.
   • 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.
     
     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.
     
     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.
6. 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 Vertica AMI Operating Systems for AWS 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.
7. 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.
8. Click Next. On Review, confirm your selections. Click Edit to return to a previous section and make changes.
9. When you are satisfied with your selections, click the I accept the terms and conditions checkbox.
10. Click Create Cluster to create a Eon Mode cluster on AWS.

After the cluster and database is successfully created, click Get Started to view the Fast Tasks 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.

See Managing Database Clusters for further managing your cluster, instances, and database using Management Console.