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

NOTE:
• Since each database instance resides in its own filesystem, multiple database instances can
be configured in the environment using this method.
• In the case of MySQL version for SLES, mysqld_safe is known as safe_mysqld. Hence,
you have to modify the suitable sections in the my.cnf file.
• The mysqld_multi feature of MySQL is not supported with MySQL toolkit on SLES system.
Use separate MySQL toolkit packages for each instance of MySQL.
Supported Configuration
This section explains the following supported configurations for MySQL toolkit packages:
• Local configuration
• Shared configuration
• Multiple instance configuration
NOTE:
• Each node must have the same version of the MySQL application.
• Each node must have the same configuration directory where identical copies of the
configuration files for each instance are placed in the local or shared hard disk.
• Each node must have the same file system directories to access the same shared storage.
Local configuration
In a typical local configuration, files are not shared among the nodes. If you opt to store the
configuration files on a local disk, you must replicate the configuration to local disks on all the
nodes configured to run the package. Identical copies of the MySQL server configuration file must
reside in exactly the same locations on each node. If you update the information in a file on a
single node, you must update the files on all the other nodes with the same changes. Ensure that
all the files on all the nodes are identical and always up-to-date.
Shared configuration
The configuration and database files are placed on shared disks, accessible to all the nodes. Since
the storage is shared, you need not ensure that all the nodes have the same configuration.
Multiple instance configuration
MySQL database server supports multiple DB instances running on the same node. Using this
toolkit, you can configure multiple MySQL toolkit packages to run on the same node. One copy
of the toolkit can serve one package. So, to configure multiple packages, you must create separate
directories, one per package, and configure each package to run a unique database instance.
Using MySQL toolkit
After installing the MySQL toolkit, you can use this toolkit to:
• Configure packages in an SG/LX environment
• Manage packages
Configuring MySQL toolkit packages
You can configure MySQL toolkit packages using either legacy or modular style of packaging.
22 MySQL Toolkit