Home > Workload Solutions > SAP > Guides > SAP HANA TDI Guides > Dell Validated Design for SAP HANA TDI with Dell PowerVault ME5 Storage > Introduction
To install an SAP HANA scale-out cluster on PowerVault ME5 systems, you must:
The configuration example in this guide assumes that the following basic installation and configuration operations are complete on the SAP HANA nodes:
Note: SAP HANA can be installed only on certified server hardware. A certified SAP HANA expert must perform the installation.
After all the file systems are mounted, you are ready to install the SAP HANA scale-out cluster. The Dell engineering example uses the hdblcm tool to install the SAP HANA 2+1 scale-out cluster. For more information, see the SAP HANA Studio Installation and Update Guide.
After the installation DVD ISO file has been extracted to a shared software-repository file system that is mounted on all hosts, you are ready to begin the installation.
Deploying an SAP HANA multinode scale-out cluster on FC-connected systems requires the SAP HANA storage connector fcClient or fcClientMpath. The storage connector is responsible for mounting and unmounting the persistence (data and log) to the SAP HANA worker nodes.
The storage connector also writes SCSI-3 persistent reservations (PRs) to the devices. The Linux sg_persist or mpathpersist command starts an operation known as I/O fencing, which ensures that only one SAP HANA worker host has simultaneous access to data and log devices.
With SAP HANA SP05 Rev 53, SAP released a newer version of the storage connector fcClientMpath. The new version uses the command mpathpersist rather than sg_persist. The mpathpersist command puts the reservations on the devices, enabling device paths to be added while the mount process is ongoing, whereas sg_persist puts the reservations on the device paths when mounting the devices. Paths cannot be added during the mount process, and a remount is necessary. When new device paths are added, PowerVault ME5 storage can be fully supported for SAP HANA scale-out deployments in physical environments with SAP autohost failover.
To use the fcClientMpath connector:
The keys are added during the mount process to /etc/multipath/prkeys.
For more information about the SAP HANA scale-out installation, the storage connector, and the global.ini file, see the following documents on the SAP Help Portal:
The installation uses the global.ini file to describe the SAP HANA storage partitions and the storage connector. The SAP HANA certified Dell storage platforms use fcClient, which is part of the SAP software distribution.
To prepare the file:
CAUTION: Do not alter the name of the global.ini file.
Note: Larger SAP HANA scale-out installations require additional partition entries.
SAP HANA SPS 07 introduced the SAP HANA Database Lifecycle Manager to provide the efficiency of installing all components at a time while automating the installation. The following example uses hdblcm to install the SAP HANA 2+1 scale-out cluster.
After the SAP HANA installation DVD ISO file has been extracted into the HDB_LCM_LINUX_X86_64 directory, prepare the installation parameters file:
cd /<installation media>/DATA_UNITS/HDB_LCM_LINUX_X86_64
./hdblcm --action=install --dump_configfile_template=ME5_install.cfg
Directory root to search for components
component_root=/SAPShare/software/SAP_HANA2SPS06IM/
Components ( Valid values: all | client | es | ets | lcapps | server | smartda | streaming | rdsync | xs | studio | afl | pos | sal | sca | sop | trd | udf )
components=server,client
Installation Path ( Default: /hana/shared )
sapmnt=/hana/shared
Local Host Name ( Default: server06 )
hostname=hana01
Directory containing a storage configuration
storage_cfg=/hana/shared/ME5_cfg
Note: The storage_cfg parameter points to the directory in which you have placed the customized global.ini file.
SAP HANA System ID
sid=ME5
Instance Number
number=00
# System Administrator User ID
userid=1001
ID of User Group (sapsys)
groupid=79
Action to be performed ( Default: exit; Valid values: install | update | extract_components )
action=install
Additional Hosts
addhosts=hana02:storage_partition=2:role=worker,hana03:role=standby
Note: The Additional Hosts parameter describes the additional hosts and their roles in the scale-out installation.
You can also use encrypted passwords. For more information, see the SAP HANA Studio Installation and Update Guide.
The hdblcm installation procedure prompts you for any missing passwords or parameters.
After you have created and customized the global.ini file and the installation parameters file, start the installation by running the following command:
./hdblcm --action=install –-configfile=ME5_Install.cfg
Postinstallation configuration
The base layer of SAP HANA provides two file I/O interfaces:
You can configure the SAP HANA file I/O layer to optimize file I/O for a specific file system and storage system.
Note: The Linux XFS file system is used on all Dell storage volumes for the SAP HANA persistence.
SAP HANA 1.0
After the initial SAP HANA installation is complete, set the parameters by running the SAP HANA hdbparam command in the Linux shell as <sid>adm:
su - <sid>adm
hdbparam –p # lists current parameter setting
hdbparam –-paramset fileio [DATA].max_parallel_io_requests=256
hdbparam –-paramset fileio [LOG].max_parallel_io_requests=256
hdbparam –-paramset fileio [DATA].max_submit_batch_size=256
hdbparam –-paramset fileio [LOG]. max_submit_batch_size=256
SAP HANA 2.0
Effective from SAP HANA 2.0, the hdbparam command-line tool has been deprecated. Instead, the parameters are defined as normal parameters in global.ini > [fileio]. Using the SQL console in the SAP HANA Cockpit or SAP HANA Studio, set the parameters in the global.ini file by running the following commands:
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio','max_parallel_io_requests[DATA]') = '256';
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio','max_parallel_io_requests[LOG]') = '256';
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio','max_submit_batch_size[DATA]') = '256';
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('fileio','max_submit_batch_size[LOG]') = '256';
The following figure shows what the fileio section of global.ini looks like in the SAP HANA Studio after the parameters are set:
All other parameters are set by default during the installation. For more information, see SAP Note 2399079: Elimination of hdbparam in SAP HANA 2 (access requires SAP user credentials).