Using MySQL Toolkit in a HP Serviceguard Cluster Revision README: B.06.00

- Create a soft link named "mysqld_safe" in the MySQL

installation directory (typically /usr/bin for RH" to

point to "safe_mysqld"

CMD> ln -s /usr/bin/mysqld_safe /usr/bin/safe_mysqld

- Grant the execute permission to the newly created link.

CMD> chmod 755 mysqld_safe

=====================================================================

NOTE: The following sections in this document describe the legacy mode

of Serviceguard packages. For information on creating the

Serviceguard package using the modular method, please refer to the

whitepaper "Modular package support in Serviceguard for Linux and

ECM Toolkits" at http://docs.hp.com/en/ha.html

C.3 Toolkit Configuration File (hamysql.conf)

All the toolkit user configuration variables are stored in a single

file - hamysql.conf, in Shell script format. User variables and

sample values are included below:

1. CONFIGURATION_FILE_PATH="/MySQL_1/mysql/my.cnf"

DATA_DIRECTORY="/MySQL_1/mysql"

Only one of the two variables (either CONFIGURATION_FILE_PATH or

DATA_DIRECTORY) should be defined. If both are defined,

CONFIGURATION_FILE_PATH is used and DATA_DIRECTORY is ignored.

NOTE: If DATA_DIRECTORY is used, "my.cnf" MUST reside in the

DATA_DIRECTORY location. This directory is also used as the

data directory for this instance of the database server.

2. PID_FILE="/var/run/mysql/mysqld.pid"

This is the path where PID file for the MySQL daemon is created for

the Parent PID. If this variable is defined, it overrides the

"pid-file" defined in the MySQL configuration file "my.cnf". The

PID identified in this file is monitored by the toolkit monitor,

"hamysql.mon".

3. MAINTENANCE_FLAG ( For example: MAINTENANCE_FLAG="yes")

This variable will enable or disable maintenance mode for the MySQL

package. By default this is set to "yes". In order to disable this

feature MAINTENANCE_FLAG should be set to "no". When MySQL needs to

be maintained the file "<package directory>/mysql.debug" needs to be

touched. During this maintenance period MySQL process monitoring is

paused. Even if the MySQL instance is brought down the package will