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.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|