You must configure your companions for an asymmetric setup before you can configure them for a symmetric setup. In a symmetric configuration, both servers act as primary and secondary companions.
Issue sp_companion from the secondary companion to configure it for symmetric setup. Use the same syntax as for the asymmetric setup, except you cannot use the with_proxydb option.
The following example adds an Adaptive Server named MONEY1 as the secondary companion to the Adaptive Server named PERSONNEL1. Issue the following command from the server MONEY1:
1> sp_companion 'PERSONNEL1', configure, null, sa, MyPassword, sa_cluster_login, MyClusterPassword 2> go
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
After sp_companion completes:
Check the completion status of the Wizard. If the configuration failed, check the setup log for errors, if it succeeded, open the Windows Failover Cluster Manager (as a shortcut, press and release the Windows key, type “failover” to bring up the Failover Cluster Manager icon, then press Enter).
Locate the new Sybase Companion server in the Services and Applications tree. The companion server is named primary_server_name_GRP.
Click on companion server name to view the Summary of primary_server_name_GRP display.
In the right-hand side of this display, click “Add Storage,” and add all shared storage devices the companion servers will use.
In the central part of the display, right-click the Sybase Companion server under “Other Resources,” select Properties, and highlight the Dependencies tab. Add a dependency for every shared storage device.
