本节讲解InfluxDB的安装及测试数据导入
1、InfluxDB安装
# 配置apt库
wget -qO- https://repos.influxdata.com/influxdb.key | sudo apt-key add -
source /etc/lsb-release
echo "deb https://repos.influxdata.com/${DISTRIB_ID,,} ${DISTRIB_CODENAME} stable" | sudo tee /etc/apt/sources.list.d/influxdb.list
# 安装influxdb
sudo apt-get update
sudo apt-get install influxdb
# 服务启动
sudo service influxdb start
# 或
sudo systemctl start influxdb
# 前台运行
influxd -config /etc/influxdb/influxdb.conf
# 查看日志
journalctl -u influxdb
# 日志输出到文件
journalctl -u influxdb> influxd.log
# 默认开启端口
#TCP 8086 客户端操作
#TCP 8088 备份及还原
# 默认关闭端口
# TCP 2003 Graphite service
# TCP 4242 OpenTSDB service
# UDP 8089 UDP service
# TCp 25826 Collectd service
2、测试数据导入
# 获取数据 wget https://s3.amazonaws.com/noaa.water-database/NOAA_data.txt # 创建数据库 influx Connected to http://localhost:8086 version 1.8.0 InfluxDB shell version: 1.8.0 > CREATE DATABASE noaa_water_db > exit # 导入数据 influx -import -path=NOAA_data.txt -precision=s -database=NOAA_water_database 2020/06/15 16:34:37 Processed 1 commands 2020/06/15 16:34:37 Processed 76290 inserts 2020/06/15 16:34:37 Failed 0 inserts
3、查看数据库情况
# 查看数据库 influx Connected to http://localhost:8086 version 1.8.0 InfluxDB shell version: 1.8.0 > show databases name: databases name ---- _internal NOAA_water_database > use NOAA_water_database Using database NOAA_water_database > show measurements name: measurements name ---- average_temperature h2o_feet h2o_pH h2o_quality h2o_temperature > show retention policies name duration shardGroupDuration replicaN default ---- -------- ------------------ -------- ------- autogen 0s 168h0m0s 1 true > show series key --- average_temperature,location=coyote_creek average_temperature,location=santa_monica h2o_feet,location=coyote_creek h2o_feet,location=santa_monica h2o_pH,location=coyote_creek h2o_pH,location=santa_monica h2o_quality,location=coyote_creek,randtag=1 h2o_quality,location=coyote_creek,randtag=2 h2o_quality,location=coyote_creek,randtag=3 h2o_quality,location=santa_monica,randtag=1 h2o_quality,location=santa_monica,randtag=2 h2o_quality,location=santa_monica,randtag=3 h2o_temperature,location=coyote_creek h2o_temperature,location=santa_monica > show tag keys name: average_temperature tagKey ------ location name: h2o_feet tagKey ------ location name: h2o_pH tagKey ------ location name: h2o_quality tagKey ------ location randtag name: h2o_temperature tagKey ------ location > show tag values with key="location" name: average_temperature key value --- ----- location coyote_creek location santa_monica name: h2o_feet key value --- ----- location coyote_creek location santa_monica name: h2o_pH key value --- ----- location coyote_creek location santa_monica name: h2o_quality key value --- ----- location coyote_creek location santa_monica name: h2o_temperature key value --- ----- location coyote_creek location santa_monica > show field keys name: average_temperature fieldKey fieldType -------- --------- degrees float name: h2o_feet fieldKey fieldType -------- --------- level description string water_level float name: h2o_pH fieldKey fieldType -------- --------- pH float name: h2o_quality fieldKey fieldType -------- --------- index float name: h2o_temperature fieldKey fieldType -------- --------- degrees float