Creating an Enterprise 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:

• Launch MC and AWS resources with a CloudFormation template

• AWS credentials and environment details

• S3 communal storage URL

• Vertica credentials

• Vertica Management 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 Enterprise Mode.
   

4. Click Next. Create a New Vertica Cluster | mode: Enterprise provides you with two workflow options for creating your database. Select one of the following:

   • Quick Create: Vertica configures your EC2 instances with default settings.

   • Custom Create: You can specify EC2 instance types and other database settings.

5. Click Next. On Enter AWS Credentials and preferences, AWS Region is filled with the region of the Management Console host. Supply the following information:

   • AWS Subnet: Under Show Advanced Options. Select the subnet used to create your cluster.

   • 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.

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

6. Click Next. Enter Vertica database name and login credentials accepts information about your Vertica license. Supply the following information:

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

   • Vertica Version: Custom Create mode only. 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.

   • Vertica Database User Name: The name of the database superuser.

   • Password: The password associated with the database username. For details, see Password guidelines.

   • Confirm Password: Reenter the Password.

   • Database Node Count: The number of nodes that you want to deploy in this cluster. Quick Create mode provides options for 1 or 3 database node counts.

   • Vertica License: Custom Create mode only. Click Browse to locate and upload your Vertica license key file. If you do not supply a license key file here, the wizard deploys your database with a Vertica Community Edition license. This license has a three node limit, so the value in the Database Size filed cannot be larger than 3 if you do not supply a license. If you use a Community Edition license for your deployment, you can upgrade the license later to expand your cluster load more than 1TB of data. See Managing licenses form more information.
     

   • Load example test data: Optional. Click the checkbox 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. Specify cloud instance and main data storage info provides options to let you customize your instance configuration. In Quick Create mode, the options on this screen are pre-selected and read-only.
   Database Data Path is filled with the path to your persistent database storage.
   EBS Volume Type and EBS Volume Size (GB) per Volume per Available Node fields are filled with default values for the selected EC2 Instance Type. See Eon Mode volume configuration defaults for AWS for more information.
   In Custom Create mode, supply information for the following:

   • EC2 Instance Type: The instance type your cluster deploys. See Supported AWS instance types for more information.

   • EBS Volume Type: The block-level storage type for each node in your cluster. See Enterprise Mode volume configuration defaults for AWS for recommendations about supported volume types.

   • EBS Volume Size (GB) per Volume per Available Node: The amount of disk space available on each disk attached to each node in your cluster. This field shows you the total disk space available per node in your cluster.

   • Enable EBS Volume Encryption: Optional. Select the checkbox if you want server-level encryption on your EC2 instances. With AWS, only 4th and 5th generation instance types (c4/5, r4/5, and m4/5) support encryption.

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

8. Click Next. Specify additional storage and tag info lets you allocate additional storage for your cluster. In Quick Create mode, the options on this screen are pre-selected and read-only.
   

   • Database Catalog Path is the location of the local copy of the database catalog. Database Temp Path is the temporary storage space for each node, if the node instance type includes the temporary storage option.

   • In Custom Create mode, select or enter a value for EBS Volume Type, EBS Volume Size (GB) per Volume per Available Node, and Enable EBS Volume Encryption under each path. Each field has the same definition as described in the previous step.

   • 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.
     After you click the checkbox, the Tag Name and Tag Value fields are displayed. Click Add to create the tag. Added tags are displayed below the fields.
     

9. Click Next. On the Review screen, confirm your selections. To edit your selections, click Back until you reach the screen containing information that you want to edit.

10. When you are satisfied with your selections, click the Accept terms and conditions of the "Software Only Terms" for your territory checkbox.

11. Click Create to create an Enterprise 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.