We're implementing the MySQL v2 sensor for a MariaDB RDS instance. And most of the configuration has gone as expected. There is one part of the alerting that we've not been able to get to present as desired.
STEPS TAKEN Added MySQL v2 sensor Configured Database Added .sql file to appropriate path on Core Probe Selected SQL Query File that was uploaded Data (options set) ... Data Processing: Process data table ... Handle DBNull in Channel Values as: Number 0 ... Select Channel Value by: Column number ... Sensor Channel #1 Column Number: 0 ... Sensor Channel #1 Unit: Count ....... note: it's a select statement that returns a count
Edited Channel ... Enable alerting based on limits ... Upper Error Limit (#): 0 ....... note: we want the sensor to alert if this value is greater than 0
Notification Triggers ... When sensor state is Down perform > Slack notification ... When sensor state is Up perform > Slack notification ... note: we've run planned tests and the Sensor along with Slack notify as expected
Unexpected Presentation ... When the channel resets to an up status, the sensor returns to an Up status, but, the visual graph for the channel still presents as Red instead of Green. This leads to a confusing visual, any ideas on what we might be missing?
Resources Referenced: https://www.paessler.com/manuals/prtg/mysql_v2_sensor https://kb.paessler.com/en/topic/71779-how-can-i-monitor-mysql-performance-via-mysqlv2-sensor https://kb.paessler.com/en/topic/70618-how-to-setup-the-sql-v2-sensors-in-prtg-is-there-a-guide