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

Table 5 Application Labels and Descriptions
DescriptionApplication Label
Extracts and deploys MySQL Instrumentation.Configure MySQL
Instrumentation
Restarts the MySQL server.Restart MySQL Server
Starts the MySQL server on the managed node.Start MySQL Server
Stops the MySQL server on the managed node.Stop MySQL Server
Starts the log file monitoring of the MySQL server. The tool monitors errors,
deployment exceptions and MySQL resource exceptions from the default MySQL
log file (located in /var/lib/mysql/hostname.err). The OVOW management
console shows all the logs in the active message window.
Start MySQL Log File Monitoring
Stops the log file monitoring of the MySQL server.Stop MySQL Log File Monitoring
Event-Driven Methods
The event-driven methods are used to manage events that are triggered when certain conditions
are met, for example, if the MySQL server process utilizes a greater percentage of CPU than the
threshold defined in the policy. When a threshold is exceeded, certain warning messages appear
in the management console. Table 6 lists the MySQL SPI policy details:
Table 6 MySQL Policies in the DBSPI MySQL Policy Group
Default
Threshold
Default
Polling
Interval
DescriptionPolicy TypePolicy Name
90%30 seconds
Monitors the CPU usage of the
MySQL server. By default, if the
CPU utilization percentage of any
MySQL process exceeds 90%, a
critical message is displayed in an
active message browser of the
OVOW console.
Measurement ThresholdMySQL CPU-Usage
Monitor
90%30 seconds
Monitors the operating system's
memory usage of the MySQL
server. By default, if the memory
utilization percentage of any
MySQL process exceeds 90%, a
critical message is displayed in
active message browser of the
OVOW console.
Measurement ThresholdMySQL Memory
Usage Monitor
N/A1 minute
Monitors a MySQL process. If a
MySQL process is killed, then a
message is displayed in an active
message browser of the OVOW
console.
Scheduled TaskProcess Monitor –
MySQL SPI
N/A5 minutes
Provides an interface for displaying
MySQL server error messages. The
Open Message Interface policies
are used by other policies and are
not used directly for monitoring.
Open Message InterfaceStatus Message -
MySQL SPI
N/AN/A
Provides an interface for displaying
internal error messages from the
SPI. The Open Message Interface
policies are used by other policies
and are not used directly for
monitoring.
Open Message InterfaceInternal Message -
MySQL SPI
28