HP Serviceguard Linux Contributed Toolkit Suite A.04.02.01 User Guide (696979-001, June 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.
Installing and uninstalling MySQL toolkit
The MySQL toolkit is bundled within the Serviceguard on Linux Contributed toolkit suite. The MySQL
toolkit must be installed on all the nodes of the cluster that are configured to run the MySQL web
server package.
NOTE: Before you install this version of the toolkit, you must verify and remove any earlier version
of this toolkit that might be installed on the system.
To search for an earlier version of MySQL toolkit, run:
# rpm –qa | grep mysql-toolkit
To remove the earlier version, run:
# rpm –e <toolkit name retrieved after executing the # rpm –qa | grep
mysql-toolkit>
To ensure that the earlier version of the MySQL toolkit is removed from all the configured nodes
of the cluster, run the # rpm –qa command on all the nodes configured to run the MySQL web
server package.
To install the MySQL toolkit on Red Hat, run:
# rpm –ivh serviceguard-mysql-toolkit-<release_version>.redhat.noarch.rpm
The MySQL toolkit is installed at the following directory:
${SGCONF}/mysqltoolkit
NOTE: To verify the MySQL toolkit installation, you can either run the # rpm –qa | grep
mysql-toolkit command, or you can check if all the toolkit scripts are present in the toolkit
installation directory ${SGCONF}/mysqltoolkit.
Overview 19