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

"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

Testing Cluster Failover

You can simulate some of the following cases, which cause primary-node failure, to verify the

MySQL Serviceguard cluster failover function.

CAUTION: You should perform the following tests with sample data before trying the tests

with critical production data. In the event of a serious failure or the wrong configuration, data

corruption can result.

• End the primary node's MySQL processes.

• Pull the power cable out on the primary node to cause a power failure.

• Pull the network cable out on the primary node to cause the loss of a network.

• Issue the power off and reboot commands on the primary node.

• End all SG/LX processes on the primary node.

In the event of a failure on the primary node, the package automatically fails over to the standby

node and the database continues to function. Thus, the database fails over successfully.

You can verify that the database continues to function by accessing the MySQL database service

when the primary node fails. For more information on how to test the MySQL Serviceguard

cluster connection, see “Testing the Cluster Connection ” (page 24).

Monitoring the Database with the HP OpenView MySQL Gallery SPI

HP OpenView Operations Architecture

HP enhances the Open Source Middleware Stacks (OSMS) using HP OpenView Operations

Smart Plug-Ins (OVO SPIs).

HP OpenView Operations (OVO) is a distributed, client/server software solution designed to

provide service-driven event and performance management of business-critical enterprise

systems, applications, and services.

The SPI for MySQL is a value-add software component for HP OVO. This software is provided

free to all customers of HP OVO for use under the terms and conditions documented on the

download web page. This SPI provides powerful, centralized tools to monitor and manage the

operation of multiple installations of MySQL servers on RHEL.

SPI components include:

• Policies that are designed to monitor log files and key health parameters of the MySQL

server

• Policies that allow you to monitor the overall availability of the MySQL server

• Tools that allow you to run commands on the managed MySQL installation

NOTE: The HP OVO Management Server runs on either HP-UX or Windows. The examples

in this blueprint use HP OpenView Operations for Windows (OVOW).

Figure 7 illustrates the SPI architecture and OVOW components.