Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » High availability and read-only scale-out systems » SQL Anywhere read-only scale-out » Read-only scale-out set-up


Adding copy nodes

Add copy nodes to a read-only scale-out system.


This task involved backing up a copy of the database. Depending upon the backup method you choose, see the appropriate privileges for that method.

In the root database, the SET MIRROR OPTION for child_creation is set to automatic.

Context and remarks

Copy node definitions are stored in the database. You can define copy nodes for the scale-out system in advance or have the root database server define the copy nodes when they connect. It is recommended that you let the root database server create the copy node definitions because this process reduces the possibility of errors occurring in your copy node definitions.

  1. Make backup copies of the root database.

  2. Start the copies of the database as copy nodes. When starting the database servers that run the copy nodes, you must specify unique names and ports, as well as the -xp on database option. For example:

    dbsrv16 -n scaleout_child_demo -x TCPIP(port=6873) "c:\scaleoutdemo\copynode\scaleoutdemo.db" -xp on


The databases are started as copy nodes.

 See also