Skip to Content

ASE Sybase HA with replication

Presently, there is a (ASE Sybase 15.7) primary, standby with replication. They are hosted on the Sun Solaris (SPARC 64-bit). There is a proposal to make it into Database HA. Please suggest the best methods to achieve this model with the replication.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 01, 2017 at 08:32 PM

    Hi Aravind

    Can you shed some light on "why" your company wants to go from "primary ==> replicated standby" configuration to "HA" configuration ?

    Do you use the current pair for simple load balancing of OLTP (primary) and DSS/Reporting in read only mode (standby) ?

    Do you face any issues about smooth switching between primary and standby when needed ?

    (A shell scripted switch + OS level DNS update of a logical IP pointing to primary/active server can make this task pretty simple )

    HA set up will need a new license + clustering layer on each server + some set up work upfront.

    Active + Active set up (assuming that each server can take the whole load) is attractive if you are looking at advanced load balancing

    I would start with HA guide (e.g. http://help-legacy.sap.com/Download/Multimedia/pdf-adaptive-server-enterprise/haguide.pdf)

    HTH

    Avinash

    Add comment
    10|10000 characters needed characters exceeded

    • Thank you for the quick response Avinash,

      It seems that you have misread the question. The replication needs to be retained. The database HA (option) needs to be designed with the replication. included.

  • May 02, 2017 at 05:20 PM

    Thank you for the quick response Avinash,

    It seems that you have misread the question. The replication needs to be retained. The database HA (option) needs to be designed with the replication. included.

    Add comment
    10|10000 characters needed characters exceeded