HP Serviceguard Enterprise Cluster Master Toolkit User Guide, December 2012 (5900-2145)

NOTE:
• Repeat these steps to create multiple EDB instances running in the Serviceguard environment.
• EnterpriseDB supports multiple EnterpriseDB instances running on the same node. Each instance
of EnterpriseDB must start on a unique port name. Use this toolkit to configure and run the
multiple EnterpriseDB packages on the same node. This toolkit is a template for creating a
standard modular package for EnterpriseDB PPAS. So, to configure multiple packages, you
must create separate directories, that is, one directory per package, and configure each
package to run a unique EnterpriseDB instance. Each EDB instance must have a unique
DB_DATA_DIR, DB_LOG_FILE, and TKIT_DIR.
• After you configure the EnterpriseDB toolkit packages, move the EDB startup script in the
/sbin/init.d directory using the following command on all the cluster nodes:
◦ mv /sbin/init.d/ppas-9.0 /sbin/init.d/ppas-9.0.old
◦ mv /sbin/init.d/ppasAgent-90 /sbin/init.d/ppasAgent-90.old
Managing Packages
You can manage packages by maintaining, halting, or deleting them.
Maintaining packages
Serviceguard normally monitors critical Enterprise DB processes, but there might be situations when
a planned maintenance task (e.g., changing the configuration) is required that affects those
monitored processes. The maintenance flag can be used to signal to Serviceguard that it should
not failover the Enterprise DB instance to an adoptive node.
To set a package to the maintenance mode:
NOTE: In the following steps, consider:
• Package name: EDB
• Package directory: /etc/cmcluster/EDB
• EnterpriseDB DB_DATA_DIR: /EDB/data
1. Disable the failover of the package using the cmmodpkg command.
$ cmmodpkg -d EDB
2. Pause the monitor script.
3. Create an empty file /etc/cmcluster/EDB/edb.debug using the following command:
$ touch /etc/cmcluster/EDB/edb.debug
The HP Serviceguard Toolkit for EnterpriseDB PPAS monitor script, which continuously monitors
EnterpriseDB process, now, stops monitoring the server process. The HP Serviceguard toolkit
logs the message “EnterpriseDB PPAS toolkit pausing monitoring, and entering maintenance
mode” in the Serviceguard package control script log.
4. Optional: Stop the EnterpriseDB database instance.
5. Perform maintenance actions, and then start the EDB database instance, if you stopped it.
6. Allow the monitoring scripts to continue:
$ rm -f /etc/cmcluster/EDB/edb.debug
The HP Serviceguard toolkit logs the message “Starting EnterpriseDB PPAS instance monitoring
again after maintenance” in the Serviceguard package control script log.
140 Using HP Serviceguard Toolkit for EnterpriseDB PPAS in an HP Serviceguard Cluster