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

cmmodpkg -e -n node1 -n node2 mysql_1
cmmodpkg -e mysql_1
11. If the package does not start, to start the package run the cmrunpkg command.
cmrunpkg mysql_1
Repeat these procedures to create multiple MySQL instances running in the Serviceguard
environment.
Database Maintenance
At regular intervals, the MySQL database needs maintenance like changing configuration, without
migrating the instance to migrate to standby node. Follow the procedure during database
maintenance:
NOTE: The package name is mysql_1, package directory is /etc/cmcluster/pkg/MySQL1
and the MySQL DATADIR is configured as/MySQL_1/mysql.
• Disable the failover of the package through the cmmodpkg command.
$ cmmodpkg -d mysql_1
• Pause the monitor script.
Create an empty file /etc/cmcluster/pkg/MySQL1/mysql.debug as shown below:
$ touch /etc/cmcluster/pkg/MySQL1/mysql.debug
Toolkit monitor script which continuously monitors MySQL process, would now stop monitoring
this daemon process. A message "MySQL toolkit pausing monitoring and entering maintenance
mode" appears in the Serviceguard Package Control script log.
• If required, stop the MySQL database instance as shown below:
$ /etc/cmcluster/pkg/MySQL1/toolkit.sh stop
• Perform maintenance actions (For example, changing the configuration parameters in the
parameter file of the MySQL instance. If this file is changed, remember to distribute the new
file to all cluster nodes).
• Start the MySQL database instance again if you stopped it:
$ /etc/cmcluster/pkg/MySQL1/toolkit.sh start
• Allow monitoring scripts to continue normally as shown below:
$ rm -f /etc/cmcluster/pkg/MySQL1/mysql.debug
A message "Starting MySQL toolkit monitoring again after maintenance" appears in the
Serviceguard Package Control script log.
• Enable the package failover.
$ cmmodpkg -e mysql_1
Database Maintenance 95