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

Table 19 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 20 (page 92), assigns
values to the package "mysql_1".
Table 20 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 21 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
92 Using MySQL Toolkit in a HP Serviceguard Cluster