HP Serviceguard Enterprise Cluster Master Toolkit User Guide, June 2014

5 Using MySQL Toolkit in a HP Serviceguard Cluster
This chapter describes the method to configure the MySQL Database Server application toolkit
under HP Serviceguard cluster environment using MySQL Toolkit. This toolkit supports the Enterpise
MySQL Database Server Application 5.0.56 and later.
You must be familiar with the HP Serviceguard cluster configuration and MySQL Database server
concepts and their installation and configuration procedures.
NOTE: This toolkit supports:
• HP Serviceguard versions
◦ A.11.19
◦ A.11.20
• HP-UX 11i v2 and HP-UX 11i v3
• The latest versions of these products may be certified with B.06.00. For the latest information,
see the compatibility matrix available at http://www.hp.com/go/hpux-serviceguard-docs
—>HP Serviceguard
• This version of the toolkit supports both, legacy and modular style packages, but this version
of the toolkit is not supported with VxVM and CFS
This toolkit consists of a set of shell scripts used by a Package Control Script to start, stop, and
monitor the MySQL Database Server. The toolkit works with the Serviceguard package control
script, managed by Serviceguard for legacy packages and Serviceguard master control script in
case of modular packages. Each MySQL Database server instance is configured in its own
Serviceguard package.You must know the use of swinstall to properly install both Serviceguard
and the Enterprise Cluster Master Toolkit (ECMT), which includes the scripts for MySQL.
For legacy packages, there is one user configuration script (hamysql.conf) and three functional
scripts (toolkit.sh, hamysql.sh, hamysql.mon) which work with each other to integrate
MySQL with the Serviceguard package control scripts.
For modular packages, there is an Attribute Definition File (ADF), a Toolkit Module Script
(tkit_module.sh) and a Toolkit Configuration File Generator Script (tkit_gen.sh) which
work with the four scripts hamysql.conf, toolkit.sh, hamysql.sh and hamysql.mon for legacy packages
to integrate MySQL with the Serviceguard Master Control Script.
For ECMT installation, you must use the files listed in Table 12 (page 88). The following files are
located in: /opt/cmcluster/toolkit/mysql.
Table 12 Files in Legacy Packages in MySQL
DescriptionFile Name
The contents of the README file have been moved to this user guide.README
User defined variables for configuring MySQL in a specific environment.hamysql.conf
The main shell script.hamysql.sh
Script to monitor MySQL to ensure it is running.hamysql.mon
Interface between the Serviceguard package control script and hamysql.sh for legacy packages,
and interface between the Serviceguard master control script and hamysql.sh for modular packages.
toolkit.sh
The following three files mysql.1, tkit_module.sh, and tkit_gen.sh are also installed
and they are used only for the modular method of packaging.
88 Using MySQL Toolkit in a HP Serviceguard Cluster