Install the Cluster Service Script
To set up the cluster service for the Actian X database, follow these steps:
1. Install Actian X onto a shared disk, visible to all nodes to be used for failover. For example:
$ sudo -s
$ II_HOSTNAME=clustername ./express_install.sh HA /sharedisk1/IngresHA -licdir /sharedisk1/path_to_license.xml
2. After the DBMS setup portion of the installation process completes, set the II_HOSTNAME environment variable to the cluster name. For example:
ingsetenv II_HOSTNAME=clustername
3. Edit ~/.ingXXsh so that the host name will be set on each node. Insert at the beginning:
II_HOSTNAME=clustername
export II_HOSTNAME
4. Log in as the instance owner and source the instance environment.
$ ~/.ingXXsh
where XX is the Actian X instance ID.
5. Generate and install RC service scripts:
Actian X:
$ source ~/.ingXXsh
$ mkrc
$ su -c "$II_SYSTEM/ingres/utility/mkrc -i"
Edit the RC script to include the cluster name. Edit /etc/init.d/ingresXX and insert the following line after export II_SYSTEM=/opt/Actian/IngresXX:
export II_HOSTNAME=clustername
Management Server for Actian Director (if installed):
$ source ~/.ingXXsh
$ mkrc -s iimgmtsvc
$ su -c "$II_SYSTEM/ingres/utility/mkrc -s iimgmtsvc -i"
Edit the RC script to include the cluster name. Edit /etc/init.d/iimgmtsvcXX and insert the following line after export II_SYSTEM=/opt/Actian/IngresXX:
export II_HOSTNAME=clustername
6. Generate the HA service script:
$ source ~/.ingXXsh
$ mkrc -s ha
7. As root, install the HA service script:
$ su -c "$II_SYSTEM/ingres/utility/mkrc -s ha -i"
8. For each node in the cluster, copy the installation environment script to the 'ingres' home directory and the RC scripts to /etc/init.d/:
$ scp ~/.ingXXsh clusternode2:/home/ingres
The cluster service is configured.
9. 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.
You should be able to start, display the status, and stop the DBMS on each node:
# systemctl start ha_ingresXX
# systemctl status ha_ingresXX
# systemctl stop ha_ingresXX
10. Add the ha_ingresXX service script into the cluster configuration as a resource.
Last modified date: 01/30/2023