Support influxdb v1.8.10

[no-brand]

influxdb

1. environment variables

   • influxdb:1.8 : https://github.com/influxdata/influxdata-docker/blob/master/influxdb/1.8/init-influxdb.sh
   • influxdb:2.7 : https://github.com/influxdata/influxdata-docker/blob/master/influxdb/2.7/entrypoint.sh

2. connect to influxdb:1.8

   $ wget https://dl.influxdata.com/influxdb/releases/influxdb-1.8.10_darwin_amd64.tar.gz
   $ tar zxvf influxdb-1.8.10_darwin_amd64.tar.gz
   $ influx -host localhost -port 18086
   >

[no-brand]

telegraf

1. output plugins
   • influxdb v1 : https://github.com/influxdata/telegraf/blob/release-1.29/plugins/outputs/influxdb/README.md
   • influxdb v2 : https://github.com/influxdata/telegraf/blob/release-1.29/plugins/outputs/influxdb_v2/README.md
   • telegraf configuration

     [[outputs.influxdb]]
     urls = ["http://influxdb:8086"]
     database = "telegraf"
     skip_database_creation = false
     ...

   • logs

     telegraf  | 2024-01-05T14:45:06Z D! [agent] Initializing plugins
     telegraf  | 2024-01-05T14:45:06Z D! [agent] Connecting outputs
     telegraf  | 2024-01-05T14:45:06Z D! [agent] Attempting connection to [outputs.influxdb]
     influxdb  | ts=2024-01-05T14:45:06.729399Z lvl=info msg="Executing query" log_id=0mYXCUZl000 service=query query="CREATE DATABASE telegraf"
     influxdb  | [httpd] 172.19.0.3 - admin [05/Jan/2024:14:45:06 +0000] "POST /query HTTP/1.1 {'q': 'CREATE DATABASE "telegraf"'}" 200 57 "-" "Telegraf/1.29.1 Go/1.21.5" 04
     telegraf  | 2024-01-05T14:45:06Z D! [agent] Successfully connected to outputs.influxdb
     telegraf  | 2024-01-05T14:45:06Z D! [agent] Starting service inputs
     telegraf  | 2024-01-05T14:45:16Z D! [outputs.influxdb] Wrote batch of 18 metrics in 49.447167ms
     telegraf  | 2024-01-05T14:45:16Z D! [outputs.influxdb] Buffer fullness: 0 / 10000 metrics

[no-brand]

> use telegraf;
> show measurements;
name
----
cpu
disk
diskio
kernel
mem
processes
swap
system

> select * from cpu limit 5;
name: cpu
time                cpu       host         usage_guest usage_guest_nice usage_idle        usage_iowait usage_irq usage_nice usage_softirq        usage_steal usage_system        usage_user
----                ---       ----         ----------- ---------------- ----------        ------------ --------- ---------- -------------        ----------- ------------        ----------
1704465920000000000 cpu-total 5a1325e0ddd1 0           0                99.64903484582747 0            0         0          0.008356313194618664 0           0.1671262638923755  0.1754825770869925
1704465920000000000 cpu0      5a1325e0ddd1 0           0                99.59839357429529 0            0         0          0                    0           0.401606425702801   0
1704465920000000000 cpu1      5a1325e0ddd1 0           0                99.29718875502071 0            0         0          0                    0           0.4016064257028193  0.30120481927711223
1704465920000000000 cpu10     5a1325e0ddd1 0           0                99.79939819458393 0            0         0          0                    0           0.20060180541624836 0
1704465920000000000 cpu11     5a1325e0ddd1 0           0                99.59839357429755 0            0         0          0                    0           0.1004016064257026  0.30120481927711673

[no-brand]

outputs.file shows influxdb's line protocol

cpu,cpu=cpu0,host=9c6ff0a703db usage_nice=0,usage_iowait=0,usage_guest=0,usage_steal=0,usage_guest_nice=0,usage_user=0.10040160642570477,usage_system=0.20080321285140953,usage_idle=99.69879518072088,usage_irq=0,usage_softirq=0 1704467000000000000
...
cpu,cpu=cpu11,host=9c6ff0a703db usage_user=0.19999999999999574,usage_system=0.19999999999999574,usage_idle=99.60000000000036,usage_irq=0,usage_softirq=0,usage_guest_nice=0,usage_nice=0,usage_iowait=0,usage_steal=0,usage_guest=0 1704467000000000000
cpu,cpu=cpu-total,host=9c6ff0a703db usage_guest_nice=0,usage_user=0.20889037433154395,usage_idle=99.59057486630884,usage_steal=0,usage_irq=0,usage_softirq=0.00835561497326158,usage_guest=0,usage_system=0.18382352941175772,usage_nice=0,usage_iowait=0.00835561497326158 1704467000000000000

line protocol

https://docs.influxdata.com/influxdb/cloud/reference/syntax/line-protocol/

# syntax
<measurement>[,<tag_key>=<tag_value>[,<tag_key>=<tag_value>]] <field_key>=<field_value>[,<field_key>=<field_value>] [<timestamp>]
# example
myMeasurement,tag1=value1,tag2=value2 fieldKey="fieldValue" 1556813561098000000