How to install grafana and add influxdb monitoring under Linux

How to install grafana and add influxdb monitoring under Linux

Install grafana. The official website provides an Ubuntu installation package, which can be installed directly.

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

Use InfluxDB's HTTP API to add and query data

Add data

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

Query data

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

Add influxdb data source for grafana

Draw a line chart using query table data

{
 "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
       ]
      ]
     }
    ]
   }
  ]
 }
}

Summarize

The above is the method that I introduced to you to install grafana under Linux and add influxdb monitoring. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!

You may also be interested in:
  • Detailed explanation of performance monitoring of MySQL server using Prometheus and Grafana
  • Detailed tutorial on grafana installation and usage
  • Use Grafana to display monitoring charts of Docker containers and set email alert rules (illustration)
  • Detailed explanation of the tutorial on monitoring Springboot applications using Prometheus+Grafana
  • Use Grafana+Prometheus to monitor MySQL service performance
  • Detailed explanation of the process of building Prometheus+Grafana based on docker
  • Summary of influx+grafana custom python data collection and some pitfalls
  • Detailed steps for SpringBoot+Prometheus+Grafana to implement application monitoring and alarm
  • Analyze the method of prometheus+grafana monitoring nginx
  • Prometheus monitors MySQL using grafana display
  • How to monitor Docker using Grafana on Ubuntu
  • Detailed tutorial on building a JMeter+Grafana+Influxdb monitoring platform with Docker
  • Tutorial on building a JMeter+Grafana+influxdb visual performance monitoring platform in docker environment
  • Deploy grafana+prometheus configuration using docker
  • ELK and Grafana jointly create visual monitoring to analyze nginx logs
  • It doesn’t matter if you forget your Grafana password. 2 ways to reset your Grafana admin password

<<:  What is the file mysql-bin.000001 in mysql? Can it be deleted?

>>:  In-depth explanation of Set and WeakSet collections in ES6

Recommend

Key knowledge summary of Vue development guide

Table of contents Overview 0. JavaScript and Web ...

Solve the problem of resetting the Mysql root user account password

Problem description: The following error message ...

CentOS installation mysql5.7 detailed tutorial

This article shares the detailed steps of install...

In-depth understanding of the use of CSS clear:both

clear:both is used to清除浮動This is the impression I...

jQuery canvas generates a poster with a QR code

This article shares the specific code for using j...

Understanding and using callback functions in JavaScript

Table of contents Overview What are callbacks or ...

Detailed explanation of some settings for Table adaptation and overflow

1. Two properties of table reset: ①border-collaps...

How to install jupyter in docker on centos and open ports

Table of contents Install jupyter Docker port map...

Detailed explanation of HTML document types

Mine is: <!DOCTYPE html> Blog Garden: <!...

Example code for implementing auto-increment sequence in mysql

1. Create a sequence table CREATE TABLE `sequence...