Can read-only scale-out be added to an old-school HA setup?

[Breck_Carter]

A production SQL Anywhere 12 High Availability exists using the old-school command line methods:

   dbsrv12 ... -xp partner=(eng=xxx;links=tcpip(host=192.168.0.20; ...

Can the new CREATE MIRROR SERVER and SET MIRROR OPTION statements be added to this setup to implement a read-only scale-out copy node?

Or does the existing High Availability setup have to be changed to use the new-school CREATE MIRROR SERVER methods?

[ian_mchardy · Accepted solution]

No, you cannot use -xp specified partners with copy nodes.

What you need to do is:

1. add CREATE MIRROR SERVER definitions for the partners, primary and arbiter
2. set any mirror options with the SET MIRROR OPTION statements
3. restart the partner servers with just -xp on
4. add the copy nodes

Note that mixing CREATE MIRROR SERVER definitions with old (deprecated) -xp key=value;... definitions can lead to unexpected behavior so they should not be mixed.

[Breck_Carter · Accepted solution]

...and the short answer is, "do not be an early adopter"... sigh 🙂