Exasol on AWS
Amazon Web Service (AWS) provides a suite of infrastructure services that enable you to deploy Exasol in a highly available, scalable, and affordable way. This section provides you with step-by-step instructions for deploying Exasol on AWS Cloud.
Before You Begin
Read the following sections before you start setting up Exasol on AWS.
Exasol on AWS is available through the AWS Marketplace in two variants, depending on how you want to license it.
- Exasol Analytic Database (Single Node and Cluster, Enterprise Support): You simply pay for what you use. You are billed through the AWS Marketplace on an hourly basis.
- Exasol Analytic Database (Single Node and Cluster, BYOL): You already have a valid Exasol license for the selected configuration or if you plan to purchase an Exasol license separately.
The Pay As You Go (PayG) version is the default version used in the deployment templates. If you are not sure which version to choose from, then it is recommended to go with the PayG version.
Exasol recommends the following cloud-specific configurations:
- Instance families: For Exasol 6.1 release, m5, r5, and c5 are recommended. For Exasol 6.0 release, m4 and r4 are recommended.
- Storage: Instance-integrated hard drives (ephemeral storage) and EBS volumes are supported for data storage. In production environments, use EBS drives, as these provide maximum reliability and durability. For EBS type we recommend using at least General Purpose SSD (gp2) volumes. For data backup and restore as well as data import and export, S3 storage is recommended.
- Minimum main memory size: 16GiB
We recommend setting up Exasol as a cluster. This offers the following advantages:
- Scalability: easily scale out a cluster by adding additional nodes to process more data and to serve more concurrent users.
- High availability: When a node fails the system automatically tries to repair this node or includes a standby node into the system (if a standby node was configured).
However, for small data sizes or evaluation purposes, a single-node system would be sufficient and more appropriate. Setting up a cluster using our CloudFormation templates is as easy as setting up a single node system.
Before you begin with deploying Exasol on AWS, we recommend you to familiarize yourself with the AWS services listed in this table.
|AWS Services||More Information|
Ensure you have an AWS account. If you do not have one, you can sign up for an AWS Account.
AWS Identity and Access Management (IAM) is a web service that helps you securely control access to AWS resources. You use IAM to control who is authenticated (signed in) and authorized (has permissions) to use resources. See Create an IAM User for more information.
The Exasol Cloud Tool defines an IAM policy which is required for Exasol to run on AWS.
For information about AWS IAM policy, see AWS Identity and Access Management.
AWS uses public-key cryptography to secure the log-in information for your instance.
Unlike in symmetric cryptography, you need one key to encrypt data and another key to decrypt it. This allows you to openly publish one of the keys while you keep the other one secret. Together those two keys form a key pair.
See Create a Key Pair for more details.
|Virtual Private Cloud (VPC) and Connection Considerations||
A Virtual Private Cloud (VPC) allows you to control your networking environment, including selecting your own IP address range, creating subnets, and more. For the purposes of installing Exasol, you need to set up a VPC with a single public subnet. You can do this using the AWS Console. See Create a Virtual Private Cloud (VPC)for more information.
The EC2 instance types have different hardware and architecture configurations, and also influence the pricing for running Exasol on AWS. For a list of available EC2 Instance Types you can use, see Exasol's AWS Marketplace page.
Recommended instance families for Exasol are:
A security group is set of white-list rules for a stateful IP-level firewall. It is associated with network interfaces of an instance and can control inbound and outbound traffic through these interfaces. For more information, see Security Groups for Your VPC.
Before launching Exasol on an AWS instance, you must consider the storage type for data storage, import, export, and backups.
See Storage for more information.
Exasol recommends using EBS volumes as storage configuration for Exasol on AWS.
|Amazon EC2 Service Limits||
Based on your region, there could be some limits (Amazon EC2 Service Limits) on the resources that you can use. You should check these limitations to manage your resources better.
For more information about how to take care of the resource limitations, see. AWS Service Limits.
Step 1: Subscribe to Exasol
To start with Exasol on AWS, you have to subscribe one of the offering on the Amazon Marketplace. Do the following to subscribe to Exasol on the Amazon Marketplace:
- Log in to AWS Marketplace with your credentials. If you don't have an account, create one.
- Search for Exasol in the AWS marketplace. You will get the following two options:
- Depending on your requirements, select one of the above offering and click Continue to Subscribe button.
On successful subscription, the next page shows you details about your subscription.
Step 2: Installation and Template Configuration
Option 1: Using Cloud Deployment Wizard
Exasol recommends configuring and deploying an Exasol cluster or single node system using Exasol Cloud Deployment Wizard for public clouds. The wizard guides you through the sizing, configuration, and deployment process. Internally it uses and parameterizes the standard CloudFormation templates.
To know how to install Exasol on AWS using the wizard, see Installation Using Exasol Cloud Deployment Wizard.
After configuring your cluster, you can either launch your AWS stack or you can download the pre-configured CF template. When you select Launch Stack option, it opens with the AWS CloudFormation UI to proceed with the deployment process. In the CloudFormation UI, you can once more review and customize all settings.
To know more about the Cloud Deployment Wizard, watch the following video.
Options 2; Using CloudFormation Templates
If you don't want to use the configuration recommendations of the wizard, you can use the CloudFormation templates to install Exasol. For detailed instructions, refer to Exasol Installation Using CloudFormation Templates section.
Step 3: Connect Tools and Install Drivers
After installing Exasol on AWS, you can do the following:
- Install drivers required to connect to other tools.
- Connect SQL clients to Exasol.
- Connect Business Intelligence tools (BI tools) to Exasol.
- Connect Data Integration - ETL tool to Exasol.
- Connect Data Warehouse Automation tools to Exasol.
Step 4: Load Data
After you have connected your choice of tool to Exasol, you can load your data into Exasol and process further. To know more about loading data into Exasol, see Loading Data.
Step 5: Administration
Once you have all the configurations in place and started using Exasol, you may have to perform some administration tasks, for example, adding new node, changing the instance type, increasing storage, and so on. To know more about the administrative activities that you can perform on your Exasol instance, see Administration on AWS.
Support, Troubleshooting & Software Updates
Exasol Analytic Database (Single Node and Cluster, Enterprise Support) is the pay-as-you-go version of Exasol 6.2.1. It comes with 24x7 incident management support. You need to register to enable the support for your account. After you register, you can get the following benefits:
- Access to Exasol Community
- Access to Exasol Ticketing System
- Access to Product Updates
- 24x7 Incident Management
Click the following button to register for support.
Terms and conditions:
- This support offering is only valid for Exasol instances launched using the AWS Marketplace offering Exasol Analytic Database (Single Node and Cluster, Enterprise Support)
- The SLA starts only after the registration process is complete.
- The registration process may take some time to complete.
If you have any support request before your registration is complete, click the following button to send your support request.