In some cases, you may want to connect to the current Secondary (if it is up). Applications can submit read-only queries to the Secondary server; this can sometimes help you balance the workload across your servers.

An application can only connect to Secondary databases in the read-only mode. Note that a client can connect to the Secondary server (only in read-only mode) by using the following parameter values in the HotStandby section of the solid.ini configuration file in these servers:

You can also use the following command to get the connection information for a server’s partner:

Thus, if you are connected to the current Primary server, you can get the address of the current Secondary by using the cominfo query.