Metrics Server - Influx DB¶

This is puppet managed: https://gitea.psi.ch/puppet/data-lx/src/branch/master/default/lx-influx-01.psi.ch.yaml

Runs the influxdb backend for the metrics.psi.ch service, as part of the telegraph, influxdb and grafana stack.

Data is stored at /var/lib/influxdb "locally" on the virtual machine. The influx configuration can be found /etc/influxdb/influxdb.conf

Administration Influx Database¶

Connect to the influx server

ssh influx.psi.ch

Connect to the influx database:

influx

Now you should have the prompt of the influx cli client

Show all databases

show databases

Switch to a database:

use "database_name"

Show all measurements

show measurements

Show all series (of all measurements)

show series

Show all series for a particular host:

show series where "host" = 'lx-puppet-01.psi.ch'

Delete all series for a particular host:

DROP SERIES FROM /.*/ WHERE "host" = 'lx-puppet-01.psi.ch'