Results 1 to 2 of 2
  1. #1
    Join Date
    May 2014

    Question Unanswered: Sybase Replication

    I am a longstanding Sybase user, let's not mention exactly how many years, and I have always used Sybase to perform the replication between my SANs. I am now looking at a SAN replacement and some of the vendors are offering support for array based replication rather than host based with the application - am confused!

    Is the best way to get a true active-active config, with data integrity, still to let Sybase do the replication, or should I now be looking at allowing the storage hardware to do it?

    What are your views?

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    I've moved your thread from the New Users forum to the Sybase forum. It should get both more answers and more appropriate answers in the Sybase forum.

    Different SANs have different degrees of integration with database engines. I've seen every level of support from unusable to poor. I've seen a total of just under 200 SAN based replication configurations. One was successful and one was marginal.

    Timing is usually the biggest problem with SAN replication where databases are concerned. Think about what would happen with a simple uni-directional replication scenario if the synchronization between your Sybase data and log devices gets "out of sync" so that one is seconds or hours ahead of the other. Now imagine the fun when that replication becomes bi-directional! When looking at replication, uptime is usually the primary motivation, so mix in a SQL cluster for good measure. I'll wait while you go have a drink or two to calm down again.

    If you decide to pursue the idea, make sure that you get the SAN replication folks to demonstrate how this works in your environment. It is relatively easy to make things work in a lab. The real world provides additional amusements which are often overlooked or ignored by sales people!

    As SAN and database replication architectures evolve, I'm sure that sooner or later someone will get it right. For now even in light of the expense and extra support effort needed, I'd recommend staying with Sybase replication.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts