Serviceguard Toolkits for Contrib User Guide Version A.12.00.00

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 3 MySQL toolkit files
Available in directoryDescriptionFile name
$SGROOT/mysqltoolkitThis 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
$SGCONF/modules/tkit/mysqlThese are attribute definition files used
to generate package ASCII templates
in modular style of packaging.
mysql.1
mysql.2
$SGCONF/scripts/tkit/mysqlThis is the module script. This script is
called by the master control script and
tkit_module.sh
acts as an interface between the
master control script and the toolkit
interface script (toolkit.sh).
Setting up the MySQL server in SG/LX environment
Before creating the packages, you must configure the shared storage and create the database.
14 MySQL Toolkit