High Availability (HA) Configuration - MSP Edition (Probe) - MSSQL

Before configuring the HA setup, please ensure that you have read this document completely.

This document contains the following sections;

  1. Prerequisites

  2. Steps to Configure High Availability

    1. Steps to be Performed in Primary Probe Server

    2. Steps to be Performed in Standby Probe Server

    3. Configure Notifications when Standby Server Takes Over the Role of Primary
  1. Additional Configurations

  2. FAQs

1. Prerequisites

  1. Network connectivity should be reliable between the Primary and Standby servers and the Database server.
  1. Both the Primary and the Standby servers should have the same IT360 Build version.

  2. The Primary and Standby servers should be in the same time-zone and time.

  3. If license is applied in the Primary Server, the same has to be applied in the Standby Server also. Click here for the steps to apply the license in both the servers.

  4. Before configuring the HA setup, take a backup of the IT360 database.

  1. Receiving Netflows in HA Enabled IT360 Setup:

    1. Exporting flows to both the Servers: Configure both the Primary and the Standby servers' ipaddresses in the router, to export the flows. In this case, the Standby server will be in hot-standby mode and will not be providing any service, until it takes over the role of Primary.

    Note: This process consumes additional bandwidth, since the flow is exported to the Standby server also.
    1. Exporting flows only to the current Primary server: In order to avoid the additional bandwidth utilization, manual intervention is made to change the Primary server`s ipaddress in the routers, when the Standby server takes over the role of the Primary. This in turn results in export of the flows, only to the current Primary server.

  1. Receiving Traps in HA Enabled IT360 Setup:

    1. Exporting traps to both the Servers: Configure both the Primary and the Standby servers' ipaddresses in the router, to export the traps. In this case, the Standby server will be in hot-standby mode and will not be providing any service, until it takes over the role of Primary.

    Note: This process consumes additional bandwidth, since the trap is exported to the Standby server also.
    1. Exporting traps only to the current Primary server: In order to avoid the additional bandwidth utilization, manual intervention is made to change the Primary server`s ipaddress in the routers, when the Standby server takes over the role of the Primary. This in turn results in export of the traps, only to the current Primary server.

Top

2.Steps to Configure High Availability:

Follow the steps listed below, separately for the Primary and Standby servers, in order to configure the HA for each of the servers.

2.1 Steps to be Performed in Primary Probe Server

  1. Install the Primary Probe server.

  2. During installation, give a prefix for the Database, e.g. IT360Probe.

  3. Start & Stop the Primary Probe server.

  4. Notifications will be sent, when the Standby Server takes Over the Role of the Primary. Click here for the steps to configure the notifications.

2.2 Steps to be Performed in Standby Probe Server

  1. Install the Standby Probe server.

  2. During installation, give the prefix for the Database, same as given for the Primary Database, i.e.IT360Probe.

  3. Deselect/Uncheck the Create Database check box, as this database was already created when the Primary Probe server was installed.

  4. Do not start the Standby Probe. (Important)

  5. If you have configured HA for the Central server, give the following Standby Central server details in both the Primary and Standby Probe servers, in the file: <IT360HOME>/applications/conf/AMServer.properties;

  1. Now, connect to the Central client, go to the Admin page and click on the Probe link. In the page displayed, the Primary Probe will be listed.

  2. Click on the Edit icon corresponding to the Primary Probe. Do the following in the resulting Edit Probe page.

    1. Enable the Failover Server Details check box.

    2. Enter the Standby Probe details, i.e, the Host Name, Web Server Port and SSL PORT.

    3. Click on Update.
  1. Notifications will be sent, when the Standby Probe Server takes Over the Role of the Primary. Click here for the steps to configure the notifications.

  2. Start the Primary Probe.

  3. Now, make sure that the Primary Probe startup process is complete and start the Standby Probe.

  4. Now the Standby Probe will be running in hot-standby mode, which means that it will not be providing any service and cannot be connected to the WebClient. It will simply be monitoring the Primary probe server's running status. Once the the Primary server goes down, this Standby Probe server will be ready to takeover and start to provide the service.

Top

2.3 Configure Notifications when Standby Server Takes Over the Role of Primary

You will receive notifications, in the form of emails, when the Standby server takes over the functions that were being performed by the Primary. For this, you need to manually add the email id (s) in the file: 'IT360_HOME>\applications\working\conf\FailOver.xml'.

Sample entries are as follows;

<FAILOVER>

<PRIMARY HEART_BEAT_INTERVAL="60" />

        <STANDBY FAIL_OVER_INTERVAL="60" RETRY_COUNT="1">

   <BACKUP ENABLED="TRUE" BACKUP_INTERVAL="600"/>

            <SEND_EMAIL

                SMTP_SERVER="smtp"

                TO_ADDRESS="xyz@zohocorp.com"

                FROM_ADDRESS="admin@zohocorp.com"

                SUBJECT="Primary Server Failed"

                BODY="Primary Server is failed and taken over by the StandBy Server"/>

            </STANDBY>

</FAILOVER>

The optimal value for the RETRY_COUNT is 10.

Top

3. Additional Configurations

If  MIBS are added in the Primary server, the same MIBS should be added in the Standby server also, provided, the Standby has taken over the role of the Primary. (Click here to know about MIB upload procedure for Networks and click here to know about the MIB upload procedure for Applications & Servers)

Top

4. FAQs

  1. How to give multiple email ids, while configuring the notifications?

Type in the email ids, separated by commas.

  1. What is the recommended value for the HEART_BEAT_INTERVAL and the FAILOVER_INTERVAL, while configuring the notifications?

It is recommended to have the HEART_BEAT_INTERVAL and the FAILOVER_INTERVAL, above 20 seconds. Having lesser values may lead to unexpected behaviour.

  1. What is the purpose of setting the RETRY_COUNT, while configuring the notifications? Is the value set for it in the above sample entries is fixed or changeable?

In general, the Standby will go through the parameters, specified in the 'FailOver.xml' file, available under the '<IT360_HOME>/applications/working/conf' directory.  By specifying the RETRY_COUNT value in this configuration file, before starting the service, you can instruct the Standby server to try as many times as the count says, before taking over the role of the Primary. 

By default, this attribute is configured as 1, which means that it will try only once, before taking the role as Primary. Subsequent retry attempts will happen with an interval of 60 secs. For instance, if you need the Standby server to wait for 5 mins before taking over the role as Primary, you can set the RETRY_COUNT value as 5. Please note that the optimal value for the RETRY_COUNT is 10.

Top



Copyright © 2013, ZOHO Corp. All Rights Reserved.