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.

Hi, we are playing around with HA and wondering a bit why there is no wizzard for configurating. We don't even know how to ask for the current configuration.

Bernd

asked 30 Nov '11, 07:36

bscheufens's gravatar image

bscheufens
16112
accept rate: 0%


Which SQL Anywhere version (and build number) do you use?

There is a whole chapter in the docs on HA - e.g. this page on how to setup HA for v12.0.1.

Unless you start the database server explicitly with the -xp database option, you can't use HA at all. Besides that, the following database properties might tell you more.

select db_property('MirrorRole'), db_property('MirrorServerState'),
  db_property('MirrorState'), db_property('MirrorMode'), db_property('PartnerState');

For a non-mirrored database on a server not startet with -xp, they all return NULL.

permanent link

answered 30 Nov '11, 07:53

Volker%20Barth's gravatar image

Volker Barth
29.3k287438644
accept rate: 32%

edited 30 Nov '11, 07:55

Hi, in the helpfiles I found some samples for configuration. So I did the following: CREATE MIRROR SERVER "scaleout_primary" AS PRIMARY... CREATE MIRROR SERVER "scaleout_mirror" AS MIRROR ... CREATE MIRROR SERVER "scaleout_arbiter" AS ARBITER ... CREATE MIRROR SERVER "scaleout_server1" AS PARTNER...

It works, but where can I see this config? What if I want to change the servername? My only solution is a unload and examin the reload-sql.

Bernd

(30 Nov '11, 09:44) bscheufens

sorry now I found

select * from SYSMIRRORSERVER; select * from sysmirroroption; select * from SYSMIRRORSERVEROption;

Thats ok but not convenient. I really expect that in Sybase Central.

Bernd

(30 Nov '11, 09:57) bscheufens
Replies hidden

Can't claim whether there's a GUI support to setup HA. I would always prefer a script based approach in order to get a reproducable setup. But that's just my very humble opinion.

FWIW: There's an article on Breck Carter's blog how to setup a (v10) HA setup with some demo stuff:

Demonstrating High Availability

IMHO, you will have to setup such a system and test with your clients to find out what happens when a fail-over occurs and how a server can be restarted - and these are tasks that are way beyond Sybase Central's responsibility, methinks...

(30 Nov '11, 10:30) Volker Barth
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

question asked: 30 Nov '11, 07:36

question was seen: 699 times

last updated: 30 Nov '11, 10:32