You create the root node of a read-only scale-out system using the database that you want to have copies of.
Context and remarks
When you configure the root node, define the root database server as a partner server. You can also define a primary server.
Start a database server running the database that you want to have read-only copies of. You must specify the -xp on database option when starting the database server.
Define the scale-out objects in the root database using the CREATE MIRROR SERVER statement.
It is recommended that you create two definitions for the root database server: CREATE MIRROR SERVER...AS PARTNER and CREATE MIRROR SERVER...AS PRIMARY. The name that you give the database server in the statement that uses the AS PARTNER clause is the name that is used in the command to start the database server and in client connection strings. The name that you give the database server in the statement that uses the AS PRIMARY clause is the name of the database server that is the default parent for copy nodes that are added to the scale-out system. If you do not define a primary server, then you must specify the name of the parent server when you create copy nodes, so defining a primary server is recommended.
Set scale-out options for the database using the SET MIRROR OPTION statement.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|