Install the Cluster Service Script
To set up the cluster service for the Ingres database, follow these steps:
1. Install Ingres onto a shared disk, visible to all nodes to be used for failover. For example:
$ sudo -s
$ II_HOSTNAME=clustername ./ingres_ install.sh HA /sharedisk1/IngresHA
2. Log in as the instance owner and source the instance environment:
$ ~/.ingXXsh
where XX is the Ingres instance ID.
3. If necessary, generate and install RC service scripts:
Ingres
$ source ~/.ingXXsh
$ mkrc
$ su -c "$II_SYSTEM/ingres/utility/mkrc -i"
Management Server for Actian Director (if installed)
$ source ~/.ingXXsh
$ mkrc -s iimgmtsvc
$ su -c "$II_SYSTEM/ingres/utility/mkrc -s iimgmtsvc -i"
4. Generate the HA service script:
$ source ~/.ingXXsh
$ mkrc -s ha
5. As root, install the HA service script:
$ su -c "$II_SYSTEM/ingres/utility/mkrc -s ha -i"
6. For each node in the cluster, copy the installation environment script to the 'ingres' home directory and repeat steps 3, 4, and 5:
$ scp ~/.ingXXsh clusternode2:/home/ingres
The cluster service is configured.
7. Verify the script has been installed correctly:
$ ls -l /etc/init.d/ha_ingresXX
-rwxr-xr-x. 1 root root 1064 May 29 19:34 /etc/init.d/ha_ingresXX
$ chkconfig ha_ingresXX --list
ha_ingresXX 0:off 1:off 2:off 3:off 4:off 5:off 6:off
Note: It should be off by default.
8. Add the ha_ingresXX service script into the cluster configuration as a resource.