HP OSMS Blueprint: HP Manageability Value-Add Software for Open Source Middleware Stacks

MySQL Configuration

You have installed the MySQL database and configured it on the shared storage. For more

information, see the file /usr/local/cmcluster/mysqltoolkit/README.

Installing and Configuring the MySQL Toolkit

On all target nodes you have installed the Serviceguard MySQL toolkit and configured the

MySQL Serviceguard Cluster package with the following values:

MySQL Cluster:

PACKAGE Name MySQL_PKG

Relocatable IP address 10.101.0.251

For more information about configuration, see the document Using MySQL Toolkit in a ServiceGuard

for Linux Cluster located at:

http://docs.hp.com/en/T2377-90001/index.html

Testing the MySQL Serviceguard Cluster

The MySQL toolkit README file describes how to test the High Availability with the MySQL

Toolkit in an SG/LX environment. The file is located in the

/usr/local/cmcluster/mysqltoolkit/ directory.

Testing the Cluster Connection

Perform the following steps from the external test system:

1. Grant the required privileges to the sample database user to allow access to the MySQL

database service from the third machine. For example, enter the grant command as follows:

grant all on osmsdb.* to 'osmsusr'@'%' identified by 'osmspass';

2. On the test machine, verify the MySQL connection by entering the following command:

# mysqladmin -h relocatable_ip_address version

For example:

# mysqladmin -h 10.101.0.251 version

The output looks similar to the following:

Server version 5.0.40-enterprise-gpl-log

Protocol version 10

Connection 10.101.0.251 via TCP/IP

TCP port 3306

Uptime: 57 sec

Threads: 1 Questions: 14 Slow queries: 0 Opens: 0 Flush tables: 1

Open tables: 6 Queries per second avg: 0.246

This output demonstrates that the MySQL client running on the test machine is able to

connect to the primary node of the MySQL Serviceguard cluster using the relocatable IP

address.

Testing the Cluster Stability

The MySQL-bench tool is useful for performing general comparisons of servers and configurations.

Use this tool to perform the stress tests described in this blueprint. In the following test, a sample

database is created and populated with benchmark data. The tests in the suite can be run

separately or together.

For more information about using the MySQL-bench tool, see the web page for the MySQL

benchmark suite at:

http://dev.mysql.com/doc/refman/5.0/en/mysql-benchmarks.html