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
Two different Exasol offerings are available via 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 enterprise support with 24/7 incident management
Please note: The former PAYG offering with community support has been discontinued and been superseded by this offering
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
Advantages
- License is portable across platforms
- Perpetual or subscription licensing
- Raw data based licensing
For more information please contact the Exasol sales team (Contact Form)
(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 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 might be be sufficient and appropriate.
NEW
Configure and deploy an Exasol cluster or single node system using our Cloud Deployment Wizard for public clouds. This tool will guide you through the sizing, configuration and deployment process. Internally it uses and parameterizes our standard CloudFormation templates (see below). After having configured your cluster you can either download the preconfigured CF template or directly open it with the AWS CloudFormation UI to proceed with the deployment proces. In the CloudFormation UI you can once more review and customize all settings.
Setting up a cluster using our CloudFormation templates is as easy as setting up a single node system. Instruction for both setups using CloudFormation templates can be found below (You might also have a look a our Cloud Deployment wizard that guides you through the sizing and configuration process)
Cluster Installation
The recommended database cluster installation method is AWS CloudFormation. The following guide explains step-by-step how to conveniently deploy an Exasol cluster database using an AWS CloudFormation template: - SOL-605Getting issue details... STATUS
Cluster Quick Launch
If you just want to start a preconfigured database 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 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 & Software Updates
Exasol Analytic Database (Single Node and Cluster, Enterprise Support)
The Pay-as-you-go version of Exasol 6.1 Exasol Analytic Database (Single Node and Cluster, Enterprise Support) that can be purchased via the AWS Marketplace includes 24/7 incident management.
After registration the following services are available:
- Access to community
- Access to ticketing system
- Access to updates
- Incident Management 24x7
Please note
- This support offering is only valid for Exasol instances launched using the AWS Marketplace offering Exasol Analytic Database (Single Node and Cluster, Enterprise Support)
- In order to be fully eligible for support you have to register (see below). The registration process may take some days.
- SLAs only apply after successfully completing the onboarding process.
- In case you need support before the registration process has been completed you may already use the "send support request" from below.
Register for Exasol PAYG support for AWS*
Open Support Request*
* Please note that this support offering is only valid for Exasol instances started using the AWS Marketplace offering "Exasol Analytic Database (Single Node and Cluster, Enterprise Support)"
Exasol Analytic Database (Single Node and Cluster, Community Support)
Discontinued product
This version has been discontinued and is no longer available to new customers.
Users of this product should migrate to the current product including support
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.
Cluster Administration
NEW
Our new Web-based Cloud-Management UI is available now.
If you would like to perform one of the following tasks please refer to the Cloud-plugin documentation - SOL-649Getting issue details... STATUS
- Scale-Out (Add nodes): Add one or more nodes to the database cluster and database
- Scale-Up/Down (Change instance type): Change the instance type/model of all data nodes in order to increase or decrease the overall processing power
- Increasing disk storage capacity: Increase the overall storage capacity by enlarging the data volumes of all database nodes.
You might have to update the plugin first. For instructions on how to update or install the plugin please refer to - SOL-640Getting issue details... STATUS
The AMI R6.1.2 already contains the latest Cloud plugin version. There is not need to update it first.
Enhanced Failover Capabilities
Before Exasol 6.1 for AWS a spare node had to be running all the time to provide automatic fail-safety capabilities in case of a node failure.
Starting with 6.1 on AWS failover capabilities are also available if:
- no spare/standby node is configured
- a spare node was configured but suspended (not running)
For Details please refer to - EXASOL-2423Getting issue details... STATUS
Database System Documentation and Further Reading
Loading Data
If you just want to quickly find out how to load data from S3 and other sources into Exasol or how to connect Exasol to the most popular BI tools you should take a look the following guide: Getting Started
Backup/Restore
- SOL-354Getting issue details... STATUS describes how to perform backup and restore operations using S3 ( Additional information on enhanced S3 support can be found in - EXASOL-1752Getting issue details... STATUS and - EXASOL-1958Getting issue details... STATUS )
Full Documentation
You can find the full documentation on using and administrating Exasol in the Exasol User Portal
Furthermore the Solution Center that can also be found in the Exasol User Portal provides all kinds of problem specific guides and HowTos for using, integrating and optimizing Exasol.
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) are supported for test and evaluation purposes only, as data in the instance store is lost when the instance is stopped.
For production environments we recommend using high-available EBS drives, as these provide maximum reliability and durability.
As EBS volume type we recommend using at least General Purpose SSD (gp2) volumes.
For data backup & restore ( - SOL-354Getting issue details... STATUS as well as data import & export ( - EXASOL-1774Getting 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
Upgrade Information
Upgrade/migrate from discontinued PAYG offering with community support to current PAYG offering with enterprise support - Unfortunately it is generally not possible to migrate systems from one AWS Marketplace offering to another one. Please backup the data, install a new cluster, and import data in this case
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
Please note