Product Information
Let’s flip the flags! Is my SAP HANA database in sync or not?
This blog post is about running SAP HANA system replication in the High Availability cluster by SUSE. The SAP HANA resource agents are available in the product SUSE Linux Enterprise Server for SAP Applications.
The challenge
You have setup your SAP HANA system replication cluster. The cluster is working. The tests are passed. Let’s celebrate! But how can I see in the High Availability Web Konsole (HAWK), if the SAP HANA system replication pair is currently in sync? Is there an easy method to show the current replication status detected by the cluster resource agent?
Maybe you know already from our best practice guides, that the solution provides a tool to show all relevant cluster attributes created by the SAPHanaSR resource agents. SAPHana-showAttr is your friend at the Linux command line. Likewise the standard cluster tool crm_mon can print all cluster attributes. Certainly these solutions are working fine and precise. Maybe you would prefer to see the system replication status more prominent and graphical using HAWK.
The solution
As a result of very good community work a colleague of mine thought about a dummy cluster resource. The only purpose of this dummy resource is to represent the system replication status detected by the cluster.
As you can see in the HAWK screen shot the resource rsc_HANAinSync_HD0_HDB00 represents the flag in our graphic. The cluster only starts that resource, if the appropriate cluster attribute is set successfully.
Read my blog Let’s flip the flags! Is my SAP HANA database in sync or not? at https://www.suse.com to get more details.
Nice hint 🙂
Thanks for sharing!
Thank you for this helpful blog.
And I have a question about SAPHanaSR resource agent script. (because I don't know your email address, so I wrote hear.. sorry)
Is there any plan that SAPHanaSR resource agent will support multi-target system replication scenario? (example. A(master) -> B(slave) and at the same time, A(master) -> C(slave))