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.

We are planning HA here, and the best solution to our needs is:

  • Primary server running on physical box, installed on building 1.
  • Mirror server running on a vm box, installed on building 1.
  • Mirror server running on vm box, installed on building 2.

Everything is fine, but now we have a problem with Mode. Can I use synchronous between servers on same building and asynchronous to communicate with server on building 2? It's because I can have high latency and my application do alots of (bank) transactions per second.

Thank you

asked 18 Jul '12, 08:57

Zote's gravatar image

Zote
1.7k364050
accept rate: 43%

1

If your question is, "can I use different modes for different mirror and copy nodes?" then the rule that "Watcom does things the way they should be done" probably applies... wagers are now being accepted, odds are 50:1 on "yes" :)

(18 Jul '12, 09:36) Breck Carter

With HA you can have only 1 mirror server (as far as I know) Have a look at Introduction to database mirroring

With Scale out you can use multiple servers, but read-only.

permanent link

answered 18 Jul '12, 09:18

Martin's gravatar image

Martin
8.6k114149237
accept rate: 14%

edited 18 Jul '12, 12:20

Two problems with that link: wrong topic, and wrong location (infocenter sucks, DCX rocks :)

Try this: http://dcx.sybase.com/index.html#1201/en/dbadmin/database-mirroring-overview.html

(18 Jul '12, 09:28) Breck Carter
Replies hidden

@Martin, Ok. But I can use HA and Scale in same environment/database? If I can, server on building 2 should be Scale, and servers on building 1 HA.

(18 Jul '12, 09:37) Zote
Replies hidden

There's a section in DCX covering "readonly copy node", see here:
http://dcx.sybase.com/index.html#1201/en/dbadmin/sa96b7b235-0741-4b1a-bd01-bf940e6cdad8.html

(18 Jul '12, 10:26) Reimer Pods
Replies hidden

@Reimer: That's one NASTY url, even worse than crap like http://www.sybase.com/detail?id=1067224

I guess the memo got lost, the one that said "This is 2012! ...people like to know where they're going before they click on links."

(18 Jul '12, 12:07) Breck Carter

Thanks Breck, I have corrected the link

(18 Jul '12, 12:21) Martin

Yes I think that should be possible

(18 Jul '12, 12:21) Martin

@Reimer, OK. Now I know that to possible to have a failover strategy that I need. But how can I set different synchronization modes to HA and Scale databases?

(18 Jul '12, 16:06) Zote

Note that synchronization to the scaleout nodes is always asynchronous and is not configurable. The synchronization mode between the primary and mirror (i.e between the HA partners) is configurable using the SET MIRROR OPTION SYNCHRONIZATION_MODE = [ synchronous | asynchronous | asyncfullpage ].

(18 Jul '12, 17:04) Mark Culp
showing 3 of 8 show all flat view
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: 18 Jul '12, 08:57

question was seen: 982 times

last updated: 18 Jul '12, 17:04