Preparing to set up the cluster service

Before you can create the cluster service, you must perform the following steps.

To configure your system for the cluster service

1. Install the Cluster Administrator using Add/Remove Windows Components from the Control Panel.
2. Install a local copy of Adaptive Server Anywhere on each node participating in the failover cluster.
3. Create a domain account called ASAService to run the Adaptive Server Anywhere database server service under.
4. Grant the ASAService domain account Log on as Service user rights on all nodes participating in the failover cluster.
5. Set up a cluster share. In this document the cluster share name is called Public Disk and has a share name called public.
6. Create a directory on the shared cluster disk (in this example it is called ASA).
7. Grant the domain account ASAService full rights to the SQL Anywhere Studio installation directory.

Overview of creating a cluster service

1. Use the Service Creation utility (dbsvc) to create the local service.
2. Use the Cluster Administrator to define the cluster service.
3. Use the Cluster Administrator to bring the cluster service online.

To create a cluster service

1. Create a local service on this cluster node by executing the following command at a command prompt:
   

   Option	Description
   -a bmdomain\asaservice	The domain account name to use. You must specify the domain account name in the form domain\userid.
   -p admin	The password for the domain account.
   -s Manual	The service startup option.
   -t Network	The type of service.
   -w ASADBService	The name of the service being created.
   "C:\Program Files\Sybase\SQL Anywhere 9\win32\dbsrv9.exe"	The path and file name of the executable.
   -n ASADBSRV	The name of the database server.
   -x tcpip	The protocol used to start the database server listening.
   -o \\vmcluster\public\ASA\ASADBSRV.log	The database server console log file.
   \\vmcluster\public\ASA\MyDB.db	The path and file name of the database to start.

2. Test if database server starts using the following command:
   
   dbsvc -u ASADBService

3. If the database server starts correctly, dbsrv9.exe appears in the list of processes on the Task Manager’s Processes tab.
4. Stop the database server with the following command:
   dbsvc -x ASADBService

5. Start the Cluster Administrator. From the Start menu, choose Settings > Control Panel. In the Control Panel, double-click Administrative Tools and then double-click Cluster Administrator.

   

6. In the left pane, right-click Resources and choose New > Resource from the popup menu.

   

7. Enter the following values in the New Resource dialog:
   • Name Type a name that the cluster will know the Adaptive Server Anywhere service by, for example, ASA Cluster Service.

   • Resource Type Choose Generic Service from the dropdown list.

   • Group Ensure Cluster Group is selected.

   

8. Add all the possible owners (cluster nodes) this cluster service can run on and then click Next.

   

9. Add the following Resource Dependencies and then click Next.
   • Cluster IP Address

   • Cluster Name

   • Disk Q: (Quorum Disk)

   • Disk S: (Physical Disk)

   • Public Disk (Share point for S:)

   

10. Type the service name in the Service Name field. Use the following formula to obtain the service name:
    ASANYs_the-service-name-typed-in-dbsvc

    For example, if you entered ASADBService as the name in the Create a New Service wizard in step 7, the service name would be ASANYs_ASADBService.
    Leave the Start Parameters field blank and select the Use Network Name for Computer Name option and then click Next.

    

11. Click Finish to complete the wizard.

    

12. Click OK to create the cluster service.
13. The new cluster service appears in the Cluster Administrator, but is in an offline state.

    

14. To bring the cluster service online, right-click ASA Cluster Service and choose Bring Online from the popup menu.
    The yellow exclamation mark disappears and the status changes from Offline to Online.

    

15. To set the cluster service on the other nodes in the failover cluster, repeat step 1 on each node in the cluster.
16. To test the failover, power off the node that is currently running the ASAService. The ASAService should start on one of the other nodes.