If you want to use HANA express edition on aws you probably want to install your own instance to get familiar with SAP HANA installation on the cloud and get more control over your configurations and application deployments.
Follow the below blog to install you free HANA expresses edition and make it accessible from the internet. Most of the steps are very straight forward and it will take you 3-4 hours to download and install.
1. Download the HANA express binary
Get yourself familiar with SAP HANA, express edition, and download the binary version “hxe.tgz” follow this link.
Chose S3 service from aws console.
Create a new S3 bucket “hanabag” or of any name you want.
Open the bucket and upload the hxe.tgz to S3 bucket
Add files to upload the binaries to the bucket.
You will see the uploaded in the S3 online storage bucket
2. Create the EC2 instance
Follow my blog to create a new EC2 instance
Size : m4.xlarge (16 GB RAM) — > HANA express will not install on 4 and 8GB RAM instance .
File system : root partition 50 GB — > 50 GB EBS General Purpose SSD (gp2) volumes for root
For simplicity , I have used root partition for installation.
You can also create a separate partition /hana of 50 GB .
3. Copy installation files from S3 to EC2.
Login into the putty console and create a directory /hana/download Copy the installation files from s3 bucket.
#aws s3 cp s3://hanabag/hxe.tgz .
Untar the installation file
#tar -xvf hxe.tgz
4. Run HANA installation
Install the missing library or else installation will fail somewhere it between .
#yast2 -i libltdl7
Run installation with below command. The installation is pretty straightforward.
sudo ./hdblcm -s HXE -H <external hostname> –hdbinst_server_import_content=off
Summary before execution:
SAP HANA Components Installation
Remote Execution: ssh
Installation Path: /hana/shared
Local Host Name: ip-172-31-18-186
SAP HANA System ID: HXE
Instance Number: 00
Database Mode: multiple_containers
Database Isolation: low
System Usage: development
Location of Data Volumes: /hana/data/HXE
Location of Log Volumes: /hana/log/HXE
Directory containing custom configurations: /hana/download/HANA_10_DEE/DATA_UNITS/HDB_SERVER_LINUX_X86_64/configurations/custom
Certificate Host Names: ip-172-31-18-186 -> ip-172-31-18-186
System Administrator Home Directory: /usr/sap/HXE/home
System Administrator Login Shell: /bin/bash
System Administrator User ID: 1001
ID of User Group (sapsys): 79
Restart system after machine reboot?: Yes
SAP HANA Database
Install version 1.00.122.01.1470046197
SAP HANA AFL (incl.PAL,BFL,OFL,HIE)
Do not install
Do you want to continue? (y/n): y
You have installed HXE system with HDB00 instance.
Check the status of hana with HDB info command.
5. Set for accessing SAP HANA from outside the AWS network. (Optional)
A public DNS record is created to access your ec2 instance from outside world (from outside Amazon VPC. But this is not a permanent record. Every time you reboot ec2 instance a new Public DNS record is created and associated with it.
For this purpose, we use Elastic IP. An Elastic IP address is a public IP address, which is reachable from the Internet. If your instance does not have a public IP address, you can associate an Elastic IP address with your instance to enable communication with the Internet; for example, to connect to your instance from your local computer.
- Open the Amazon VPC console at https://console.aws.amazon.com/vpc/.
- In the navigation pane, choose Elastic IPs.
- Click on “Allocate New Address”
- Right click “Create association” and select the new EC2 instance created.
- Make entry of this elastic IP in your /etc/hosts file to replace 127.0.0.0
- Now if you have a registered Public domain , you can redirect to elastic IP address.
You can permanently use this IP address or the Public domain address to reach your installation from your internet.
What will AWS instance and storage Cost ?
Consider going through the free tier usage faq.
All cost are region specific , below I have considered US East (N. Virginia) region.
EC2 – Cost
Pricing is per instance-hour consumed for each instance, from the time an instance is launched until it is terminated or stopped. Each partial instance-hour consumed will be billed as a full hour.
16 GB instance m4.xlarge is NOT under free tier . You will be paying around 5.8 $ for a full day of usage. So consider shutting down your instance when not in use.
EBS – Cost
Free tier covers 30 GB of Amazon Elastic Block Storage in any combination of General Purpose (SSD) or Magnetic, plus 2 million I/Os (with EBS Magnetic) and 1 GB of snapshot storage.
You can choose various type of storage while creating the EC2 instance. I usually use the default option i.e. SSD2
Even if your EC2 is stopped , you will still be paying for the EBS storage attached to your instance.
Elastic IP – Cost
You will be charged $0.005/hour only if the instance associated with it is not running or if you have reserved an elastic IP and not associated with any running EC2.