Implementing HA SAP NetWeaver with AnyDB on Azure VMs (part 2)

By Ashwin Venugopal -

 

To read part 1 please click here



Add registry entries on both cluster nodes of the SAP ASCS-SCS instance

If you want to add registry entries on both cluster nodes of the SAP ASCS-SCS instance, then you have to add them on both Windows cluster nodes for SAP ASCS/SCS:

Path

HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters

Variable name

KeepAliveTime

Variable type

REG_DWORD (Decimal)

Value

120000

Path

HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters

Variable name

KeepAliveTime

Variable type

REG_DWORD (Decimal)

Value

120000

 You have to restart both the cluster nodes to apply the changes. 

Set up a Windows Server failover cluster for SAP ASCS-SCS instance

It involves the following tasks:

  • Add cluster nodes to the cluster.
  • Configure Cloud witness 

Add cluster nodes to the cluster

You have to set up the failover cluster by using the Failover Cluster Manager:

  • In the Failover Cluster Manager, select Create Cluster, and then add only the name of the first cluster.
  • Enter the network name (virtual host name) of the cluster.
  • After successfully creating the cluster, you have to run a validation test.
  • At this point you can ignore the warnings about disks and should not worry about having a quorum.
  • Bring the cluster virtual host name online.
  • Now you can add the second cluster node.

Configure cloud witness

If you want to configure the cloud witness, then you should have a valid Azure Storage Account through which you can store the blob file (used for arbitration). The same Microsoft Storage Account can be used to configure a Cloud Witness for multiple different clusters and will contain one-blob file per cluster. When creating a storage account, you should keep in mind that:
  • You can't use a Blob storage account for a Cloud Witness.
  • You can't use Azure Premium Storage for a Cloud Witness.
  • For replication, select Locally-redundant Storage (LRS) because the Failover Clustering uses the blob file as the arbitration point, which in turn also requires some consistency guarantees while reading the data. 

Note- No extra steps are required for the configuration necessary for the URL as the endpoint is generated automatically by Cloud Witness resource.

Configure failover parameters

After successfully installing the Windows Failover Clusters, you  should change some thresholds, so that they can adapt to the conditions in Azure for failover detection. If you assume that your two VMs consisting teh cluster configuration for ASCS/SCS are in the same subnet, then you can easily change the following parameters to these values:

  • SameSubNetDelay = 2000
  • SameSubNetThreshold = 15
  • RoutingHistoryLength = 30

Although all these settings are resilient enough, but they can also offer failover that is fast enough in real error conditions on a SAP atmosphere or in a node or VM failure. 



To read part 1 please click here




Comments

Post a Comment

Popular posts from this blog

Query, Visualize, & Monitor Data in Azure Sentinel

By Ashwin Venugopal -
Image
  Azure Sentinel Workbooks Several ready for use templates are provided by the Azure Sentinel that can be used to create your own workbook and then modify them as needed for Contoso. Most of the data connectors it uses to ingest data come with their own workbooks, but better insight can be obtained by simply looking into the data that is being ingested by using tables and visualizations, including bar and pie charts. You can also make your own workbook easily by using this data from the beginning instead of using the predefined templates. Workbook Page You can easily access the workbook page from the Azure Sentinel from the navigation pane which consists of the: Workbook header- You can add a new workbook and review the saved workbooks as well as templates that are available on the workbook page. Templates section- You can access existing workbook templates on the Templates tab. You can save some of the workbooks for quick access and they will appear on the My Workbooks tab.  From the
Read more

Planning for Implementing SAP Solutions on Azure (Part 2 of 5)

By Ashwin Venugopal -
Image
  To read part 1 please click  here To read part 3 please click  here To read part 4 please click  here To read part 5 please click  here Load Balancing The load balancer uses probe ports to determine as well as route the traffic to an active DBMS node, but of there's any failover then the most common SAP application architecture can automatically reconnect against the private virtual IP address without the need for the SAP application to reconfigure it, while the load balancer redirect the traffic against the private virtual IP address without any need for the SAP application to reconfigure. The loaf balancer also offers an option of DirectServerReturn which if configured, can help in directing the traffic from the DBMS VM to the SAP application layer directly to the application layer without routing through the load balancer. But, if it isn't configured, then the return traffic to the SAP application layer is routed through the load balancer. You can also use Azure Load Balan
Read more

Work with String Data Using KQL Statements

By Ashwin Venugopal -
Image
  Extract Data from Unstructured String Fields Unstructured string fields often contains the Security log data and requires parsing to extract data. There are multiple ways of pulling information from string fields in KQL and the two primary operators used are extract and parse.  Extract It gets a match for a regular expression from a text string. You can convert the extracted substring to the indicated type.  Arguments regex- A regular expression. captureGroup- A positive int constant indicating the capture group to extract. 0 stands for the entire match, 1 for the value matched by the first '('parenthesis')' in the regular expression, 2 or more for subsequent parenthesis.  text- A string to search. typeLiteral- An optional type literal. If provided, the extracted substring is converted to this type.  Returns If regex finds a match in text- the substring matched against the indicated capture group captureGroup, optionally converted to typeLiteral. If there's no mat
Read more