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

Shared Storage
• A shared storage system is set up, such as an HP StorageWorks disc array. This shared
storage is located in the /dev/sdx directory on each server. For the test example, the directory
/dev/sdb is used on both servers. Set up the lock logical unit number (LUN) and logical
volumes (LV) on the external shared storage using the following specifications:
Cluster_Lock_LUN:
DEVICE Name /dev/sdx1
Size 10MB
Logical Volumes:
PV Name /dev/sdx2
LV Name /dev/vg/lv
VG Name /dev/vg
LV Size 50.00 GB
Mount Point /mysql
Filesystem Type ext3
For more information about Lock LUN, see Managing Serviceguard at http://docs.hp.com/en/
ha.html#Serviceguard
Installing HP Serviceguard
Install HP Serviceguard on all the nodes that are included in the cluster. It is assumed you know
how to install HP Serviceguard. For more information on the HP Serviceguard installation, see
Managing Serviceguard and Installing MC/ServiceGuard in Managing MC/Serviceguard at http://
docs.hp.com/en/ha.html#Serviceguard
Configuring MySQL
Configure MySQL on shared storage. For more information, see the README file at /opt/
cmcluster/mysqltoolkit/README.
Installing and Configuring the MySQL Toolkit
A MySQL toolkit is not available for the HP-UX Serviceguard. The MySQL toolkit used here is
modified from the toolkit for Linux Serviceguard. The following procedure describes how to
install, modify and configure the toolkit for HP-UX:
1. Extract the toolkit files on a Linux system and copy to HP-UX.
a. Extract the contents of mysql-toolkit-*.rpm into the present working directory
under ./opt/cmcluster/mysqltoolkit, using the following command:
#rpm2cpio mysql-toolkit*.rpm | cpio –idmv
b. Copy the extracted files from Linux to HP-UX, using the following command:
#rcp -rp ./usr/local/cmcluster/mysqltoolkit
root@node1:/opt/cmcluster
where node1 is the HP-UX node where Serviceguard is configured.
2. Edit hamysql.mon to use the ps command to get the proc details, as HP-UX has no /proc/
PID/stat file.
Replace the line grep $1 /proc/$2/stat >/dev/null with ps -p $2 | grep -v
'PID TTY' | grep $1 > /dev/null
3. Edit hamysql.mon to use the sleep command, as usleep is not available on hp-ux.
Replace usleep with sleep.
4. Change the bash shell to ksh in all the toolkit files.
MySQL High Availability Using HP Serviceguard 37