Linux下安装grafana并且添加influxdb监控的方法

砸漏

发布于 2020-10-19 10:03:38

7860

发布于 2020-10-19 10:03:38

文章被收录于专栏：恩蓝脚本

安装grafana，官网提供了ubuntu的安装包，直接进行安装

wget https://dl.grafana.com/oss/release/grafana_6.5.1_amd64.deb 
dpkg -i grafana_6.5.1_amd64.deb 
update-rc.d grafana-server defaults 95 10
service grafana-server start

使用influxdb的http api添加数据和查询数据

添加数据

while true;do curl -i -XPOST 'http://127.0.0.1:8086/write?db=sinamail' --data-binary "webface,ip=10.2.2.1,httpstatus=404 prototype=\"GET /favicon.ico HTTP/1.1\" `date +%s`000000000";done

查询数据

curl -GET 'http://127.0.0.1:8086/query?pretty=true' --data-urlencode "db=sinamail" --data-urlencode "q=SELECT * FROM webface where httpstatus='404'"

添加grafana的influxdb数据源

查询表数据绘制出折线图

{
 "xhrStatus": "complete",
 "request": {
  "method": "GET",
  "url": "api/datasources/proxy/1/query",
  "params": {
   "db": "sinamail",
   "q": "SELECT count(\"prototype\") FROM \"webface\" WHERE (\"httpstatus\" = '404') AND time >= now() - 15m GROUP BY time(1m) fill(null)",
   "epoch": "ms"
  },
  "data": null,
  "precision": "ms"
 },
 "response": {
  "results": [
   {
    "statement_id": 0,
    "series": [
     {
      "name": "webface",
      "columns": [
       "time",
       "count"
      ],
      "values": [
       [
        1575211320000,
        0
       ],
       [
        1575211380000,
        0
       ],
       [
        1575211440000,
        0
       ],
       [
        1575211500000,
        0
       ],
       [
        1575211560000,
        1
       ],
       [
        1575211620000,
        0
       ],
       [
        1575211680000,
        4
       ],
       [
        1575211740000,
        8
       ],
       [
        1575211800000,
        0
       ],
       [
        1575211860000,
        0
       ],
       [
        1575211920000,
        41
       ],
       [
        1575211980000,
        8
       ],
       [
        1575212040000,
        0
       ],
       [
        1575212100000,
        0
       ],
       [
        1575212160000,
        0
       ],
       [
        1575212220000,
        0
       ]
      ]
     }
    ]
   }
  ]
 }
}

总结

以上所述是小编给大家介绍的Linux下安装grafana并且添加influxdb监控的方法，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对ZaLou.Cn网站的支持！如果你觉得本文对你有帮助，欢迎转载，烦请注明出处，谢谢！

本文参与腾讯云自媒体同步曝光计划，分享自作者个人站点/博客。

原始发表：2020-09-11 ，如有侵权请联系 cloudcommunity@tencent.com 删除

linux