Search

Top 60 Oracle Blogs

Recent comments

Getting started with #Exasol on #AWS

It’s amazingly easy to run an Exasol Cluster on Amazon Web Services (AWS).

Subscribe Exasol in AWS marketplace

After having registered and having logged in to your AWS account, go to the AWS marketplace and search for Exasol:

https://uhesse.files.wordpress.com/2019/11/aws01.png?w=1240&h=530 1240w, https://uhesse.files.wordpress.com/2019/11/aws01.png?w=150&h=64 150w, https://uhesse.files.wordpress.com/2019/11/aws01.png?w=300&h=128 300w, https://uhesse.files.wordpress.com/2019/11/aws01.png?w=768&h=328 768w, https://uhesse.files.wordpress.com/2019/11/aws01.png?w=1024&h=437 1024w" sizes="(max-width: 620px) 100vw, 620px" />

Click on the Exasol Single Node and Cluster BYOL link and then on Continue to Subscribe:

https://uhesse.files.wordpress.com/2019/11/aws02.png?w=1240&h=282 1240w, https://uhesse.files.wordpress.com/2019/11/aws02.png?w=150&h=34 150w, https://uhesse.files.wordpress.com/2019/11/aws02.png?w=300&h=68 300w, https://uhesse.files.wordpress.com/2019/11/aws02.png?w=768&h=174 768w, https://uhesse.files.wordpress.com/2019/11/aws02.png?w=1024&h=232 1024w" sizes="(max-width: 620px) 100vw, 620px" />

After having reviewed the T&C, click on Accept Terms. It shows this message afterwards:

https://uhesse.files.wordpress.com/2019/11/aws03.png?w=1240&h=540 1240w, https://uhesse.files.wordpress.com/2019/11/aws03.png?w=150&h=65 150w, https://uhesse.files.wordpress.com/2019/11/aws03.png?w=300&h=131 300w, https://uhesse.files.wordpress.com/2019/11/aws03.png?w=768&h=335 768w, https://uhesse.files.wordpress.com/2019/11/aws03.png?w=1024&h=446 1024w" sizes="(max-width: 620px) 100vw, 620px" />

Create Key Pair

Now login to the AWS Management Console, select a region close to your location and open the EC2 Dashboard. Click on Key Pairs:

https://uhesse.files.wordpress.com/2019/11/aws04.png?w=1238&h=482 1238w, https://uhesse.files.wordpress.com/2019/11/aws04.png?w=150&h=58 150w, https://uhesse.files.wordpress.com/2019/11/aws04.png?w=300&h=117 300w, https://uhesse.files.wordpress.com/2019/11/aws04.png?w=768&h=299 768w, https://uhesse.files.wordpress.com/2019/11/aws04.png?w=1024&h=399 1024w" sizes="(max-width: 620px) 100vw, 620px" />

Click on Create Key Pair now and enter a name for the new Key Pair, then click on Create:

https://uhesse.files.wordpress.com/2019/11/aws05.png?w=1240&h=494 1240w, https://uhesse.files.wordpress.com/2019/11/aws05.png?w=150&h=60 150w, https://uhesse.files.wordpress.com/2019/11/aws05.png?w=300&h=120 300w, https://uhesse.files.wordpress.com/2019/11/aws05.png?w=768&h=306 768w, https://uhesse.files.wordpress.com/2019/11/aws05.png?w=1024&h=408 1024w" sizes="(max-width: 620px) 100vw, 620px" />

Now you are ready to use the Exasol Cloud Deployment Wizard. Stay logged in with AWS Management Console as you will be routed back there by the Deployment Wizard soon.

Using the Cloud Deployment Wizard

Put this URL into your browser: https://cloudtools.exasol.com/ and click on AWS then:

https://uhesse.files.wordpress.com/2019/11/aws06.png?w=1238&h=562 1238w, https://uhesse.files.wordpress.com/2019/11/aws06.png?w=150&h=68 150w, https://uhesse.files.wordpress.com/2019/11/aws06.png?w=300&h=136 300w, https://uhesse.files.wordpress.com/2019/11/aws06.png?w=768&h=349 768w, https://uhesse.files.wordpress.com/2019/11/aws06.png?w=1024&h=465 1024w" sizes="(max-width: 620px) 100vw, 620px" />

Select a region close to your location and click on Continue:

https://uhesse.files.wordpress.com/2019/11/aws07.png?w=1240&h=622 1240w, https://uhesse.files.wordpress.com/2019/11/aws07.png?w=150&h=75 150w, https://uhesse.files.wordpress.com/2019/11/aws07.png?w=300&h=151 300w, https://uhesse.files.wordpress.com/2019/11/aws07.png?w=768&h=385 768w, https://uhesse.files.wordpress.com/2019/11/aws07.png?w=1024&h=514 1024w" sizes="(max-width: 620px) 100vw, 620px" />

