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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Maintaining Your Database » SQL Anywhere high availability » Using the SQL Anywhere Veritas Cluster Server agents

 

Configuring the SADatabase agent

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

To set up the SADatabase agent

  1. Shut down all SQL Anywhere database servers running on nodes in the cluster.

  2. Create a directory named %VCS_HOME%\bin\SADatabase on one of the nodes in the cluster.

  3. Copy the following files from the install-dir\SADatabase directory to the %VCS_HOME%\bin\SADatabase directory you created in Step 2:

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

  5. Copy the file install-dir\SADatabase\SADatabaseTypes.cf into the %VCS_HOME%\conf\config directory.

  6. Repeat Steps 1-5 for all systems participating 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 SADatabase agent:

    1. From the File menu, choose Import Types.
    2. Navigate to %VCS_HOME%\conf\config\, and click Import.

To set up a database for failover using the SADatabase agent

  1. Add SADatabase as a resource to the service group:

    1. From the Edit menu, choose Add » Resource.
    2. From the Resource Type list, choose SADatabase.

      On Windows, if SADatabase does not appear in the Resource Type list, you may have to add the SADatabase.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 specified values to the following attributes by clicking the button in the Edit column for each attribute:
      • DatabaseFile   The location of the database file, for example, E:\demo.db.

      • DatabaseName   A name for the database.

      • ServerName   A name for the database server. A different server name can be supplied on each system within the cluster. The scope of the attribute should be Per System, not Global.

      • UtilDBpwd   The utility database password used for all systems within the cluster.

    5. Select Enabled.

      This indicates that the resource is ready to be used.

    6. Click OK.
  2. Ensure that the resource dependencies are configured correctly. There are other resources that must be started/grouped together before SADatabase can be started, such as the shared disk resources and the IP address resources.

  3. 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 SADatabase agent