InfluxDB安装配置

InfluxDB安装配置

环境:
CentOS7.2
influxdb1.2.0


https://github.com/influxdata/influxdb


一.安装
https://docs.influxdata.com/influxdb/v1.2/introduction/installation/
https://portal.influxdata.com/downloads
rpm -ivh https://dl.influxdata.com/influxdb/releases/influxdb-1.2.0.x86_64.rpm

二.启服务
systemctl start influxdb

三.测试
1.CLI
influx -host 192.168.8.254 -port 8086 -execute 'CREATE DATABASE mydb'
USE mydb
INSERT cpu,host=serverA,region=us_west value=0.64
2.HTTP API
https://docs.influxdata.com/influxdb/v1.2/guides/writing_data/
建库
curl -i -XPOST http://localhost:8086/query --data-urlencode "q=CREATE DATABASE mydb"

curl -i -XPOST "http://192.168.8.254:8086/db?u=root&p=root" -d "{"name": "collectd"}"

写入单条point
curl -i -XPOST 'http://localhost:8086/write?db=mydb' --data-binary 'cpu_load_short,host=server01,region=us-west value=0.64 1434055562000000000'
写入多条points
curl -i -XPOST 'http://localhost:8086/write?db=mydb' --data-binary 'cpu_load_short,host=server02 value=0.67
cpu_load_short,host=server02,region=us-west value=0.55 1422568543702900257
cpu_load_short,direction=in,host=server01,region=us-west value=2.0 1422568543702900257'
从文件读取
cat >cpu_data.txt <<HERE
cpu_load_short,host=server02 value=0.67
cpu_load_short,host=server02,region=us-west value=0.55 1422568543702900257
cpu_load_short,direction=in,host=server01,region=us-west value=2.0 1422568543702900257
HERE
curl -i -XPOST 'http://localhost:8086/write?db=mydb' --data-binary @cpu_data.txt
查询
curl -G 'http://localhost:8086/query?pretty=true' --data-urlencode "db=mydb" --data-urlencode "q=SELECT "value" FROM "cpu_load_short" WHERE "region"='us-west';SELECT count("value") FROM "cpu_load_short" WHERE "region"='us-west'"

四.启用认证
https://docs.influxdata.com/influxdb/v1.2/query_language/authentication_and_authorization/
配置文件httpd启用后重启influxdb
[http]
enabled = true 
bind-address = ":8086"
auth-enabled = true
log-enabled = true 
write-tracing = false 
pprof-enabled = false 
https-enabled = false 
https-certificate = "/etc/ssl/influxdb.pem"
创建用户
CREATE USER "admin" WITH PASSWORD "admin" WITH ALL PRIVILEGES
授权
GRANT ALL PRIVILEGES TO "admin"
修改密码
SET PASSWORD FOR "todd" = 'influxdb4ever'
删除用户
DROP USER todd
测试连接
1.CLI
influx -username admin -password admin
2.HTTP API
curl -G http://localhost:8086/query -u admin:admin --data-urlencode "q=SHOW DATABASES"
curl -G "http://localhost:8086/query?u=admin&p=admin" --data-urlencode "q=SHOW DATABASES"
curl -G http://localhost:8086/query --data-urlencode "u=admin" --data-urlencode "p=admin" --data-urlencode "q=SHOW DATABASES"

五.WEB UI
https://docs.influxdata.com/influxdb/v1.2/tools/web_admin/
说明:从1.1版本开始例取消了内嵌的WEB UI功能，即使配置文件[admin]中启用也不会有任何变化更不会监听以前默认的8083端口

六.启用https
https://docs.influxdata.com/influxdb/v1.2/administration/https_setup/
1.修改配置
[http]
enabled = true 
bind-address = ":8086"
auth-enabled = true
log-enabled = true 
write-tracing = false 
pprof-enabled = false 
https-enabled = true
https-certificate = "/etc/ssl/certs/influxdb-selfsigned.crt"
https-private-key = "/etc/ssl/certs/influxdb-selfsigned.key"
这里采用自签名证书，过程略
2.重启influxdb
3.访问
influx -ssl -unsafeSsl


七.集群
https://docs.influxdata.com/influxdb/v1.2/high_availability/
https://github.com/influxdata/influxdb-relay/blob/master/README.md
和大多开源产品一样，开源的influxdb不支持cluster等高级功能