Previous topicNext topic
 Link Technologies - LinkSOFT Documentation 
Help > Link Web Applications Portal > Replication >
How to setup replication with fail-safe

Overview

In this example, there are two stations in Suva Office and two stations in Sydney Office.

  1. Each station will be configured to run on Stand Alone (Fail-safe) mode.
  2. Suva and Sydney servers will be configured to replicate data.
  3. Sydney Server SQL Database needs to be accessible from Suva server. Therefore you need a Static IP address.
  4. Suva Server does not need a Static IP address.

This will achieve two results:

  1. The Stations will be able to run on Stand Alone mode in an event of network failure. Stand Alone means that all processing will be performed locally until the servers are available.
  2. Sydney and Suva servers will be configured to replicate data.

Figure 1: Network diagram showing two branches (Suva and Sydney) and 2 stations per branch

Definitions

Stand-Alone (Fail-safe)

This mode is usually used for Point of Sales Stations (SYDNEY-ST1, SYDNEY-ST2, SUVA-ST1 and SUVA-ST2). In the event of a network failure, the station will switch to local database and all transactions will be saved on the local station. When the network recovers, the Stand Alone station will automatically detect its server (SYDNEY-AU, SUVA-FJ) and connect to the server. Data will be transferred to the server automatically.

Child

This is when a branch server needs to connect and replicate to head office server. In the above network diagram, the following are child connection types:

  1. SUVA-FJ server connects to SYDNEY-AU server using a child connection type.

Parent

This is when a server connects to Stations or to a branch Servers.In the above network diagram, the following are parent connection types: 

  1. SUVA-FJ server connects to SUVA-ST1 Station using a parent connection type
  2. SUVA-FJ server connects to SUVA-ST2 Station using a parent connection type
  3. SYDNEY-AU server connects to SUVA-FJ Server using a parent connection type
  4. SYDNEY-AU server connects to SYDNEY-ST1 Station using a parent connection type
  5. SYDNEY-AU server connects to SYDNEY-ST2 Station using a parent connection type

Important Notes:

  1. It is important that you use the Unique name for Station. (SUVA-ST1, SUVA-ST2, SYDNEY-ST1, SYDNEY-ST2, SUVA-FJ, SYDNEY-AU)
  2. Transaction ID needs to be unique in Stand-Alone Mode and between branches. Please make sure that you use a unique two digit identifier for each database server. Examples are: A0, A1, A2... B0, B1, B2 ... Z0, Z1, Z2...

Below is a summary of steps on how to configure the systems to achieve the following:

  1. The Stations will be able to run in an event of network failure. All processing will be performed locally until the servers are available.
  2. Sydney and Suva servers will replicate data

Steps to configure

  1. Install LinkSOFT on all Servers and Stations .
  2. Configure the Servers as show below:
     Description  Physical Address  Server Name  Database Name  Mask  Server Type

    Active

     Sydney Head Office  SYDNEY-AU  SYDNEY-AU  LinkSOFT  AU  Head Office

    X

     Sydney Station 1  SYDNEY-ST1  SYDNEY-ST1  LinkSOFT  AB  Branch

    X

     Sydney Station 2  SYDNEY-ST2  SYDNEY-ST2  LinkSOFT  AA  Branch

    X

     Suva Branch  SUVA-FJ  SUVA-FJ  LinkSOFT  FJ  Branch

    X

     Suva Station 1  SUVA-ST1  SUVA-ST1  LinkSOFT  FB  Branch

    X

     Suva Station 2  SUVA-ST2  SUVA-ST2  LinkSOFT  FA  Branch

    X


  3. Create a server connection as shown below in order of sequence:

    Sequence

    		  Login to Web Server  Description  Connection Type  Source Server ID  Destination Server ID

    Active

    1

    		  Sydney Head Office  Sydney Head Office to Suva Branch  Parent  Sydney Head Office  Suva Branch

    X

    2

    		  Suva Branch  Suva Branch to Sydney Head Office  Child  Suva Branch  Sydney Head Office

    X

    3

    		  Sydney Station 1  Sydney Station 1 to Sydney Head Office  Stand Alone  Sydney Station 1  Sydney Head Office

    X

    4

    		  Sydney Head Office  Sydney Head Office to Sydney Station 1  Parent  Sydney Head Office  Sydney Station 1

    X

    5

    		  Sydney Station 2  Sydney Station 2 to Sydney Head Office  Stand Alone  Sydney Station 2  Sydney Head Office

    X

    6

    		  Sydney Head Office  Sydney Head Office to Sydney Station 2  Parent  Sydney Head Office  Sydney Station 2

    X

    7

    		  Suva Station 1  Suva Station 1 to Suva Branch  Stand Alone  Suva Station 1  Suva Branch

    X

    8

    		  Suva Branch  Suva Branch to Suva Station 1  Parent  Suva Branch  Suva Station 1

    X

    9

    		  Suva Station 2  Suva Station 2 to Suva Branch  Stand Alone  Suva Station 2  Suva Branch

    X

    10

    		  Suva Branch  Suva Branch to Suva Station 2  Parent  Suva Branch  Suva Station 2

    X


  4. Configure Fail-Safe mode  on Point of Sale Stations (SYDNEY-ST1, SYDNEY-ST2, SUVA-ST1,SUVA-ST2)