CentOS离线装置InfluxDB

InfluxDB和IotDB介绍与性能比照

InfluxDB官网下载地址

#解压tar -zxvf influxdb-1.7.10-static_linux_amd64.tar.gz#nohup后盾启动,指定配置文件,输入日志到log.file文件nohup /home/influxdb-1.7.10-1/influxd -config /home/influxdb-1.7.10-1/influxdb.conf >> /home/influxdb-1.7.10-1/log.file  2>&1 &#减少 开机自启动vim /etc/rc.d/rc.local#关上后, 最初增加如下命令nohup /home/influxdb-1.7.10-1/influxd -config /home/influxdb-1.7.10-1/influxdb.conf >> /home/influxdb-1.7.10-1/log.file  2>&1 &
终端连贯InfluxDB
cd /home/influxdb-1.7.10-1/#连贯InfluxDB 默认没有设置用户名和明码./influx#如果设置了用户名和明码时./influx -username 'admin' -password 'abcd_2021'#近程连贯其余InfluxDB./influx -host 192.168.1.2 -port 8086 -username admin -password abcd_2021
开启udp

批改配置文件: influxdb.conf

[[udp]]
enabled = true 开启udp

Java调用时 influxDB.write(8089, builder.build());

MacBook离线装置InfluxDB

#下载wget https://dl.influxdata.com/influxdb/releases/influxdb-1.6.4_darwin_amd64.tar.gz#解压tar -zxvf influxdb-1.6.4_darwin_amd64.tar.gz#进入目录cd software/influxdb-1.6.4-1/usr/bin #启动服务,默认配置启动./influxd#指定配置启动./influxd -config ../../etc/influxdb/influxdb.conf #连贯influxDB./influx#近程连贯其余InfluxDB./influx -host 192.168.1.2 -port 8086 -username admin -password abcd_2021

Docker装置InfluxDB

Centos7离线装置Docker

#下载镜像docker pull influxdb#运行容器,把配置文件挂载到宿主机/data/influxdb目录,把数据文件也挂载进去,避免数据失落, 挂载时区,不然默认是0时区docker run -d --name my-influxdb \-p 8086:8086 \-p 8083:8083 \-p 2003:2003 \-e INFLUXDB_GRAPHITE_ENABLED=true \-v /data/influxdb/conf/influxdb.conf:/etc/influxdb/influxdb.conf \-v /data/influxdb:/var/lib/influxdb \-v /etc/localtime:/etc/localtime \influxdb

InfluxDB应用

默认是不必用户名和明码的, 是否开启认证，默认值：false

cat /data/influxdb/conf/influxdb.conf [meta]  dir = "/var/lib/influxdb/meta"[data]  dir = "/var/lib/influxdb/data"  engine = "tsm1"  wal-dir = "/var/lib/influxdb/wal"[http]  auth-enabled = false

创立用户名和明码后,批改为开启认证

#连贯influxDB./influx#如果是容器启动,进入容器docker exec -it my-influxdb /bin/bash输出 influx#创立用户名和明码,并给所有权限create user "admin" with password 'abcd_2021' with all privileges#登录auth admin abcd_2021 #查询数据库show databases;#创立数据库create database demo

创立好用户名和明码后,批改auth-enabled = true
重启服务或重启容器失效,就必须要应用 用户名和明码连贯

#http形式创立数据库testdbcurl -i -X POST http://localhost:8086/query --data-urlencode "q=CREATE DATABASE testdb"#http形式创立用户名和明码curl -XPOST http://localhost:8086/query --data-urlencode "q=create user "admin123" with password 'admin123' with all privileges"#其余形式./influx -database 'testdb' -execute 'auth admin123 admin123'

InfluxDB保留策略

#显示test数据库策略 如果没有指定策略默认是autogenshow retention policies on test #对test数据库创立一个策略,2小时之前数据删除,一个正本,设置为默认策略create retention policy "abc" on "test" duration 2h replication 1 default#10天前数据删除  比方：h（小时），w（星期）create retention policy "rp_10d" on "iotdata" duration 10d replication 1 default#批改默认策略alter retention policy "autogen" on "demo" duration 10d replication 1 defaultalter retention policy "autogen" on "demo" duration 15d replication 1 default#批改策略alter retention policy "rp_10d" ON "demo" duration 10d replication 1 default#插入数据不指定策略,按默认策略保留insert into devops,host=server01 cpu=23.1,mem=0.61#指定策略保留数据insert into "autogen" devops,host=server01 cpu=23.1,mem=0.71#查问时不指定策略,按默认策略查问select * from "devops"#指定策略查问数据select * from "autogen"."devops"show tag keys from 表名show field keys from 表名