Click on Advanced Configuration and specify

https://uhesse.files.wordpress.com/2019/11/aws08.png?w=1240&h=782 1240w, https://uhesse.files.wordpress.com/2019/11/aws08.png?w=150&h=95 150w, https://uhesse.files.wordpress.com/2019/11/aws08.png?w=300&h=189 300w, https://uhesse.files.wordpress.com/2019/11/aws08.png?w=768&h=484 768w, https://uhesse.files.wordpress.com/2019/11/aws08.png?w=1024&h=645 1024w" sizes="(max-width: 620px) 100vw, 620px" />

License Model Bring-your-own-license, System Type Enterprise Cluster, Instance Family Memory Optimized, Instance Type r5, Instance Model r5 large, Number of DB Node 1 then click Continue.

BYOL works without license file with a limit of 20 GB memory for the database. Means no costs are charged by Exasol (But by Amazon) for this environment.

Select create new VPC and click on Launch Stack on this page now:

https://uhesse.files.wordpress.com/2019/11/aws09.png?w=150&h=118 150w, https://uhesse.files.wordpress.com/2019/11/aws09.png?w=300&h=237 300w, https://uhesse.files.wordpress.com/2019/11/aws09.png?w=768&h=606 768w, https://uhesse.files.wordpress.com/2019/11/aws09.png 942w" sizes="(max-width: 620px) 100vw, 620px" />

Using CloudFormation

This takes you to the Quick create stack page of CloudFormation in AWS Management Console:

https://uhesse.files.wordpress.com/2019/11/aws10.png?w=1238&h=612 1238w, https://uhesse.files.wordpress.com/2019/11/aws10.png?w=150&h=74 150w, https://uhesse.files.wordpress.com/2019/11/aws10.png?w=300&h=148 300w, https://uhesse.files.wordpress.com/2019/11/aws10.png?w=768&h=380 768w, https://uhesse.files.wordpress.com/2019/11/aws10.png?w=1024&h=506 1024w" sizes="(max-width: 620px) 100vw, 620px" />

Enter these details on the page:

Stack name

Key Pair (select the key pair created previously)

SYS User Password

ADMIN User Password

Public IPs (true)

Tick the acknowledge box and click on Create stack

Now go to the EC2 details page and copy the Public IP of the management node:

https://uhesse.files.wordpress.com/2019/11/aws11.png?w=1240&h=630 1240w, https://uhesse.files.wordpress.com/2019/11/aws11.png?w=150&h=76 150w, https://uhesse.files.wordpress.com/2019/11/aws11.png?w=300&h=153 300w, https://uhesse.files.wordpress.com/2019/11/aws11.png?w=768&h=391 768w, https://uhesse.files.wordpress.com/2019/11/aws11.png?w=1024&h=521 1024w" sizes="(max-width: 620px) 100vw, 620px" />

Put that with an https:// prefix into a browser and click on Advanced:

https://uhesse.files.wordpress.com/2019/11/aws12.png?w=1240&h=752 1240w, https://uhesse.files.wordpress.com/2019/11/aws12.png?w=150&h=91 150w, https://uhesse.files.wordpress.com/2019/11/aws12.png?w=300&h=182 300w, https://uhesse.files.wordpress.com/2019/11/aws12.png?w=768&h=466 768w, https://uhesse.files.wordpress.com/2019/11/aws12.png?w=1024&h=621 1024w" sizes="(max-width: 620px) 100vw, 620px" />

Then you should see a progress bar like this:

https://uhesse.files.wordpress.com/2019/11/aws13.png?w=1238&h=646 1238w, https://uhesse.files.wordpress.com/2019/11/aws13.png?w=150&h=78 150w, https://uhesse.files.wordpress.com/2019/11/aws13.png?w=300&h=157 300w, https://uhesse.files.wordpress.com/2019/11/aws13.png?w=768&h=401 768w, https://uhesse.files.wordpress.com/2019/11/aws13.png?w=1024&h=534 1024w" sizes="(max-width: 620px) 100vw, 620px" />

That screen changes after about 30 Minutes to the EXAoperation login screen.

Login as user admin with the password, you specified previously on the CloudFormation Quick create stack page. There should be a database running:

https://uhesse.files.wordpress.com/2019/11/aws14.png?w=1240&h=374 1240w, https://uhesse.files.wordpress.com/2019/11/aws14.png?w=150&h=45 150w, https://uhesse.files.wordpress.com/2019/11/aws14.png?w=300&h=90 300w, https://uhesse.files.wordpress.com/2019/11/aws14.png?w=768&h=232 768w, https://uhesse.files.wordpress.com/2019/11/aws14.png?w=1024&h=309 1024w" sizes="(max-width: 620px) 100vw, 620px" />

