HP OSMS Blueprint: Database Server on HP ProLiant Servers with MySQL and SLES10

Logical Volumes:

PV Name /dev/sdx2

LV Name /dev/vg/lv

VG Name /dev/vg

LV Size 50.00 GB

Mount Point /mysql

Filesystem Type ext3

For more information about Lock LUN, see Managing HP Serviceguard for Linux located at:

http://docs.hp.com/en/B9903-90046/index.html

• You have installed SG/LX on all the nodes that are included in the cluster. For more

information on this installation, see Managing HP Serviceguard for Linux at:

http://docs.hp.com/en/B9903-90046/index.html

• You have installed the Serviceguard MySQL toolkit on all target nodes.

The Serviceguard MySQL toolkit is installed in the

/usr/local/cmcluster/mysqltoolkit directory. For more information about this

installation, see the MySQL toolkit documentation at:

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

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

For more information, see the file /opt/cmcluster/mysqltoolkit/README.

• You have configured the MySQL Serviceguard Cluster package with the following values:

MySQL Cluster:

PACKAGE Name MySQL_PKG

Relocatable IP address 10.101.0.251

Testing the MySQL Serviceguard Cluster

Testing the Cluster Connection

Perform the following steps from the external test system as described in the testing assumptions

in “Testing Assumptions” (page 22):

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

database service from the third machine. This procedure is described in “Configuring MySQL

Server Replication” (page 15). 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:

Open tables: 6 Queries per second avg: 0.246

MySQL High Availability Using HP Serviceguard 23