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

5 Using MySQL Toolkit in a HP Serviceguard Cluster

This chapter describes the MySQL Toolkit for use in the HP Serviceguard environment. The ideal

audience is of those who want 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.

It is assumed that readers are already familiar with the HP Serviceguard cluster configuration as

well as 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

At the time of publication, this version supports the above mentioned SG, application, and HP-UX

versions. More recent 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 .

NOTE: 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 in case of legacy packages and Serviceguard master control

script in case of modular packages. Each MySQL Database server instance is configured in its

own Serviceguard package. This chapter assumes that users have used swinstall to properly install

both Serviceguard and the Enterprise Cluster Master Toolkit (ECMT), which includes the scripts for

MySQL.

For legacy packages, there will be 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 mentioned above for legacy packages to integrate MySQL with the

Serviceguard Master Control Script.

During ECMT installation, you can use the files listed in Table 13 (page 87). The following files

are located in: /opt/cmcluster/toolkit/mysql.

Table 13 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 in case of legacy

packages and interface between the Serviceguard master control script and hamysql.sh in case

of modular packages.

toolkit.sh