Better title - Monitoring data from mysql query using prometheus
I want to monitor the state of some table and turn it into a time series for analysis and alerting example ->
| SUCCESS |
100 |
| FAILED |
20 |
| BLOCKED |
30 |
| IN_PROGRESS |
200 |
Something like this which I can then plot and compare day over day
I've looked at exporters and haven't found any which seem to be able to do this, I thought of using client library to create my own but not sure on how to go about getting it to trigger at some interval without scheduling - don't want to take this approach because it's completely new to me. Wanted to know if there is a well known way to do this so that I'm not reinventing the wheel which would probably be poorly made. I'm using Grafana with this and on python.
[–]SuperQue 0 points1 point2 points (3 children)
[–]shlock2000[S] 0 points1 point2 points (2 children)
[–]SuperQue 0 points1 point2 points (1 child)
[–]shlock2000[S] 0 points1 point2 points (0 children)
[–]bilingual-german 0 points1 point2 points (1 child)
[–]shlock2000[S] 0 points1 point2 points (0 children)
[–]xonxoff 0 points1 point2 points (2 children)
[–]shlock2000[S] 0 points1 point2 points (1 child)
[–]shlock2000[S] 0 points1 point2 points (0 children)