HP Serviceguard Enterprise Cluster Master Toolkit User Guide (5900-2145, April 2013)

To run MySQL in a HP Serviceguard environment:
1. Install the same version of MySQL Database Server software on each node.
2. Place the configuration files on shared storage that is accessible to all nodes. Each node that
is configured to run the package must have access to the configuration files.
3. Configure a unique configuration for each database in multiple databases of the same cluster.
Each DB instance will require its own volume group, set of configuration files, and copy of
the toolkit customized for the unique instance.
4. All data files must be accessible to all nodes configured to run the package. This means that
all data files will need to reside on shared storage that is accessible to all nodes.
5. Assign an IP address called the relocatable (or package) IP address to each package.
6. On a Primary Node
When the package fails over from one node to another, the following actions occur:
1. The package is halted on the node where it is currently running. As a result, all (package)
resources are halted.
2. The relocatable IP address is removed from this node.
3. File systems are unmounted and all volume groups that are assigned to this package are
deactivated.
On a Standby Node
1. Volume groups are activated and file systems are mounted.
2. The relocatable IP address is moved over to the new node.
3. All resources are started up, and the database is brought up.
4. Clients continue to connect through the same (relocatable) IP address.
Multiple Database Instances
MySQL database server supports multiple DB instances running on the same node. Using the toolkit,
you can configure multiple MySQL packages to run on the same node. One copy of the toolkit
can serve one package. Therefore, to configure multiple packages, you must create separate
directories, that is, one directory per package and configure each package to run a unique database
instance.
Setting Up the Database Server Application
Before creating the packages, you must configure the shared storage and create the database.
For the volume group (VG) and file system creation, see the section Building an HA Cluster
Configuration in the latest Managing Serviceguard manual available at http://www.hp.com/go/
hpux-serviceguard-docs —>HP Serviceguard. Create a unique VG and filesystem on shared storage
for each instance of the DB to be included in the configuration.
On each node, create a mount point for each filesystem. The mount point for a specified
instance/package must be the same for all nodes.
The following example shows a configuration of MySQL for a filesystem named “/MySQL_1" on
/dev/vg01.
1. Consider that LVM has been set up on the shared storage, create a filesystem (for example,
/MySQL_1) on the LV and mount point (for example,., /MySQL_1) on each of the nodes to
mount the filesystem. For more information on creating the VG and filesystem, see the section
Building an HA Cluster Configuration in the latest Managing Serviceguard manual available
at http://www.hp.com/go/hpux-serviceguard-docs —>HP Serviceguard .
2. For more information to create a database on the lvol in /MySQL_1, see the documentation
for MySQL , available at http://www.mysql.com/documentation/mysql/bychapter/
manual_Tutorial.html#Creating_database.
90 Using MySQL Toolkit in a HP Serviceguard Cluster