Hello guys,
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@lists.ceph.com
http://lists.ceph.com/listinfo.cgi/ceph-users-ceph.com
