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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » High availability and read-only scale-out systems » SQL Anywhere Veritas Cluster Server agents » SAServer agent configuration

 

Setting up the SAServer agent

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

Prerequisites

Your systems must be set up as follows to use the SQL Anywhere Veritas Cluster Server agents:

  • You must use Veritas Cluster Server 4.1 or later.

  • SQL Anywhere must be installed identically on each system node within the cluster.

  • Database files must be stored on a shared storage device that is accessible to all systems within the cluster.

  • The utility database password must be the same for all systems within the cluster.

    The SADatabase agent uses the utility database to start and stop specific database files. All systems participating in the cluster must have the same utility database password. You can set the utility database password by specifying the -su server option when starting the database server.

  • On Unix, the VCS agent is installed in $SQLANY16/vcsagent/saserver.

 Task
  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 may see other Veritas Cluster Server agents within this folder (such as NIC and IP).

  3. Copy the following files from the %SQLANY16%\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 %SQLANY16%\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. Click File » Import Types.

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

Results

The SAServer agent is set up.

 See also