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 » SADatabase agent configuration

 

Setting up a database for failover using the SADatabase agent

You must add a database to the service group before it is configured to fail over.

Prérequis

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. Add SADatabase as a resource to the service group:

    1. Click Edit » Add » Resource.

    2. From the Resource Type list, click 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. Click 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 click Online » node-name, where node-name is the name of the computer in the cluster on which you want the resource to run.

Résultat

The service group is now online.

 See also
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0