Home
  •  

MySQL Server Server Status Monitor

Microsoft.MySQLServer.ManagedServer.Unix.ServerStatus.Monitor (UnitMonitor)

MySQL Server Status Monitor

Knowledge Base article:

Summary

The MySQL Server is not running or the monitoring module is unreachable.

Causes

The MySQL Server may have been stopped, crashed, or the provider may have been unloaded.

Resolutions

If the MySQL Server is not running, restart the MySQL Server. If the server is running ensure that the operating status does not show a degraded or unreachable state. Additionally, ensure that the MySQL credentials have been set through the Management Pack task or through the included MySQL authentication command line program.

Element properties:

TargetMicrosoft.MySQLServer.ManagedServer.Unix
Parent MonitorSystem.Health.AvailabilityState
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.Oss.WSMan.Status.Filtered.MonitorType
RemotableTrue
AccessibilityPublic
Alert Message
MySQL Server Status
The MySQL Server {0} is offline, not monitored, or configured correctly
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.MySQLServer.ManagedServer.Unix.ServerStatus.Monitor" Accessibility="Public" Target="Microsoft.MySQLServer.ManagedServer.Unix" TypeID="Oss!Microsoft.Oss.WSMan.Status.Filtered.MonitorType" Enabled="onStandardMonitoring" ParentMonitorID="Health!System.Health.AvailabilityState">

  <Category>AvailabilityHealth</Category>

  <AlertSettings AlertMessage="Microsoft.MySQLServer.ManagedServer.Unix.ServerStatus.AlertMessage">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Data/Context/WsManData/*[local-name(.)='MySQL_Server']/*[local-name(.)='InstanceID']$</AlertParameter1>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState HealthState="Success" MonitorTypeStateID="StatusOK" ID="StatusOK"/>

    <OperationalState HealthState="Error" MonitorTypeStateID="StatusFailed" ID="StatusFailed"/>

  </OperationalStates>

  <Configuration>

    <TargetSystem>$Target/Host/Property[Type="Unix!Microsoft.Unix.Computer"]/NetworkName$</TargetSystem>

    <Uri>http://schemas.microsoft.com/wbem/wscim/1/cim-schema/2/MySQL_Server?__cimnamespace=root/mysql</Uri>

    <Filter/>

    <SplitItems>true</SplitItems>

    <Interval>300</Interval>

    <InstanceName>$Target/Property[Type="Microsoft.MySQLServer.Installation"]/InstanceID$</InstanceName>

    <InstanceProperty>/DataItem/WsManData/*[local-name(.)='MySQL_Server']/*[local-name(.)='ProductIdentifyingNumber']</InstanceProperty>

    <Status>/DataItem/WsManData/*[local-name(.)='MySQL_Server']/*[local-name(.)='OperatingStatus']</Status>

    <ExpectedStatus>OK</ExpectedStatus>

  </Configuration>

</UnitMonitor>