|
This question is asking "Is it safe?" SQL Anywhere 12 doesn't have NODE=MIRROR, and the V12 Help describes NODE=COPY as applying only to read-only scale-out copy nodes. However, it does seem like NODE=COPY on a V12 connection in a High Availability setup involving only primary and secondary (mirror) databases (no copy nodes) can be used to prevent a read-only connection to the mirror from reconnecting to the primary in update mode when the mirror server crashes. In other words, if the mirror crashes, NODE=COPY prevents all those roque queries from being loaded onto the primary database. When the mirror is restarted, and reassumes its duties as mirror, the NODE=COPY connections can be reestablished. |
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- 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:
question asked: 27 Oct '13, 12:20
question was seen: 1,318 times
last updated: 28 Oct '13, 05:48
I don't have an answer but would like to note that 12.0.1 does have NODE=MIRROR and NODE=READONLY, so your question seems to hold for 12.0.0... - cf. this doc hint from the "What's new in version 12.0.1" section: