Enterprise Linux

Cost Optimized HANA DB Solution Integration with RHEL HA

By Wasif Mohammad posted Fri July 09, 2021 11:12 AM

  

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.

0 comments
115 views

Permalink