If you do not want to create a new database server to run the arbiter of a mirroring system that includes a read-only scale-out system, you can configure one server to act as both a copy node and an arbiter for the system.
You must have the MANAGE ANY MIRROR SERVER system privilege.
This task involves backing up a copy of the database. Depending upon the backup method you choose, see the appropriate privileges for that method.
Stop the copy node that you want to also be an arbiter server.
Choose one of the following options:
|Add the arbiter to an existing copy node||
|Add a copy node to the existing arbiter||
For example, there is no database server named TheArbiter in the mirroring and read-only scale-out system that uses the following server definition.
CREATE MIRROR SERVER "scaleout_child" AS COPY connection_string = 'SERVER=scaleout_child;HOST=winxp-2:6878'; CREATE MIRROR SERVER "TheArbiter" AS ARBITER connection_string = 'SERVER=scaleout_child;HOST=winxp-2:6878';
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|