Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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
40.2k361550822
accept rate: 34%

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.8k171175
accept rate: 25%

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:

×61
×4

question asked: 09 Apr '12, 05:37

question was seen: 3,142 times

last updated: 10 Apr '12, 15:27