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

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= \
"HP SG/LX with MySQL 5.0.40 enterprise gpl log" --log
--use-old-results
Check the results located in output/RUN-mysql-Linux_2.6.18_8.el5_x86_64. If the
test passed, the following message is shown:
All 9 test executed successfully
MySQL High Availability Using HP Serviceguard 19