Assure1 Database Watchdog Utility¶
Overview¶
The Assure1 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.
-
Enable the default Service, unless a specific configuration option is needed.
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:
-
Package - assure1-app
-
Synopsis -
./DatabaseWatchdog [OPTIONS] -
Options:
-c, --AppConfigID N Application Config ID (Service, Job, or Request ID) -?, -h, --Help Print usage and exit -
Threaded - Multi-Threaded