DeviceExpert Home | Online Demo

High Availability Setup 

(Steps applicable for existing users, who want to use their present installation as primary)

As mentioned above, High Availability setup in DeviceExpert involves 'Primary' installed on one machine, 'Standby' installed on another machine and 'Database' installed on a third machine. All the three machines should be in the same subnet.

Important Note: Before proceeding further, take a zip of the entire <DeviceExpert-Installation-Folder> and keep in a separate drive. In case, something goes wrong with the HA setup, you can rely on this to get back the old setup

 

Prerequisites

Step 1: Primary and Standby Setup

  1. High Availability is supported from DeviceExpert v5650 onwards. So, your existing installation should be 5650 or above. If you are using earlier versions, you need to apply upgradepack first.

  2. After ensuring the above aspect, you need to take backup of the contents of the existing database. Take a zip of the 'mysql' folder under <DeviceExpert-Installation-Folder>.This zip file will be used in 'Step 3' below. (MSSQL uses may skip this step)

  3. Then, you need to download DeviceExpert and install it in another machine to act as standby.

Step 2: Install Database & Grant Privileges 

As per the HA architecture of DeviceExpert, the primary and standby connect to a common database installed on a separate machine. So, you need to have the common database in place in a separate machine.

If you are using MySQL

Unzip the 'mysql' zip, which you took in step 1. This will act as the common DB. The database has to be configured to allow connections from DeviceExpert primary and standby. To do this, start mysql and follow the steps as detailed below:

mysql> CREATE USER 'username'@'%' IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;


Note: You need to make a note of the 'username' and 'password' specified in the steps above. This has to be specified in 'Step 3' below.

Step 3: Configure High Availability 

After installing DeviceExpert, you need to enable High Availability in both primary and standby installations.

Configuration to be done in Primary Installation

Navigate to <DeviceExpert-Primary-Installation-Folder>/bin directory and execute FOSSettings.bat.


In the pop-up, enter the following details:

HA Settings

Public IP: Assign a common public IP address for DeviceExpert Primary and Standby so that DeviceExpert webinterface could always be connected to this specific IP. The DeviceExpert server will be bound by this single public IP and irrespective of whether DeviceExpert is running as Primary or Standby, end-users can connect to the same public IP seamlessly. Enter the Public IP in this text field.

Public IP Netmask: Specify the subnet mask of the Public IP.

Standby IP: Enter the IP address of DeviceExpert Standby server. This step ensures that Primary server knows where standby is running and vice-versa.


DB Settings

Here, you need to specify details about the database, which you installed in 'Step 2' above.

SQL Server Type: Select which database you are using - MySQL or MSSQL

Hostname: Specify the hostname or IP address of the database server

Port: Specify the port where the MySQL server is running. By default,  MySQL occupies the port 43306; MSSQL occupies 1433

Database: The name of the database 'deviceexpert'

Username & Password: Enter the credentials for connecting to the database

After specifying these, run 'Test Connection' to check if DeviceExpert application server is able to establish connection with the database.

HA Status Notification Mail Settings

You can choose to receive notifications regarding High Availability status - when primary goes down, standby takes over etc. Enter the email addresses to which the notifications are to be sent.

HA configuration Settings Pack

Finally, click 'Save'. The HA configuration in primary is completed now. Upon completing this, high availability configuration settings are created as a .bkp file in primary. Typically, the configuration pack will have the file name with timestamp in the format as "Settings_MM_DD_YYYY_HH_MM.bkp" under <DeviceExpert-Primary-Installation-Folder>/fos/Settings directory. You need to copy this file and put in the DeviceExpert standby installation as explained below.

 

Apply DeviceExpert License (If not already done)

If you have purchased DeviceExpert, you need to apply the license by clicking the 'Register' link present in the top right hand corner of DeviceExpert web-interface.

Configuration to be done in Standby Installation

Put the HA configuration settings pack created in the form of .bkp file in the previous step, under <DeviceExpert-Standby-Installation-Folder>. Now, navigate to <DeviceExpert-Standby-Installation-Folder>/bin directory and execute UnzipFOSSettings.bat file passing the location of HA configuration settings pack .bkp file location as the commandline argument.

 

Apply DeviceExpert License

You need to apply the DeviceExpert license file in the standby installation. Standby does NOT require a separate license file. You can use the same license you purchased for primary. To apply the license file, copy the .xml file and paste it under <DeviceExpert-Standby-Installation-Folder>/lib directory.

This step completes the HA configuration in standby.

Step 4: Start HA Service in Primary and Standby

Now, you need to start HA in both Primary and Standby installations. Navigate to Windows Services Panel and start "DeviceExpert-FOS" service in both Primary and Standby. While DeviceExpert application in the primary will be up and running, DeviceExpert application in standby will just be monitoring the primary in HA mode. It will get started when the primary goes down.

Note: As mentioned above, standby server keeps monitoring the primary. By default, it checks primary's status once in 20 seconds. In case, it finds that the primary is not running, it tries two times to ensure that before starting up DeviceExpert application. These values are configurable. You need to change the values of the following parameters in fos.conf file present under <DeviceExpert-Standby-Installation-Folder>/fos/bin directory in both primary and standby.

clustering.fos.slave.httppoll.intervalInSecs = 20  
(This represents status checking interval)

clustering.fos.slave.httppoll.retryCount = 2
(This represents the retry count)

Uninstalling HA Setup

In case, you want to uninstall the HA setup, follow the steps below:

Steps to be done in Primary installation


  1. Navigate to <DeviceExpert-Primary-Installation-Folder>/fos/bin directory and run uninstall-fos.bat

  2. Then, navigate to <DeviceExpert-Primary-Installation-Folder>/conf folder and edit the system_properties file as below:|

  3. Then, navigate to <DeviceExpert-Primary-Installation-Folder>/conf folder and edit wrapper.conf as below:

  4. Then, navigate to <DeviceExpert-Primary-Installation-Folder>/bin directory and execute "deviceexpert.bat remove"

  5. Then, navigate to <DeviceExpert-Primary-Installation-Folder>/bin directory and execute "deviceexpert.bat install"

The above steps will uninstall HA in Primary setup. The primary server will remain connected to the common database and you may continue using it.

 

Steps to be done in Standby installation


  1. Navigate to <DeviceExpert-Standby-Installation-Folder>/fos/bin directory and run uninstall-fos.bat

  2. Then, navigate to <DeviceExpert-Standby-Installation-Folder>/bin directory and execute "deviceexpert.bat remove"

 

The above steps will uninstall HA and DeviceExpert standby installation.


2012, ZOHO Corp. All Rights Reserved.