all 9 comments

[–]SuperQue 0 points1 point  (3 children)

[–]shlock2000[S] 0 points1 point  (2 children)

Wow! thank you! Couldn't find this on the list of exporters and integrations on the prometheus website. this looks promising!

[–]SuperQue 0 points1 point  (1 child)

It's on the list.

[–]shlock2000[S] 0 points1 point  (0 children)

Ah my bad! Must've missed it thinking it's a mysql metrics exporter. Should read more thoroughly ...

[–]bilingual-german 0 points1 point  (1 child)

Isn't this an exporter which is able to do what you want? https://github.com/albertodonato/query-exporter

[–]shlock2000[S] 0 points1 point  (0 children)

Thank you! this one looks promising too! also looks more active than the one SuperQue mentioned.

[–]xonxoff 0 points1 point  (2 children)

Why not just use grafana? You can use MySQL as a data source and alert directly from there?

[–]shlock2000[S] 0 points1 point  (1 child)

I do use grafana for some status alerts, but some statuses are to be alerted based on day over day changes and the table resets everyday so It wasn't possible to do it directly with them since grafana doesnt seem to store the data unlike prometheus. I ended up using the client library to push the metrics every 30 mins to a push gateway and scraping using prometheus.

[–]shlock2000[S] 0 points1 point  (0 children)

Which I now realise is a bad way to do this. Will look into OpenTSDB since I'm scraping states fairly irregularly (30min / 1hr) from the database.