VDI Database Status Test

The Oracle VDI Core configuration data and runtime information is stored in a MySQL database, which may be shared across multiple Oracle VDI Core instances on the network. This database configuration ensures access to the Oracle VDI Core even in failover scenarios.

Since non-availability of the database can obstruct the normal functioning of the VDI core, it is imperative to periodically check the availability of the MySQL database. This test runs availability checks on the MySQL database at configured intervals, and promptly alerts administrators whether the database is available or not. In a high availability configuration of the VDI core, you can use this test to also determine whether the database is the master or slave of a MySQL cluster.

Target of the test : An Oracle VDI Broker

Agent deploying the test : An internal/remote agent

Outputs of the test : One set of results for the Oracle VDI broker being monitored.

Configurable parameters for the test

Parameter	Description
Test period	How often should the test be executed
Host	The host for which the test is to be configured.
Port	The port number at which the specified Host listens to.
SudoPath	This test executes certain privileged VDA (Virtual Desktop Access) commands to pull out the desired metrics from the broker. To enable the test to run these commands, you first need to install a sudo package on the broker host. The procedure for installing this package is detailed in Pre-requisites for Monitoring the Oracle VDI Broker in an Agent-based Manner. Once the package is installed, you need to specify the full path to the install directory of the sudo package in the SudoPath text box.

Measurements made by the test

Measurement	Description	Measurement Unit	Interpretation
Database status	Indicates whether the database is currently available or not.		If the database is available, then this measure will report the value Up. If the database is not available, then this measure will report the value Down. The table below lists the numeric values that correspond to each of the states mentioned above: State Numeric Value Up 1 Down 0 Note: Typically, this measure will report the States indicated in the table above as its values. However, in the graph of this measure, the status of the database will be represented using the numeric equivalents only - i.e., 0 and 1.
Database host	Indicates whether the database is the master or slave of a high availability cluster configuration.		The values that this measure reports and the numeric values that correspond to them are discussed in the table below: Measure Values Numeric Value Master 1 Slave 2 Note: Typically, this measure will report the Measure Values indicated in the table above. However, in the graph of this measure, the status of the database will be represented using the numeric equivalents only - i.e., 1 and 2. If the database is not part of a high availability cluster, then this measure will not be reported by the test.