Using MySQL Toolkit in a HP Serviceguard Cluster Revision README: B.06.00
2. Following the instructions in the documentation for MySQL, create
the database on the lvol in /MySQL_1. This information may be
viewed online at the following link:
http://www.mysql.com/documentation/mysql/bychapter/
manual_Tutorial.html#Creating_database
3. Copy the configuration file "/etc/my.cnf" to "/MySQL_1/my.cnf".
4. Modify "/MySQL_1/my.cnf" to configure the DB for your unique
environment. Changes may include specific assignments to the
following parameters:
[mysqld]
* datadir=/MySQL_1/mysql
* socket=/MySQL_1/mysql/mysql.sock
* port= <UNIQUE PORT NUMBER>
[mysqld_safe]
* err-log=/MySQL_1/mysql/mysqld.err
* pid-file=/etc/cmcluster/pkg/mysql1/mysqld.pid
Since each database instance resides in its own filesystem, multiple
database instances can be configured in the environment using this
method.
C. Setting Up MySQL with the Toolkit
C.1 Toolkit Overview
The following files are included in the toolkit for MySQL:
---------------------------------------------------------------------
File Name : Description
---------------------------------------------------------------------
README : Readme file for the MySQL toolkit (this file)
toolkit.sh : Toolkit Interface Script. Interface between the
Package Control Script and the toolkit main script
(hamysql.sh).
hamysql.conf : Toolkit Configuration File. Contains a list of
pre-defined variables that may be changed for your
unique environment
hamysql.sh : Toolkit Main Script. Contains the internal functions
that support start/stop of a MySQL instance.
hamysql.mon : Toolkit Monitor Script. Contains the internal
functions for monitoring a DB server instance.
NOTE: The following three scripts are used only during the modular
method of packaging.