As you can see now, you have a database, a remote archive volume using an Amazon S3 bucket ready for backup & restore and a log service to monitor your system.

This database is limited to 20 GB memory only unless a license file is uploaded to the license server aka management node. For educational purposes, I don’t need more.

Use Elastic IPs

The public IPs of your data nodes will change upon every restart, which is probably not convenient.
Therefore, click on Elastic IPs in the EC2 dashboard, then click on Allocate new address:

https://uhesse.files.wordpress.com/2019/11/aws15.png?w=1240&h=382 1240w, https://uhesse.files.wordpress.com/2019/11/aws15.png?w=150&h=46 150w, https://uhesse.files.wordpress.com/2019/11/aws15.png?w=300&h=92 300w, https://uhesse.files.wordpress.com/2019/11/aws15.png?w=768&h=236 768w, https://uhesse.files.wordpress.com/2019/11/aws15.png?w=1024&h=315 1024w" sizes="(max-width: 620px) 100vw, 620px" />

Select Amazon pool then click on Allocate:

https://uhesse.files.wordpress.com/2019/11/aws16.png?w=1240&h=428 1240w, https://uhesse.files.wordpress.com/2019/11/aws16.png?w=150&h=52 150w, https://uhesse.files.wordpress.com/2019/11/aws16.png?w=300&h=104 300w, https://uhesse.files.wordpress.com/2019/11/aws16.png?w=768&h=265 768w, https://uhesse.files.wordpress.com/2019/11/aws16.png?w=1024&h=354 1024w" sizes="(max-width: 620px) 100vw, 620px" />

Click on the IP on the following screen:

https://uhesse.files.wordpress.com/2019/11/aws17.png?w=150&h=44 150w, https://uhesse.files.wordpress.com/2019/11/aws17.png?w=300&h=87 300w, https://uhesse.files.wordpress.com/2019/11/aws17.png?w=768&h=223 768w, https://uhesse.files.wordpress.com/2019/11/aws17.png?w=1024&h=297 1024w, https://uhesse.files.wordpress.com/2019/11/aws17.png 1026w" sizes="(max-width: 620px) 100vw, 620px" />

Select the action Associate address on the next screen:

https://uhesse.files.wordpress.com/2019/11/aws18.png?w=150&h=54 150w, https://uhesse.files.wordpress.com/2019/11/aws18.png?w=300&h=108 300w, https://uhesse.files.wordpress.com/2019/11/aws18.png?w=768&h=276 768w, https://uhesse.files.wordpress.com/2019/11/aws18.png 777w" sizes="(max-width: 620px) 100vw, 620px" />

Select the data node from the Select instance pull down menu and click on Associate:

https://uhesse.files.wordpress.com/2019/11/aws19.png?w=150&h=69 150w, https://uhesse.files.wordpress.com/2019/11/aws19.png?w=300&h=138 300w, https://uhesse.files.wordpress.com/2019/11/aws19.png?w=768&h=353 768w, https://uhesse.files.wordpress.com/2019/11/aws19.png?w=1024&h=471 1024w, https://uhesse.files.wordpress.com/2019/11/aws19.png 1137w" sizes="(max-width: 620px) 100vw, 620px" />

Close the next screen and go to the EC2 instance page. You should see the elastic IP assigned to the data node there:

https://uhesse.files.wordpress.com/2019/11/aws20.png?w=1240&h=534 1240w, https://uhesse.files.wordpress.com/2019/11/aws20.png?w=150&h=65 150w, https://uhesse.files.wordpress.com/2019/11/aws20.png?w=300&h=129 300w, https://uhesse.files.wordpress.com/2019/11/aws20.png?w=768&h=331 768w, https://uhesse.files.wordpress.com/2019/11/aws20.png?w=1024&h=441 1024w" sizes="(max-width: 620px) 100vw, 620px" />

Connect with a SQL Client to your Exasol database on AWS

This is how that looks with DbVisualizer:

https://uhesse.files.wordpress.com/2019/11/aws21.png?w=150 150w, https://uhesse.files.wordpress.com/2019/11/aws21.png?w=300 300w" sizes="(max-width: 510px) 100vw, 510px" />

And that’s it: Now you have an Exasol 1+0 cluster running on AWS. That’s not the same as a single node system, because this 1+0 cluster can be enlarged with more data nodes. I will show how to do that in future posts.

A word about costs: Instead of using our corporate AWS account, I registered myself to see how much that will take. It was less than 80 Euro with a 2+1 cluster environment I used for about one month, shutting down the EC2 instances whenever I didn’t need them for testing and for creating courseware. It should be well below 10 Euro per day with the very moderate resource consumption configured for the environment subject to my postings.

Stay tuned for some more to come about Exasol on AWS </p />
</p></div>

    	  	<div class=