HP Serviceguard Contributed Toolkit Suite Version A.04.02.02 on Linux User Guide (December, 2012)

3 MySQL Toolkit
Overview
HP Serviceguard toolkit for MySQL on Linux (MySQL toolkit) enables you to configure MySQL
database server application in an SG/LX cluster environment. The MySQL toolkit consists of a set
of shell scripts that are used by the package control script to start, stop, and monitor the MySQL
database server. The toolkit simplifies the task of integrating MySQL with SG/LX.
Advantages
When MySQL toolkit is deployed in an SG/LX environment, the following are the advantages:
• Provides monitoring for MySQL daemons.
• Enables easy integration of MySQL Server in an SG/LX environment.
• Provides high availability for the MySQL Server.
Prerequisites
MySQL toolkit package requires the following to function:
• HP Serviceguard on Linux must be installed on all the nodes that must be configured in the
cluster.
• The toolkit must be installed on all the target nodes, where the package is configured to run.
• MySQL server must be installed and the database configured on the storage that is shared
between all the nodes that are configured to run the database.
Files and directories created for MySQL toolkit after installation
The following table describes the scripts installed as part of the MySQL installation.
Table 7 Files created after MySQL toolkit is installed
Available in directoryDescriptionFile name
$SGROOT/mysqltoolkitThis is the toolkit configuration file. It
contains a list of pre-defined variables
hamysql.conf
that must be set for your unique
environment.
This is the toolkit interface script that
acts as an interface between the
toolkit.sh
package control script and the toolkit
main script, hamysql.sh.
This is the toolkit main script that
contains internal functions that start or
stop a MySQL instance.
hamysql.sh
This is the toolkit monitor script that
contains internal functions for
monitoring a DB server instance.
hamysql.mon
20 MySQL Toolkit