HP Serviceguard Enterprise Cluster Master Toolkit User Guide (5900-2145, April 2013)

Table 18 User Variables in hamysql.conf file (continued)
DescriptionFile name
This variable enables or disables maintenance mode for the MySQL
package. By default, this is set to "yes". To disable this feature
MAINTENANCE_FLAG (for example,
MAINTENANCE_FLAG="yes")
MAINTENANCE_FLAG must be set to "no". When MySQL needs
maintenance, the file <package directory>/mysql.debug
must be created. During this maintenance period, the MySQL process
monitoring is paused. Even if the MySQL instance is brought down
the package does not failover over to the adoptive node. To continue
monitoring and turn off maintenance mode, you must remove the
mysql.debugfile. You must ensure that the MySQL instance is
running properly before exiting the maintenance phase, because
monitoring of the instance resumes when it is out of the maintenance
phase.
This variable is recommended to be set to "0". This will multiply the
SERVICE_RESTART of the MySQL package service (monitor).
RETRY_TIMES=0
For example, If the package service is set to SERVICE_RESTART = 2
& RETRY_TIMES=2 then actual retries = (SERVICE_RESTART + 1) *
RETRY_TIMES.
This is the interval at which hamysql.mon monitors the process with
PID in the PID_FILE (mysqld parent process).
MONITOR_INTERVAL=5 # Seconds.
The time unit granularity is seconds. Therefore, setting MONITOR_INTERVAL=5 means the parent
process is monitored every 5 seconds.
Package Configuration File and Control Script
The following steps identify the changes needed to the Serviceguard package configuration file
and control script templates to customize them for your specific configuration. For more information,
see the "Configuring Packages and Their Services" of the Managing Serviceguard manual available
at http://www.hp.com/go/hpux-serviceguard-docs —>HP Serviceguard manual. For detailed
information on configuring and managing a package, see the "Managing Serviceguard" manual.
The parameters in Table 20 are either in the configuration file or control script as identified in the
table, and must be manually edited for your unique environment. Table 19 (page 93), assigns
values to the package "mysql_1".
Table 19 Package Configuration File Parameters
DescriptionConfiguration file
Parameter Name [configuration
file parameters]
# Package Namemysql_1PACKAGE_NAME
# nodes that can run the packagenode1, node2NODE_NAME NODE_NAME
Script to start up the service<control script>RUN_SCRIPT
# Script to halt the service<control script>HALT_SCRIPT
# Service Name"mysql_monitor"SERVICE_NAME
Table 20 Package Control Script Parameters
DescriptionControl script
Parameter Name [control script
parameters]
# VG created for this packagevgMySQLVG
# Logical vol created in VT/dev/vgMySQL/lvol1LV
# File system for DB/MySQL_1FS
Package Configuration File and Control Script 93