HP OSMS Blueprint: Database Server on HP Server Platforms with MySQL and RHEL5
Table 6 MySQL Policies in the DBSPI MySQL Policy Group (continued)
Default
Threshold
Default
Polling
Interval
DescriptionPolicy TypePolicy Name
N/AN/A
Discovers the MySQL server. The
MySQL server is registered as an
OVOW service and this policy is
used to “discover” MySQL
availability once an hour, by
default.
Service Auto DiscoveryMySQL Service
Discovery - MySQL SPI
N/AN/A
Provides an interface for displaying
MySQL server log messages. The
Open Message Interface policies
are used by other policies and are
not used directly for monitoring.
Open Message InterfaceLog Message – MySQL
SPI
Backing Up Your Database
A database backup strategy is a critical part of any database installation. The MySQL database
backup strategy is a two-part process of first extracting data from the database and then using
a backup tool to store the data to backup media, such as tape media or network storage.
MySQL and other vendors provide data extraction tools, which capture and store the data from
the database. Each storage engine in MySQL has unique characteristics that impact backup, so
backup solutions tend to be as custom as a database configuration.
This section provides an example of implementing a backup strategy for a MySQL database
installation using HP OpenView Storage Data Protector (Data Protector). If you are currently
using a different backup tool, you can proceed with the general steps that are outlined in the
backup strategy that follows.
Installing and Configuring a Database Backup Tool
The following section shows you how to use the HP Data Protector for testing purposes. You
must install both the HP Data Protector Cell Manager and the Data Protector agent, both of which
can run on Windows, HP-UX, and the Linux OS. In this example, the Data Protector Cell Manager
and Data Protector agent are installed separately on one machine running Windows and on the
Linux-based MySQL slave server. HP Data Protector on Windows provides a GUI to manage
resources and perform backup or restore actions.
Before performing the following test, install the Data Protector 6.0 server on a Windows system.
Use the following steps to install and configure the Data Protector 6.0 Agent.
1. To install HP Data Protector for Linux Agent on the Linux-based MySQL slave server,
download the HP Data Protector for HP-UX PA-RISC - Installation Server 1 of 2 (CD ISO
image) from the following website:
http://h18006.www1.hp.com/products/storage/software/dataprotector/index.html
2. Open the image and enter the following command:
# ./omnisetup.sh -install da
3. Edit the /etc/services file and comment out all the lines containing port 5555 by
making the following changes:
# personal-agent 5555/tcp # personal Agent
# personal-agent 5555/udp # personal Agent
4. To start the Data Protector agent, enter the following commands:
# chkconfig xinetd on
# /etc/init.d/xinetd restart
Backing Up Your Database 29