is there anyone using Telegraf / InfluxDB metrics exporter with Grafana dashboards? I am asking like that because I was unable to find any existing Grafana dashboards based on InfluxDB.
I am having hard times with creating graphs I want to see. Metrics are exported in way that every single one is stored in separated series in Influx like:
> ceph_pool_stats,cluster=ceph1,metric=read value=1234 1550658911000000000
> ceph_pool_stats,cluster=ceph1,metric=write value=1234 1550658911000000000
> ceph_pool_stats,cluster=ceph1,metric=total value=1234 1550658911000000000
instead of single series like:
> ceph_pool_stats,cluster=ceph1 read=1234,write=1234,total=1234 1550658911000000000
This means when I want to create graph of something like % usage ratio (= bytes_used / bytes_total) or number of faulty OSDs (= num_osd_up - num_osd_in) I am unable to do it with single query like
> SELECT mean("num_osd_up") - mean("num_osd_in") FROM "ceph_cluster_stats" WHERE "cluster" =~ /^ceph1$/ AND time >= now() - 6h GROUP BY time(5m) fill(null)
but instead it requires two queries followed by math operation, which I was unable to get it working in my Grafana nor InfluxDB (I believe it's not supported, Influx removed JOIN queries some time ago).
I didn't see any possibility how to modify metrics format exported to Telegraf. I feel like I am missing something pretty obvious here.
I am currently unable to switch to prometheus exporter (which don't have this kind of issue) because of my current infrastructure setup.
Currently I am using following versions:
* Ceph 14.2.4
* InfluxDB 1.6.4
* Grafana 6.4.2
So ... do you have it working anyone? Please could you share your dashboards?
Best regards
-- Miroslav Kalina Systems developement specialist Livesport s.r.o. Aspira Business Centre Bucharova 2928/14a, 158 00 Praha 5 www.livesport.eu
_______________________________________________ ceph-users mailing list ceph-users@xxxxxxxxxxxxxx http://lists.ceph.com/listinfo.cgi/ceph-users-ceph.com
