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