#容器外面执行命令curl -i -XPOST http://localhost:8086/query --data-urlencode "q=CREATE DATABASE testdb"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'
./influx -database 'testdb' -execute 'auth admin123 admin123'
show users; 启用用户密码后,会报错
输入 influx -username 'admin' -password 'beyond_2021'
保存策略
show retention policies on test 显示test数据库策略 如果没有指定策略默认是autogen
对test数据库创建一个策略,2小时之前数据删除,一个副本,设置为默认策略
create retention policy "abc" on "test" duration 2h replication 1 default
10天前数据删除 比如:h(小时),w(星期)
create retention policy "rp_10d" on "testdata" duration 10d replication 1 default
修改默认策略
alter retention policy "autogen" on "demo" duration 10d replication 1 default
alter 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 "devdata"
指定策略查询数据
select * from "autogen"."devdata"
show tag keys from 表名
show field keys from 表名
修改容器时区
dockerexec -it my-influxdb /bin/bash
date 查看时区
cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime
修改后查看 date