You must add a database to the service group before it is configured to fail over.
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.
Add SADatabase as a resource to the service group:
Click Edit » Add » Resource.
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.
In the Resource Name field, type a name.
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.
This indicates that the resource is ready to be used.
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.
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.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|