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

SQL Anywhere 12.0.0 » SQL Anywhere Server - Database Administration » Maintaining your database » SQL Anywhere read-only scale-out » Setting up read-only scale-out

 

Set up the root node

When you configure the root node, define the root database server as a partner server. You can also define a primary server.

 To set up the root node
  1. 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.

  2. 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 server 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.

  3. Set scale-out options for the database using the SET MIRROR OPTION statement.

 See also