on 2012 Jul 18 9:57 AM
We are planning HA here, and the best solution to our needs is:
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
Request clarification before answering.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
@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.
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
@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."
@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?
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 ].
User | Count |
---|---|
50 | |
9 | |
8 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.