cancel
Showing results for 
Search instead for 
Did you mean: 

Can High-Availability be configured without Veritas Cluster Service ?

Former Member
0 Kudos
3,515

In ASA 12 manual, I can find two solutions for Sql-anywhere HA.

First, mirroing

Secnod, using Veritas Cluster Service

Is there any other solution ?

A guy said that Sql-anywhere version 12 High Availability can be configured with MSCS. ( Pls refer to this: http://www.sybase.com/detail?id=1034743 )

Is this method compatible with Sql Anywhere 12.x ?

Accepted Solutions (0)

Answers (2)

Answers (2)

jeff_albion
Advisor
Advisor

While Volker is correct (we generally recommend to use the SQL Anywhere High-Availability add-on component), the article you have linked is still valid for current versions of Windows / SQL Anywhere (e.g. Setting up SQL Anywhere in a service for an "active-passive" Microsoft Cluster). While this should technically work, the advantages of using the SQL Anywhere High-Availability add-on option over the Microsoft clustering is that you have the option of using the mirrored database as a "read-only" server (in versions 11 and up) - you cannot do this with the Microsoft clustering technology.

We currently have a new draft of this document internally to update it to modern versions of SQL Anywhere (e.g. 12) and modern versions of Windows Server (e.g. 2008) - the theory is the same, but the step-by-step instructions / screenshots have changed slightly.

We will try to publish this updated article soon. Thanks for your feedback.

VolkerBarth
Contributor

As to the cited doc from 2005: This seems to refer to v9 (ASA 9), whereas the HA feature was introduced with the next version (SQL Anywhere 10). So I would think that nowadays one would surely prefer the builtin HA feature over a "foreign one".

And no, you don't need Veritas Cluster Service to use the builtin HA feature (I don't know where this may be told...) - they are simply two different methods.

To cite some properties of the builtin HA feature:

  • No special hardware, such as a shared disk is required.
  • No special software (for clustering, for example) is required.
  • No particular operating system version is required.
ian_mchardy
Advisor
Advisor
0 Kudos

FYI, Volker is correct that SQL Anywhere High Availability (also called "Mirroring") does not require the Veritas Cluster Service.

VolkerBarth
Contributor

FWIW, Breck Carter's blog has a nice tutorial on HA (though based on v11, and some details have changed for v12):

Demonstrating High Availability