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

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Database maintenance » SQL Anywhere read-only scale-out


Connect to copy nodes

You can connect to a copy node by connecting to the primary server and specifying the NodeType connection parameter as part of the connection string. The NodeType connection parameter accepts the following values:

  • COPY   When the NodeType connection parameter is set to COPY, the database server examines the copy nodes in its own branch (including itself if it is not the root node) and chooses the copy node with the lightest load. If the database server does not choose itself, it redirects the client to the chosen database server.

  • DIRECT   This is the default setting. When the NodeType connection parameter is set to DIRECT, the database server accepts the connection without performing load balancing or redirection.

  • PRIMARY   If the NodeType connection parameter is set to PRIMARY and you have connected to the primary server, the connection is accepted. If you have connected to the mirror server or a copy node, the database server redirects the connection to the primary server.

Once the root database server determines which copy node the connection should be made to, the connection is automatically redirected (if necessary) to that node.

 See also