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

File Name

Description

 

 

README

The contents of the README file have been moved to this user guide.

 

 

hamysql.conf

User defined variables for configuring MySQL in a specific environment.

 

 

hamysql.sh

The main shell script.

 

 

hamysql.mon

Script to monitor MySQL to ensure it is running.

 

 

toolkit.sh

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.

 

 

87