Friday, 30 October 2020

Use SLES 15.2 To Automate SAP HANA High Availability

I will talk to you about how SLES HA Automation process and integration work with SAP HANA to facilitate the management of these systems, but also how to get the best of this marriage by leveraging enhanced native SLES tools specifically for SAP platform.

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

What and how to articulate it?


I know you want to go straight to the config part of the solution, but I have to be diligent with you and at least show some updates from the components used in my previous blog since those updates/upgrades are the essences for the rest of the documentation.

VMware Platform


vSphere 6.0 to 6.7 – vSphere 6.7 contains major improvements which provide such as 2x better performance, 3x reduction in memory usage as well as 3x faster operation relating to VDRS.

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

FreeNAS Platform


FreeNAS 9.0 to 11.3-U5 – Not just a virtual appliance, the latest version of FreeNAS offer the ability to add virtual machines, Docker, and cloud synchronization support, it includes a mobile-friendly Angular web interface, improved iocage plugin system, real-time APIv2, and synchronization with many more cloud storage providers.

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

Now that I have talked about the 2 main pieces, let’s dive into SLES For SAP 15 SP2, as I mentioned earlier this revision of SLES provides an embedded mechanism to set up and configure SAP HANA to run in HA mode with auto-failover (scale-up).

I will not cover how to install SLES for SAP step by step neither how to install SAP HANA, but will cover the detail to realize the setup.

Operating System Core Install


By design, SLES 15.2 media gives you the ability to install your OS according to a specific product in order to install the necessary extension and module

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

The Basesystem Module and Server Application Module are selected de facto, make sure to select SAP Application Module which will auto-select the SLES HA Extension

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

Your System Role is an important point; however, you can choose only one role.

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

A very important point, that people don’t think about often, is the NTP server. You need to make sure to sync your server time.

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

Get your system ready for HA

Because the environment needs to be configured as a cluster, to guaranty the consistency of the following an SBD device needs to be attached on both server parts of the cluster.

This is where I use FreeNAS to create and share an iSCSI bloc to be attached

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

Now in order to leverage the SLES feature for SAP HANA, specifics package needs to be deployed since they don’t come natively in the core install if you don’t explicitly select them. The yast2-sap-ha for the cluster setup, and the yast2-hana-update to maintain your SAP system within the cluster.

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

Ready to run the procedure


My DNS is updated with the virtual ip and hostname given for my cluster

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

Both SAP Hana is installed according to the recommendation, my primary system is backed up

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

On my primary Hana I have created a key for backup

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

The PKI SSF data and file has been copied from the primary to the secondary node

◉ scp -p /usr/sap/HB0/SYS/global/security/rsecssfs/data/SSFS_HB0.DAT hb0adm@hanadb03:/usr/sap/HB0/SYS/global/security/rsecssfs/data/
◉ scp -p /usr/sap/HB0/SYS/global/security/rsecssfs/key/SSFS_HB0.KEY hb0adm@hanadb03:/usr/sap/HB0/SYS/global/security/rsecssfs/key/

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

Now from the primary, as root, I invoke “yast2” and select “HA Setup for SAP Products”

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

Select the “Scale UP: Performance-optimized”

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

On the communication layer, provide the ip range from the nic card to be used.

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

Edit both server ips and hostname and also make sure to select “Append to /etc/hosts”, because of the root key exchange between server, the password will be asked

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

The NTP server configured earlier should appear

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

It the following screen, I need to add the SBD device attached to the server

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

How to check the iSCSI? run the command “fdisk -l”

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

For the Watchdog, I will choose “softdog”

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

In this last step, I provide the system information such, SID, instance number, VIP, the site name and the behavior for taking over and auto registration

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

Review the config and hit Install

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

During the process, some package will be required to be installed

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

One completed a review of the log to make sure no error encored and click finish

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

Validate the cluster and SAP HANA replication, to do so I will open the HAWK interface but using the virtual hostname of my cluster on port 7630

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

At the OS level if I run the “crm status” the status of the resources will show green

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

Finally, I will register my cluster in my Hana Cockpit

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

I can see that my hanadb02 node the primary used as per the Cockpit

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

Test the failover


I now test the failover process by killing the hb0adm process on the hanadb02 (node1) and check the takeover on Hana Cockpit and the OS level (because HAWK is only deployed on node1)
I my primary node (hanadb02) I run my killer command 😉 “pkill -9 HB0”

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

On the logical order, after the pkill command is invoked, I run the “crm status” command and I can see that hanadb02 resources are stopped

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

On the Hana Cockpit, I can see that the replication is broken on Site1

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

After a few second the takeover is completed and we can see the hanadb03 acting as the master now

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

And finally, the Hana Cockpit shows the hanadb03 as well the master after refreshing without changing anything

SAP HANA Exam Prep, SAP HANA Tutorial and Material, SAP HANA Certifications

No comments:

Post a Comment