Overview of Vertica on Amazon Web Services (AWS)
Vertica clusters on AWS can operate on EC2 instances automatically provisioned using a CloudFormation Template, or manually deployed from Amazon Machine Images (AMIs).
You can create a database in either Eon Mode or Enterprise Mode in a Vertica cluster in AWS.
CloudFormation Templates
Vertica provides Cloud Formation Templates (CFTs) through the AWS Marketplace. After you provide a few parameters to the template, create a stack to automatically provision the AWS resources for your Vertica system.
After creating the stack, use the Management Console (MC) to create and manage clusters and databases. See Provision a New Vertica Cluster and Database on AWS Resources.
Available Products
Using the license models and CFTs described in CloudFormation Template (CFT) Overview, you can install the following products:
- Vertica BYOL, Amazon Linux 2.0
- Vertica by the Hour, Amazon Linux 2.0
- Vertica BYOL, Red Hat
- Vertica by the Hour, Red Hat
See Launching MC and AWS Resources with a CloudFormation Template for information on installing these products
Vertica AMI Operating Systems for AWS
Vertica provides Vertica and Management Console AMIs in the following operating systems.
- Red Hat 7.4
- Amazon Linux 2.0
You can use the AMI to deploy MC hosts or cluster hosts.
Important: When using Amazon Linux 2.0, you must compile C++ UDX libraries with a gcc version 4.8. For more information see Setting Up a Development Environment.
Supported Instance Types
Vertica supports a range of Amazon Web Services (AWS) instance types, each optimized for different purposes. Choose the instance type that best matches your performance and price needs as a user. Pricing information can be found on the AWS Marketplace:
| Optimization | Type |
|---|---|
| General Purpose |
m4.4xlarge m4.10xlarge |
|
Compute (supports ephemeral storage, c3 instances only) |
c3.4xlarge c3.8xlarge c4.4xlarge c4.8xlarge |
|
Memory (supports ephemeral storage, r3 instances only) |
r3.4xlarge r3.8xlarge r4.4xlarge r4.8xlarge r4.16xlarge |
|
Storage (supports ephemeral storage) |
i2.4xlarge i2.8xlarge i3.4xlarge i3.8xlarge i3.16xlarge |
|
Dense-storage (supports ephemeral storage) |
d2.4xlarge d2.8xlarge |
Note: Data stored on ephemeral drives exists only while that instance is powered on. After powering off, data on ephemeral drives is lost.
For more information about Amazon cluster instances and their limitations, see the Amazon documentation.
Vertica AMI Sleep C-States
By default, the following instances have their processor C-states set to a value of 1 in the Vertica AMI:
- c4.8xlarge
- d2.8xlarge
- m4.10xlarge
This measure is meant to improve performance by limiting the sleep states an instance running Vertica will use.
For more information about sleep states, visit the AWS Documentation.
AWS Features Supported byVertica
Vertica supports the following AWS features:
- Enhanced Networking: Vertica recommends that you use the AWS enhanced networking for optimal performance. For more information, see Enabling Enhanced Networking on Linux Instances in a VPC in the AWS documentation.
- Command Line Interface: Use the Amazon command-line Interface (CLI) with your Vertica AMIs. For more information see the AWS Documentation.
- Elastic Load Balancing: Use elastic load balancing (ELB) for queries up to one hour. When enabling ELB, configure the timer to 3600 seconds. For more information see the Amazon documentation.
