HP OSMS Blueprint: Database Server on HP Server Platforms with MySQL and RHEL5

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
The following test uses an x86_64 system running a fully installed version of the RHEL5
distribution. The RHEL5 distribution contains embedded mysql-bench test suite.
To enable and use the mysql-bench test suite to verify the stability of the MySQL Serviceguard
cluster, use the following steps:
1. Verify that the mysql-bench test suite is installed, by entering the following command:
# rpm -qa | grep mysql-bench
If the test suite is installed, the following message is shown:
mysql-bench-5.0.22-2.1
If the test suite is not installed, you can retrieve the package
(mysql-bench-5.0.22-2.1.x86_64.rpm) from the RHEL5 distribution. Once you have
the file, install it by entering the following command:
# rpm -ivh mysql-bench-5.0.22-2.1.x86_64.rpm
2. Next, verify that mysql client, mysql server, the Perl DBI module and MySQL DBD drivers
are installed by entering the following commands. :
# rpm -qa | grep perl-DBD-MySQL
# rpm -qa | grep perl-DBI
# rpm -qa | grep mysql-5.0.22-2.1
# rpm -qa | grep mysql-server-5.0.22-2.1
3. Run the test suite by entering the following commands.
# cd $SQL_BENCH_DIR
# ./run-all-tests --host= relocatable_ip_address
where:
SQL_BENCH_DIR is the MySQL-bench installation directory.
For example, enter the following commands:
# cd /usr/share/sql-bench
# ./run-all-tests --host= 10.101.0.251
NOTE: These tests can take a long time to complete.
4. To make the results easier to read, repeat the commands with the options --log
--use-old-result.
5. To create a file based on the results you obtained from the $SQL_BENCH_DIR output
directory, enter the following command:
# ./run-all-tests --host= 10.101.0.251 --comment= \
MySQL High Availability Using HP Serviceguard 25