The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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 ?

asked 09 Apr '12, 05:37

ooops's gravatar image

ooops
91558
accept rate: 0%


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.
permanent link

answered 09 Apr '12, 12:44

Volker%20Barth's gravatar image

Volker Barth
29.3k287438645
accept rate: 32%

edited 09 Apr '12, 12:47

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

(10 Apr '12, 10:57) Ian McHardy
1

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

(10 Apr '12, 11:05) Volker Barth

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.

permanent link

answered 10 Apr '12, 15:27

Jeff%20Albion's gravatar image

Jeff Albion
10.7k171174
accept rate: 24%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×37
×4

question asked: 09 Apr '12, 05:37

question was seen: 1,346 times

last updated: 10 Apr '12, 15:27