Maintenance Notification:
On next Monday August 5th 2019 starting at 7am CEST we will conduct some maintenance. You might encounter some issues using the Exasol User Portal and Issue Tracker! We will restore the Exasol User Portal and Issue Tracker before 9am CEST on Monday August 5th 2019.
Table of Contents
Exasol on AWS versions in the AWS Marketplace
Pay-As-You-Go (PAYG)
- Simply pay for what you use
- Charged on an hourly basis
- Billed through the cloud Marketplace
- This offering includes community support
This is the default version used in the deployment templates.
If you are not sure which version to choose, this version is most probably the version you should use.
(Link to the marketplace offering https://aws.amazon.com/marketplace/pp/B01FXIPXV4 )
Bring-Your-Own-License (BYOL)
- Select this option if you already have a valid Exasol license for the selected configuration or if you plan to purchase a license.
- The license file is required to operate this product
(Link to marketplace offering: https://aws.amazon.com/marketplace/pp/B01IVOPPN8)
We recommend reading the getting started guides before launching a database system.
Getting started
We recommend setting up Exasol as 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 nodes failes the system automatically tries to repair this node or include a standby node into the system (if a standby node was configured).
However, for small data sizes and evaluation purposes a single-node system might be sufficient.
Setting up a cluster using our CloudFormation templates is as easy as setting up a single node system.
Cluster Installation
The recommended cluster installation method is AWS CloudFormation. The following guide explains step-by-step how to conveniently deploy an Exasol cluster using an AWS CloudFormation template:: - SOL-605Getting issue details... STATUS
Cluster Quick Launch
If you just want to start a preconfigured cluster as quickly as possible just follow the instruction below:
In case you need full control over all parameters (e.g. setting the AMI-ID manually or configuring the number and size of the attached data disks) you might use our advanced templates: - SOL-636Getting issue details... STATUS
Single node installation
The recommended single-node installation method is AWS CloudFormation. The following guide explains step-by-step how to conveniently deploy an Exasol single node database system using an AWS CloudFormation template: - SOL-633Getting issue details... STATUS
Single Node Quick Launch
In case just want to start a preconfigured single node system as quickly as possible just follow the instruction below:
In case the installation via CloudFormation is not possible (e.g. due to missing user privileges) you can install Exasol using the AWS console or the markeplace page as well. The following guide explains how:
-
SOL-377Getting issue details...
STATUS
Support & Troubleshooting
This offer includes assistance from the Exasol Community (Community Support) and access to the Exasol Solution Center.
For troubleshooting & and information on how to register for community support please refer to - SOL-382Getting issue details... STATUS and to the solution documents listed below.
More Information
Recommendations for using Exasol on AWS
Recommended instance families: m4, m5, r4, r5, c5
Recommended storage: gp2 EBS storage
Backup storage: S3
Minimum size of main memory: 16 GB
Storage Configuration
Instance-integrated hard drives (ephemeral storage) and EBS volumes are supported for data storage.
In a production environment, we recommend using high-available EBS drives, as these provide maximum reliability and durability.
For EBS type we recommend using at least General Purpose SSD (gp2) volumes.For high IO requirements we recommend Provisioned IOPS SSD (io1).
For data backup & restore ( - SOL-354Getting issue details... STATUS as well as data import & export ( - EXASOL-1678Getting issue details... STATUS ) Exasol supports cost-efficient S3 storage.
Exasol AMI: Determine AMI ID and activate AMI for manual launch
The AMI-ID can be found in the AWS Marketplace offering:
Access https://aws.amazon.com/marketplace/pp/B01FXIPXV4 (Pay-As-You-Go, community support only) or https://aws.amazon.com/marketplace/pp/B01IVOPPN8 (Bring-Your-Own-License)
Select "Continue"
Select "Manual Launch"
Select "Accept Software Terms" ( Otherwise you will not be able to succesfully launch the AMI)
The AMI-ID can be found on the "Manual Launch" tab
Release Notes
- EXASOL-2161Getting issue details... STATUS
- EXASOL-2032Getting issue details... STATUS
Upgrade Information
5.0.x - It is not possible to upgrade a 5.0.x AWS installation to a 6.0.x. Please backup the data, install a new cluster, and import data in this case
6.0.1 - if you consider upgrading AWS 6.0.1 to any later version, you need to apply the patch attached to this issue while the nodes are still running. Just upload it through EXAOperation in the Software tab:
-
DOWNLOAD-564Getting issue details...
STATUS
Further Documentation & Tools
For clients, drivers and the standard Exasol manual, please visit the Exasol User Portal
Please note that AWS specific information can be only found in this section and is not contained in the standard user manual.