HP-UX OSRA for Web Services 2.5 Blueprint and Configuration Guide

5. Add /usr/local/bin to the PATH in hamysql.sh and hamysql.mon.
Replace PATH=/bin:/usr/bin:/sbin:/usr/sbin:$SGSBIN with
PATH=/bin:/usr/bin:/sbin:/usr/sbin:$SGSBIN:$PATH:/usr/local/bin
6. Configure the MySQL Serviceguard Cluster package on all target nodes with the toolkit
using the following values:
MySQL Cluster:
PACKAGE Name MySQL_PKG
Relocatable IP address 10.101.0.251
For more information about the toolkit configuration, see Using MySQL Toolkit in a ServiceGuard
for Linux Cluster at http://docs.hp.com/en/ha.html#Serviceguard%20for%20Linux%20Toolkits
Testing the MySQL Serviceguard Cluster
The MySQL toolkit README file describes how to test High Availability with the MySQL Toolkit
in a Serviceguard environment. The file is located in the /opt/cmcluster/toolkit/
mysqltoolkit directory.
Testing the Cluster Connection
Perform the following steps from the external test system:
1. Grant the required privileges to the sample database user to allow access to the MySQL
database service from the third machine. For example, enter the grant command as follows:
grant all privileges on osradb.* to 'osrausr'@'%' identified by
'osrapass';
2. On the test machine, verify the MySQL connection by entering the following command:
# mysqladmin –h
Testing Cluster Failover
CAUTION: Perform the following tests with sample data before trying the tests with critical
production data. In the event of a serious failure or the wrong configuration, data corruption
can occur.
To verify the MySQL Serviceguard cluster failover function, simulate some of the following
cases, which cause primary-node failure:
• End the primary node's MySQL processes.
• Pull the power cable out on the primary node to cause a power failure.
• Pull the network cable out on the primary node to cause the loss of a network.
• Issue the power off and reboot commands on the primary node.
• End all HP Serviceguard processes on the primary node.
In the event of a failure on the primary node, the package automatically fails over to the standby
node and the database continues to function. To verify a successful fail over, access the MySQL
database service when the primary node fails.
Backing Up MySQL Using HP Data Protector
This section provides an example of implementing a backup strategy for a MySQL database
installation using HP OpenView Storage Data Protector (Data Protector).
A database backup strategy is a critical part of any database installation. The MySQL database
backup strategy is a two-part process: extract data from the database and use a backup tool to
store the data to backup media, such as tape media or network storage.
38 MySQL Tools and Tips