Unified Assurance Database Watchdog Utility

Overview

The Unified Assurance Database Watchdog Utility is used to verify availability of configured databases and maintains states. The state of the databases can then be viewed on the Databases UI.

Configuration -> Databases -> Databases

The service will automatically be enabled on all servers in a redundant environment to support quicker fail over if a primary database is down, and fail-back when the primary database recovers.

Database Watchdog Utility Setup

In a redundant environment, the watchdog will be enabled by default.

In non-redundant environments, the watchdog can be manually enabled.

  1. Enable the default Service, unless a specific configuration option is needed.

    Configuration -> Broker Control -> Services

Default Service

Field Value
Package Name assure1-app
Service Name Database Watchdog
Service Program bin/DatabaseWatchdog
Service Arguments
Service Description Database state watcher
Failover Type Standalone (Supported: Standalone)
Status Disabled
Privileged (Checked)

Default Configuration

Name Value Possible Values Notes
CheckTime 60 Integer How often (in seconds) where the application checks to see if there are any relevant changes.
Interval Integer How often (in seconds) where the application checks the state of the databases (defaults to 30).
LogFile logs/DatabaseWatchdog.log Text, 255 characters Relative path to Log File.
LogLevel ERROR OFF, FATAL, ERROR, WARN, INFO, DEBUG Logging level used by application.
Threads 3 Integer Number of process threads created.
TimeOut Integer The time out for the database connection (defaults to 10).
SBMLimit 10 Integer Optional - For mysql databases in redundant environment. Limit for Seconds_Behind_Master to be considered up-to-date. Defaults to 10 seconds.

Administration Details

The following list shows the technical details needed for advanced administration of the application: