IT-Conductor Blog

Tips for HANA Monitoring of HA/DR with Virtual Host Failover

Posted by Terry Kempis on Sep 26, 2018 4:41:13 PM

IT-Conductor HANA Monitoring HA/DR Virtual Host Failover

Introduction

In HANA HA/DR design, a database virtual host is used as the logical SQL connection point for applications such as Netweaver ABAP or JAVA.  For SAP monitoring management, automation of normal state HANA monitoring is only half the coverage, the failover event and post-failover monitoring should also be automated.

The last presentation on HANA was on HA/DR and System Replication monitoring with logreplay_readaccess mode – showing how the secondary systems are also monitored

This presentation focuses on ITC’s monitoring of the HANA HA/DR when the HANA system replication (HSR) is not defined with operation mode ‘logreplay_readaccess’, using the ’virtual hostname’.

  Sites normally use virtual hostname for failover/takeover purposes.

In prior posts, we have covered several topics on HANA HA/DR, System Replication, Scale-out and Dynamic Tiering.  Please visit these for additional background:

HANA Landscape

IT-Conductor HANA Monitoring HA/DR Landscape

Registering a HANA DB to ITC (1) - Physical

IT-Conductor HANA Monitoring Registering Site 1

Registering a HANA DB to ITC (2) - Virtual

IT-Conductor HANA Monitoring Registering Site 1 Alternative Using Virtual Host

Registering a HANA DB to ITC (3)

Linux Virtual Host and IP Setup

Registering the Linux host

IT-Conductor HANA Monitoring Registering Linux Hosts

Registering a HANA DB to ITC (4)

IT-Conductor HANA Monitoring Post-Discovery

Registering a HANA DB to ITC (5)

IT-Conductor HANA Monitoring Replication

System Takeover from Secondary System (1)

Performing a system takeover from secondary system, either through HANA Cockpit or hdbnsutil command

IT-Conductor HANA Monitoring System Takeover

System Takeover from Secondary System (2) - Simulating the Virtual Host Failover

This step can be automated with Linux Pacermaker

Manual failover of virtual host

System Takeover from Secondary System (3)

IT-Conductor HANA Monitoring Post-Failover Automated Monitoring

Summary – HA/DR and SR monitoring

  • IT-Conductor can monitor both the primary and secondary sides of an HA/DR landscape is configured with SR operation_mode ‘logreplay_readaccess’  - see HA/DR and System Replication monitoring with logreplay_readaccess mode

  • If the landscape is not defined with logreplay_readaccess, ITC can still monitor the primary system AND automatically ‘shifts’ its monitoring to the secondary system after a takeover,  by registering the objects (HANA DB, Linux host) using virtual hostname


Want to try the best cloud-based agent-less HANA Monitoring platform?
IT-Conductor Signup

 

Terry Kempis

Written by Terry Kempis

Terry is a Senior SAP Basis Engineer with 15 years expertise working with very large SAP infrastructure (more than 230 SAP SIDs). He specializes in areas of performance, upgrades, unicode conversion, installation, DB2, BW, TREX and HANA migrations.

Topics: SAP HANA Monitoring, SAP HANA, HANA Monitoring, SAP HANA System Replication

FREE IT-Conductor Trial to Monitor SAP

Posts by Topic

see all

Recent Posts

Subscribe to Email Updates