SAP HANA Dynamic Tiering Setup

What is Dynamic Tiering?

The SAP HANA dynamic tiering option is a native big data solution for SAP HANA. The dynamic tiering option adds smart, disk-based extended storage to your SAP HANA database. Dynamic tiering enhances SAP HANA with large volume, warm data management capability.

The dynamic tiering option adds the extended storage service to your SAP HANA system. You use the extended storage service to create the extended storage store and extended tables. Extended tables behave like all other HANA tables, but their data resides in the disk-based extended storage store.

Your application automatically determines which tier to save data to: the SAP HANA in-memory store (the hot store), or extended storage (the warm store). When you use dynamic tiering to place hot data in SAP HANA in-memory tables, and warm data in extended tables, highest value data remains in memory, and cooler less-valuable data is saved to the extended store. This can reduce the size of your in-memory database.

[Credits: Dynamic_Tiering_Option_Master_Guide_en]

Dynamic Tiering Landscape Setup:

Dynamic Tiering feature [SAP HANA Extended Storage feature] is supported in since HANA SP09.

This blog is about My Experience on Dynamic Tiering Setup. This blog will helpful for you to make the Dynamic Tiering setup in your landscape.

I have two Linux Hosts [I named as LinuxHost1, LinuxHost2] with same configuration and same root user and password.

HANA Server will be installed on LinuxHost1 and ES Server will be installed on LinuxHost2.            
Both the components cannot be installed on same Linux machine.
Shared File systems:
The following file systems in the two Linux hosts should have shared persistence.
[I am going to Install HANA System with SID: HDT]

1. /hana/shared
2. /hana/data/HDT
3. /hana/log/HDT
4. /hana/data_es/HDT
5. /hana/log_es/HDT

Installation Parameters:

I install HANS System using batch file. [Batch file is stored in LinuxHost1] [File Format *.cfg]
The following Parameters, especially we have to mention for Dynamic Tiering Setup.

1. addhosts:
We have to mention the details of LinuxHost2 and its role.

2. Component_dirs:

In Component_dirs parameter,

we have to mention location of HANA DB server Installation File package and HANA Option (Dynamic Tiering) Installation File package.

The format is Component_dirs = <HANA_Installation_Path>, <HANA_Option_Installation_path> comma separates both the installation packages.

I tell how to find out the location of installation package:

We have to choose the folder path where we have manifest file:

<Component_dirs>: Location of <HANA_Installation_Package>:

<Component_dirs>: Location of <HANA_Option_DynamicTiering_Path>

So these two folder paths have been mentioned in <component_dirs> parameter

3. Other Required Parameters:

Then we have to mention all other required parameters in the batch file (cfg file) like SID, Instance Number, DB_Mode (Single Container), sapadm password, system administrator (<SID>adm) password, system_user_password, user_id, group_id, sapmnt path, data path and log path. 

Installation Process:

Once Configuration file is ready, we have to start Installation using hdblcm with configuration file.

During Installation Process, To be Installed Components will be listed.

Components are

1. Server (SAP HANA DB)
2. ES (Dynamic Tiering).

Select the option all, which will install HANA Server in LinuxHost1 and Dynamic Tiering setup [ES Server] in LinuxHost2.

Installation Process will be started.

LinuxHost2 will become additional host and will act as Extended Storage Server.

Once Installation Process Completed, HANA Server is installed in LinuxHost1 and Dynamic Tiering setup [ES Server] is installed in LinuxHost2.

List of Process:

Once Installation Completed Successfully, I am going to check the running process in two Hosts.

Linux Host1: (HANA DB)

Name server, preprocessor, compile server, index server, statistics server, xs engine are running in Linux server1.

Linux server2: (ES)

Name server and ES server are running in Linux server 2.

Studio:

I am Connecting HDT System from the Studio. It will display list of servers from Both the Hosts.

How to Make Dynamic Tiering is running:

After Installation completed, If we check the system, We can see the Information that Dynamic Tiering is Installed But not running.

Execute the query,

SELECT * from M_SERVICES

Co-ordinater Type for esserver is NONE.

So Dynamic Tiering is Installed But not running. How can we make Dynamic Tiering is running?

Create Extended Storage in LinuxHost2:

To make Dynamic Tiering is running, we have to create Extended Storage in LinuxHost2.

Execute the following SQL Query in HDT System.

CREATE EXTENDED STORAGE AT '<full_host_name_of_Linuxhost2>' size 10 GB ENABLE DELTA

Now check M_Services:

Now Co-coordinator Type for esserver is MASTER and Dynamic Tiering is running

Extended Storage Table Creation:

We have to use <EXTENED STORAGE> Clause in SQL Query to create Extended Storage Table.

SQL Query:

CREATE TABLE "SHANMUGAVEL".t2(A INT, B INT NULL, C INT NOT NULL) USING EXTENDED STORAGE;

Extended Storage Table T2 is created.

Insert:

Now I am inserting the data to Extended Storage Table and It will be stored in Extended storage 

Insert into "SHANMUGAVEL"."T2" values (1, 1, 1)

Select:

I am checking Data Preview from Extended Storage Table.

Source: scn.sap.com