Specify at minimum the following connection parameters:
(Required) One or more host names (or IP addresses) and port numbers (if not the default TCP/IP 2638) of any cloud servers using fixed ports running in the cloud. For example, to connect using TCP/IP specify the following: myhost:49152.
|DBN||(Required) The name of the database in the cloud. For example, DBN=tenant1.|
|UID||(Required) The user ID used to log in to the database.|
|PWD||(Required) The password for the user ID specified by the UID connection parameter.|
Additional connection parameters, such as those listed in the table below, can be specified.
By default, when you connect to a database in the cloud, the NodeType (NODE) connection parameter is set to PRIMARY. So, when you connect to a database in the cloud, the connection is redirected to the Primary database. To change this connection redirection behavior, set the NodeType connection parameter to one of the following values:
If you specify ENCRYPTION=TLS then,
The primary and mirror servers are located in Waterloo, Ontario. Clients running in Japan may want to set up a group of copy nodes in Japan to reduce connection latency. If a branch of copy nodes in Japan was a direct child of the root node, then other children could be added beneath the copy node in Japan. Clients would connect to the hub and specify NodeType=COPY. Japanese local, read-only connections would then be load-balanced among the local database servers, and no client would ever connect to database servers elsewhere. If a client needed to make changes to the database, they would change their connection string to use NodeType=PRIMARY.
To connect to the read-write database named joey running in a cloud database configuration, where kangaroo1 and kangaroo2 are two hosts running cloud servers, you could use the following connection parameters:
To connect to any read-only database named joey running in a cloud database configuration, where kangaroo1 and kangaroo2 are two hosts running cloud servers, you could use the following connection parameters: