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
Table 17 Parameters in MySQL Configuration File (my.cnf)
DescriptionFile/Directory name
[mysqld]
# Data Directory for MySQL DBdatadir=/MySQL_1/
mysql
# Socket file for Clientsocket=/MySQL_1/
mysql/mysql.sock
# Communication
# Port Number for Clientport=3310
# Communication
[mysqld_safe]
# Safe-mysqld'serr-log=/MySQL_1/
mysql/mysqld.
# Error Log file
# pid file Pathpid-file=/etc/
cmcluster/pkg/
MySQL1/mysqld.pid
NOTE: mysqld_safe was previously called safe_mysqld. For an older version of MySQL,
the user must modify suitable sections in the my.cnf file.
To run MySQL toolkit with the older versions of the MySQL follow these steps:
1. Create a soft link named “mysqld_safe" in the MySQL installation directory/usr/bin for RH
to point to "safe_mysqld".
CMD> ln -s /usr/bin/mysqld_safe /usr/bin/safe_mysqld
2. Grant permission to run the newly created link:
CMD> chmod 755 mysqld_safe
The following sections in this chapter describe the legacy mode of Serviceguard packages. For
information on creating the Serviceguard package using the modular method, see the whitepaper
Modular package support in Serviceguard for Linux and ECM Toolkits available at http://
www.hp.com/go/hpux-serviceguard-docs —>HP Serviceguard Enterprise Cluster Master Toolkit.
Toolkit configuration file(hamysql.conf)
All configuration variables for the toolkit user are stored in the file - hamysql.conf, in Shell script
format. Table 18 (page 92) lists the user variables and sample values in the file.
Table 18 User Variables in hamysql.conf file
DescriptionFile name
Only one of the two variables (either CONFIGURATION_FILE_PATH
or DATA_DIRECTORY) must be defined. If both are defined,
CONFIGURATION_FILE_PATH="/MySQL_1/mysql/my.cnf"
or DATA_DIRECTORY="/MySQL_1/mysql"
CONFIGURATION_FILE_PATH is used and DATA_DIRECTORY is
ignored.
NOTE: If DATA_DIRECTORY is used, my.cnf must reside in the
DATA_DIRECTORY location. This directory is also used as the data
directory for this instance of the database server.
This is the path where PID file for the MySQL daemon is created for
the parent PID. If this variable is defined, it overrides the "pid-file"
PID_FILE="/var/run/mysql/mysqld.pid"
defined in the MySQL configuration file my.cnf. The PID identified
in this file is monitored by the toolkit monitor, "hamysql.mon".
92 Using MySQL Toolkit in a HP Serviceguard Cluster