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.
Make backup copies of the root database.
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
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|