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.

asked 27 Oct '13, 12:20

Breck%20Carter's gravatar image

Breck Carter
26.9k438609883
accept rate: 21%

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:

NodeType (NODE) connection parameter enhancement The NodeType connection value now supports MIRROR and READONLY values:

  • MIRROR Redirects the application to the tenant's mirror database.
  • READONLY Redirects the application to any read-only database copy: either a copy node or the mirror copy. If there are no read-only copy nodes, READONLY is equivalent to the MIRROR setting. If there are only read-only copy nodes, READONLY is equivalent to the COPY setting.
(28 Oct '13, 05:41) Volker Barth
Be the first one to answer this question!
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: 27 Oct '13, 12:20

question was seen: 604 times

last updated: 28 Oct '13, 05:48