HP Serviceguard Contributed Toolkit Suite Version A.04.02.02 on Linux User Guide (December, 2012)

Table 8 Files for creating modular packages
Available in directoryDescriptionFile name
$SGCONF/modules/tkit/mysqlThis is an attribute definition file used
to generate a package ASCII template
in modular style of packaging.
mysql.1
$SGCONF/scripts/tkit/mysqlThis is the module script. This script is
called by the master control script and
tkit_module.sh
acts as an interface between the
tkit_module.sh master control
script and the toolkit interface script
(toolkit.sh). It is also responsible
for calling the toolkit configuration file
generator script.
NOTE: This file is used only for
creating modular packages.
$SGCONF/scripts/tkit/mysqlThis is the toolkit configuration file
generator script. This script is called
tkit_gen.sh
by the module script when the
package configuration is applied
using cmapplyconf to generate the
user configuration file in the package
directory, TKIT_DIR.
NOTE: This file is used only for
creating modular packages.
Setting up the MySQL server in SG/LX environment
Before creating the packages, you must configure the shared storage and create the database.
1. Create a unique volume group and filesystem on shared storage for each instance of the
database to be included in the configuration.
2. On each node, create a mount point for each filesystem. The mount point for a specified
instance/package must be the same for all the nodes.
The following example shows a configuration of MySQL for a filesystem, /MySQL_1 on /dev/
vg01.
1. Assuming that LVM is 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.
2. Create the database on the lvol in /MySQL_1.
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=$SGCONF/pkg/mysql1/mysqld.pid
Setting up the MySQL server in SG/LX environment 21