Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - Database Administration » Maintaining your database » SQL Anywhere high availability » Using the SQL Anywhere Veritas Cluster Server agents

 

Configuring the SAServer agent

The SAServer agent controls the failover of a SQL Anywhere database server to another node in the cluster.

 To set up the SAServer agent
  1. Shut down all SQL Anywhere database servers running on nodes in the cluster.

  2. Choose a node in the cluster and create a directory named SAServer under the %VCS_HOME%\bin directory on that node. You will see other Veritas Cluster Server agents within this folder (such as NIC and IP).

  3. Copy the following files from the install-dir\VCSAgent\SAServer directory to the SAServer directory you created in Step 2:

    • Online.pl
    • Offline.pl
    • Monitor.pl
    • Clean.pl
    • SAServer.xml
  4. Copy the file %VCS_HOME%\bin\VCSdefault.dll into the %VCS_HOME%\bin\SAServer directory and rename it to SAServer.dll.

  5. Copy the file install-dir\VCSAgent\SAServer\SAServerTypes.cf into the %VCS_HOME%\conf\config directory.

  6. Repeat Steps 1-5 for all other nodes in the cluster.

  7. Start the Veritas Cluster Server Manager and enter your user name and password to connect to the cluster.

  8. Add the SAServer agent:

    1. Choose File » Import Types.

    2. Navigate to %VCS_HOME%\conf\config\SAServerTypes.cf, and then click Import.

 To set up a database server for failover using the SAServer agent
  1. Start the Veritas Cluster Server Manager and enter your user name and password to connect.

  2. Add SAServer as a resource to a service group:

    1. Choose Edit » Add » Resource.

    2. In the Resource Type list, choose SAServer.

      On Windows, if SAServer does not appear in the Resource Type list under Windows, you may have to add the SAServer.xml file to the %VCS_ROOT%\cluster manager\attrpool\Win2K\400 and restart the cluster services.

    3. In the Resource Name field, type a name.

    4. Add the following attribute values to the following attributes:

      • cmdStart   dbsrv12 -x tcpip database-file-on-shared-disk -n server-name

      • cmdMonitor   dbping -c "Server=server-name"

      • cmdStop   dbstop -c user-id,password -y

    5. Select Enabled.

      This indicates that the resource is ready to be used.

    6. Click OK.

  3. Ensure that the resource dependencies are configured correctly. There are other resources that must be started and grouped together before SAServer can be started, such as the shared disk resources and the IP address resources.

  4. Right-click the service group and choose Online » node-name, where node-name is the name of the computer in the cluster on which you want the resource to run.

    The service group is now online.


Testing the SAServer agent