HP Enterprise Cluster Master Toolkit User Guide (5900-2131, December 2011)

MySQL Configuration File (my.cnf)
The following parameters are contained in the configuration file /etc/my.cnf. This file must be
copied to the file system on the shared storage (in our for example, /etc/my.cnf would be
copied to /MySQL_1/my.conf). Then parameters need to be manually set with unique values
for each DB instance configured.
Table 18 Parameters in MySQL Configuration File (my.cnf)
DescriptionFile/Directory name
[mysqld]
# Data Directory for MySQL DBdatadir=/MySQL_1/
mysql
# Socket file for Clientsocket=/MySQL_1/
mysql/mysql.sock
# Communication
# Port Number for Clientport=3310
# Communication
[mysqld_safe]
# Safe-mysqld'serr-log=/MySQL_1/
mysql/mysqld.
# Error Log file
# pid file Pathpid-file=/etc/
cmcluster/pkg/
MySQL1/mysqld.pid
NOTE: mysqld_safe was previously known as safe_mysqld. For an older version of MySQL,
the user needs to modify suitable sections in the my.cnf file.
To run MySQL toolkit with the older versions of the MySQL follow the steps below:
1. 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
2. Grant the execute permission to the newly created link:
CMD> chmod 755 mysqld_safe
The following sections in this chapter describe the legacy mode of Serviceguard packages. For
information on creating the Serviceguard package using the modular method, see the whitepaper
Modular package support in Serviceguard for Linux and ECM Toolkits available at http://
www.hp.com/go/hpux-serviceguard-docs —>HP Serviceguard Enterprise Cluster Master Toolkit.
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, in Table 19 (page 91).
Table 19 User Variables in hamysql.conf file
DescriptionFile name
Only one of the two variables (either CONFIGURATION_FILE_PATH
or DATA_DIRECTORY) should be defined. If both are defined,
CONFIGURATION_FILE_PATH="/MySQL_1/mysql/my.cnf"
or DATA_DIRECTORY="/MySQL_1/mysql"
CONFIGURATION_FILE_PATH is used and DATA_DIRECTORY is
ignored.
Setting Up MySQL with the Toolkit 91