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
31.3k312458674
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:

×54

question asked: 30 Nov '11, 07:36

question was seen: 768 times

last updated: 30 Nov '11, 10:32