Cost Optimized HANA DB Solution Integration with RHEL HA
This article describes how to configure Automated HANA System Replication in a cost optimized scenario in a Pacemaker cluster on supported RHEL releases.
The cost optimized scenario supports an additional DEV/QA HANA database on the secondary site, serving client inquiries. Because the resource has to be allocated to the TEST/QA instance, the Production HANA database cannot be preloaded. Before takeover, the TEST/QA instance must be shutdown first. The takeover time is therefore longer than performance optimized.
General steps for installing SAP HANA on RHEL for SAP Solutions on 8.x
- Install minimal RHEL. Use the base application profile
- Register the host to the Red Hat Customer Portal or your local Red Hat Satellite server and subscribe it to the required channels for RHEL for SAP HANA.
- Configure the OS according to the guidelines in SAP Note 2292690 - SAP HANA DB: Recommended OS settings for RHEL 7X/RHEL 8X, the SAP HANA installation guides and the recommendations in this guide.
- Update the system to the latest release within the version range used.
- Install SAP HANA.
- Set up HANA System Replication.
- Configure RHEL High Availability and integrate HANA DB.
Integration of HANA DB cost optimized setup into already configured initial RHEL HA with Stonith and Virtual IP
NodeA:-test1
NodeB:- test2
Primary DB SID :- PH1
QA DB SID :- QH1
DevDB SID :- DH1
Virtual IP :- ClusterIP
visudo and add the below entry for hook :-
# SAPHanaSR-ScaleUp entries for writing srHook cluster attribute
ph1adm ALL=(ALL) NOPASSWD: /usr/sbin/crm_attribute -n hana_PH1_site_srHook_*
Add entry to /hana/shared/(SID)/global/hdb/custom/config/global.ini file :-
[ha_dr_provider_SAPHanaSR]
provider = SAPHanaSR
path = /hana/shared/myHooks
execution_order = 1
[trace]
ha_dr_saphanasr = info
Add SAP HANA Topology :-
pcs resource create SAPHanaTopology_PH1_00 SAPHanaTopology SID=PH1 InstanceNumber=00 \
op start timeout=600 \
op stop timeout=300 \
op monitor interval=10 timeout=600 \
clone clone-max=2 clone-node-max=1 interleave=true
Add SAP Production DB Integration :-
pcs resource create SAPHana_PH1_00 SAPHana SID=PH1 InstanceNumber=00 \
PREFER_SITE_TAKEOVER=true DUPLICATE_PRIMARY_TIMEOUT=7200 AUTOMATED_REGISTER=true \
op start timeout=3600 \
op stop timeout=3600 \
op monitor interval=61 role="Slave" timeout=700 \
op monitor interval=59 role="Master" timeout=700 \
op promote timeout=3600 \
op demote timeout=3600 \
promotable notify=true clone-max=2 clone-node-max=1 interleave=true
Add SAP Dev DB Integration :-
pcs resource create SAPHana_DH1_05 SAPInstance InstanceName=“DH1_HDB05_test1" MONITOR_SERVICES="hdbindexserver|hdbnameserver" START_PROFILE="/usr/sap/DH1/SYS/profile/DH1_HDB05_test1" \
op start interval=0 timeout=600 \
op monitor interval=120 timeout=700 \
op stop interval=0 timeout=300 \
meta priority=100
Add SAP HANA QA DB Integration :-
pcs resource create SAPHana_QH1_10 SAPInstance InstanceName=“QH1_HDB10_test2" MONITOR_SERVICES="hdbindexserver|hdbnameserver" START_PROFILE="/usr/sap/QH1/SYS/profile/QH1_HDB10_test2" \
op start interval=0 timeout=600 \
op monitor interval=120 timeout=700 \
op stop interval=0 timeout=300 \
meta priority=100
Add Constraints :-
pcs constraint order SAPHanaTopology_PH1_00-clone then SAPHana_PH1_00-clone symmetrical=false
pcs constraint colocation add ClusterIP with master SAPHana_PH1_00-clone 2000
pcs constraint order stop SAPHana_QH1_10 then promote SAPHana_PH1_00-clone Mandatory
pcs constraint order stop SAPHana_DH1_05 then promote SAPHana_PH1_00-clone kind=Mandatory
pcs constraint location SAPHana_DH1_05 avoids test1=INFINITY
pcs constraint location SAPHana_QH1_10 avoids test1=INFINITY
pcs constraint colocation Started SAPHana_DH1_05 with ClusterIP -INFINITY
pcs constraint colocation Started SAPHana_QH1_10 with ClusterIP -INFINITY
Configuration Reference Guides
https://access.redhat.com/articles/4079981#123-cost-optimized-7
https://access.redhat.com/articles/3004101
For help planning and designing your Power server environment for HANA
If you plan to have cost optimized HANA DB Solution implemented on Red Hat, talk to IBM Lab Services. We can provide services to configure, set up and demonstrate RHEL HA integration with SAP HANA. If you want to engage IBM Lab Services, you can contact your IBM client rep or reach out to IBM Lab Services directly at ibmsls@us.ibm.com.