HP Serviceguard Enterprise Cluster Master Toolkit User Guide (5900-2145, April 2013)
Table Of Contents
- HP Serviceguard Enterprise Cluster Master Toolkit User Guide
- Contents
- 1 Introduction
- 2 Using the Oracle Toolkit in an HP Serviceguard Cluster
- Overview
- Supported Versions
- Support for Oracle Database Without ASM
- Supporting Oracle ASM Instance and Oracle Database with ASM
- What is Automatic Storage Management (ASM)?
- Why ASM over LVM?
- Configuring LVM Volume Groups for ASM Disk Groups
- Sample command sequence for configuring LVM Volume Groups
- Serviceguard support for ASM on HP-UX 11i v3 onwards
- Framework for ASM support with Serviceguard
- Installing, Configuring, and Troubleshooting
- Setting up DB instance and ASM instance
- Setting up the Toolkit
- ASM Package Configuration Example
- Modifying a Legacy Database Package Using an Older Version of Oracle ECMT Scripts to use the Scripts Provided for ASM Support
- Adding the Package to the Cluster
- Node-specific Configuration
- Error Handling
- Network Configuration
- Database Maintenance
- Configuring and packaging Oracle single-instance database to co-exist with SGeRAC packages
- Configuring Oracle single-instance database that uses ASM in a Coexistence Environment
- Attributes newly added to ECMT Oracle toolkit
- Configuring a modular failover package for an Oracle database using ASM in a coexistence environment
- Configuring a legacy failover package for an Oracle database using ASM in a Coexistence Environment
- ECMT Oracle Toolkit Maintenance Mode
- Supporting EBS database Tier
- Oracle ASM Support for EBS DB Tier
- 3 Using the Sybase ASE Toolkit in a Serviceguard Cluster on HP-UX
- Overview
- Sybase Information
- Setting up the Application
- Setting up the Toolkit
- Sybase Package Configuration Example
- Creating the Serviceguard package using Modular method
- Adding the Package to the Cluster
- Node-specific Configuration
- Error-Handling
- Network configuration
- Database Maintenance
- Cluster Verification for Sybase ASE Toolkit
- 4 Using the DB2 Database Toolkit in a Serviceguard Cluster in HP-UX
- 5 Using MySQL Toolkit in a HP Serviceguard Cluster
- MySQL Package Configuration Overview
- Setting Up the Database Server Application
- Setting up MySQL with the Toolkit
- Package Configuration File and Control Script
- Creating Serviceguard Package Using Modular Method
- Applying the Configuration and Running the Package
- Database Maintenance
- Guidelines to Start Using MySQL Toolkit
- 6 Using an Apache Toolkit in a HP Serviceguard Cluster
- 7 Using Tomcat Toolkit in a HP Serviceguard Cluster
- Tomcat Package Configuration Overview
- Multiple Tomcat Instances Configuration
- Configuring the Tomcat Server with Serviceguard
- Setting up the Package
- Creating Serviceguard Package Using Modular Method
- Setting up the Toolkit
- Error Handling
- Tomcat Server Maintenance
- Configuring Apache Web Server with Tomcat in a Single Package
- 8 Using SAMBA Toolkit in a Serviceguard Cluster
- 9 Using HP Serviceguard Toolkit for EnterpriseDB PPAS in an HP Serviceguard Cluster
- 10 Support and Other resources
- 11 Acronyms and Abbreviations
- Index
5 Using MySQL Toolkit in a HP Serviceguard Cluster
This chapter describes the method to configure the MySQL Database Server application toolkit
under HP Serviceguard cluster environment using MySQL Toolkit. This toolkit supports the Enterpise
MySQL Database Server Application 5.0.56 and later.
You must be familiar with the HP Serviceguard cluster configuration and MySQL Database server
concepts and their installation and configuration procedures.
NOTE: This toolkit supports:
• HP Serviceguard versions
◦ A.11.19
◦ A.11.20
• HP-UX 11i v2 and HP-UX 11i v3
• The latest versions of these products may be certified with B.06.00. For the latest information,
see the compatibility matrix available at http://www.hp.com/go/hpux-serviceguard-docs
—>HP Serviceguard
• This version of the toolkit supports both, legacy and modular style packages, but this version
of the toolkit is not supported with VxVM and CFS
This toolkit consists of a set of shell scripts used by a Package Control Script to start, stop, and
monitor the MySQL Database Server. The toolkit works with the Serviceguard package control
script, managed by Serviceguard for legacy packages and Serviceguard master control script in
case of modular packages. Each MySQL Database server instance is configured in its own
Serviceguard package.You must know the use of swinstall to properly install both Serviceguard
and the Enterprise Cluster Master Toolkit (ECMT), which includes the scripts for MySQL.
For legacy packages, there is one user configuration script (hamysql.conf) and three functional
scripts (toolkit.sh, hamysql.sh, hamysql.mon) which work with each other to integrate
MySQL with the Serviceguard package control scripts.
For modular packages, there is an Attribute Definition File (ADF), a Toolkit Module Script
(tkit_module.sh) and a Toolkit Configuration File Generator Script (tkit_gen.sh) which
work with the four scripts hamysql.conf, toolkit.sh, hamysql.sh and hamysql.mon for legacy packages
to integrate MySQL with the Serviceguard Master Control Script.
For ECMT installation, you must use the files listed in Table 12 (page 88). The following files are
located in: /opt/cmcluster/toolkit/mysql.
Table 12 Files in Legacy Packages in MySQL
DescriptionFile Name
The contents of the README file have been moved to this user guide.README
User defined variables for configuring MySQL in a specific environment.hamysql.conf
The main shell script.hamysql.sh
Script to monitor MySQL to ensure it is running.hamysql.mon
Interface between the Serviceguard package control script and hamysql.sh for legacy packages,
and interface between the Serviceguard master control script and hamysql.sh for modular packages.
toolkit.sh
The following three files mysql.1, tkit_module.sh, and tkit_gen.sh are also installed
and they are used only for the modular method of packaging.
88 Using MySQL Toolkit in a HP Serviceguard Cluster