=====Grafana=====

https://www.claudiokuenzler.com/blog/749/icinga2-graphing-influxdb-grafana#.W19_ddJKg2x

Install:

   apt-get install grafana grafana-data
   netstat -lntup | grep grafana

Configuration:

/etc/grafana/grafana.ini

  protocol = https
  domain = mydnsname.local
  cert_file = /etc/grafana/mydnsname.local.crt
  cert_key = /etc/grafana/mydnsname.local.key



====Influx DB =====

Install:

  apt-get install influxdb influxdb-client 
  netstat -lntup | grep influx

Configuration:

  /etc/influxdb/influxdb.conf
  /var/lib/influxdb/

Configuration to work with Icinga2:

  /etc/icinga2/features-enabled/influxdb.conf
  
Example:

<code>
object InfluxdbWriter "influxdb" {
  host = "127.0.0.1"
  port = 8086
  database = "icinga2"
  username = "icinga2"
  password = "icinga2"
  host_template = {
    measurement = "$host.check_command$"
    tags = {
      hostname = "$host.name$"
    }
  }
  service_template = {
    measurement = "$service.check_command$"
    tags = {
      hostname = "$host.name$"
      service = "$service.name$"
    }
  }
}
</code>

Check also

https://grafana.com/grafana/dashboards/381

====RETENTION POLICY====
  CREATE RETENTION POLICY "8weeks" ON "icinga2" DURATION 8w REPLICATION 1 default
  SHOW RETENTION POLICIES ON "icinga2"
  DROP RETENTION POLICY "default" ON "icinga2"

====commands====
  create database icinga2;
  CREATE USER icinga2 WITH PASSWORD 'secret'
  GRANT ALL ON icinga2 TO icinga2
  SHOW GRANTS FOR icinga2
  use icinga2
  select * from "P3/SENSOR"
  select * from "P3/SENSOR" where time > '2021-02-23'
  DROP MEASUREMENT "P3/SENSOR"
  DROP MEASUREMENT "ping4"
  show MEASUREMENTS
  show series
  show SERVERS
  show tag keys from ping4
  influxd version
  exit

====shell commands====

  influx -database nodered -execute 'show MEASUREMENTS'
  influx -database nodered -execute 'DROP MEASUREMENT "sensorname/topic"'  
  influx -precision rfc3339 -database nodered -execute 'select * from "P3/SENSOR"'                   #show entries with readable timestamp format
  
====Backup & Recovery====

  influxd backup -portable -database mydatabase -host <remote-node-IP>:8088 /tmp/backup_mydatabase    #          
  influxd backup -portable /tmp/backup_ex                                                             #To backup all databases
  influxd restore -portable /tmp/backup_ex                                                            #To restore the backup