Setting up the root node

You create the root node of a read-only scale-out system using the database that you want to have copies of.

Prerequisites

None.

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.

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

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

Results

The root node is now ready to be used.

Next

You can make backup copies of the root database that are used to add child nodes to the read-only scale-out system.

 See also