HP OSMS Blueprint: HP Manageability Value-Add Software for Open Source Middleware Stacks
When the package fails over from one node to another, the following actions occur:
• On the primary node:
— The package is halted on the node where it is currently running. As a result, all package
resources are halted.
— The relocatable IP address is removed from this node.
— The file systems are unmounted and all volume groups assigned to this package are
deactivated.
— The systems are going to halt when the storage or networks fail.
• On the standby node:
— The volume groups are activated and file systems are mounted.
— The relocatable IP address is moved to the new node.
— All resources are started up, and the database is displayed.
— The clients connect through the same relocatable IP address.
Installation and Configuration
Before performing the HP Serviceguard installation, verify that the following installation and
configurations have been completed:
System Environment Set up two or more Linux systems, all connected to the appropriate
external hardware for a shared data drive. These systems act as the
MySQL Serviceguard cluster used in the following test example.
For example, these may be two or more HP ProLiant or Integrity
servers.
Set up an additional server to test the MySQL Serviceguard cluster.
This server has the MySQL database installed, as well as the MySQL
bench testing tool, also called sql-bench.
Shared Storage Set up a shared storage system, such as an HP StorageWorks MSA
1000, MSA 1500, EVA3000, or EVA 4000 system. 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. You must
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 the document Managing HP Serviceguard for Linux
located at:
http://docs.hp.com/en/B9903-90046/index.html
SG/LX Installation
You have installed SG/LX on all the nodes that are included in the cluster.
For more information on the SG/LX installation, see the document Managing HP Serviceguard for
Linux located at:
http://docs.hp.com/en/B9903-90046/index.html
MySQL High Availability Using HP Serviceguard 17