After you configure your companions for asymmetric failover, you can configure them for symmetric configuration. In a symmetric configuration, both servers act as primary and secondary companions. See Figure 3-2 for a description of symmetric configuration.
Issue sp_companion from the primary companion to set it up for symmetric configuration. Use the same syntax as for asymmetric configuration. See “Configuring for asymmetric configuration”, above, for a description of the syntax for sp_companion.
The following example adds an Adaptive Server named MONEY1 as the secondary companion to the Adaptive Server named PERSONNEL1 described in “Configuring for asymmetric configuration” (issue this command from primary companion MONEY1):
sp_companion 'PERSONNEL1', configure, with_proxydb, null, sa, Think2Odd
Server 'MONEY1' is alive and cluster configured. Step: Access verified from Server:'MONEY1' to Server:'PERSONNEL1' Server 'PERSONNEL1' is alive and cluster configured. Step: Access verified from Server:'PERSONNEL1' to Server:'MONEY1' (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) (1 row affected) ..... Step: Companion servers configuration check succeeded Step: Server handshake succeeded Step: Master device accessible from companion Step: Added the servers 'MONEY1' and 'PERSONNEL1' for cluster config Step: Server configuration initialization succeeded Step: Synchronizing server logins from companion server Step: Synchronizing remoteserver from companion server Step: Synchronizing roles from companion server Step: Synchronizing server-wide privs from companion server Step: User information syncup succeeded Step: Server configured in normal companion mode
The login_name and password in
the above sp_companion configure command
cannot be null. After you successfully execute sp_companion configure,
the operating system creates a new file, /etc/VRTSvcs/conf/config/ha_companion.remote_server_name.
Make sure this file has read and write access only for the user
who runs the server, otherwise security may be compromised.
