Thursday, 31 October 2019

Hana Database High Availability using Shared Storage/ non-Shared Storage

There are two type of Storage while using HANA High Availability multi host functionality

1:  Shared Storage


A shared storage subsystem, which is accessed using file systems such as NFS or IBM's
GPFS, makes it easy to ensure that the standby host has access to all active host files in the
system. In a shared storage solution, the externally attached storage subsystem devices can
provide dynamic mount points for hosts.Since shared storage subsystems vary in their handling of fencing.

In Shared storage below file system are shared as shown  in below image

/hana/shared/SID/
/hana/log
/hana/backup






















Non-Shared Storage

It is also possible to assign every SAP HANA host a separate storage, which has nothing
mounted except the shared area. A SAN storage must be used in combination with the SAP
Fiber Channel Storage Connector, which SAP HANA offers storage technology vendors.
During failover, SAP HANA uses the storage connector API to tell the storage device driver to
re-mount the required data and logs volumes to the standby host and fence off the same
volumes from the failed host.


























Only FS /hana/shared/SID/ is shared /mounted on different hosts. remaining host SAN Storage

/hana/shared/SID/

Note : The SAP Fiber Channel Storage Connector Admin Guide available in SAP Note 1900823.


fs like /hana/log  /hana/data