ITPub博客

https://docs.influxdata.com/influxdb/v0.13/guides/downsampling_and_retention/# 自动执行查询CREATE CONTINUOUS QUERY cq_30m ON food_data BEGIN SELECT mean(website) AS mean_website,mean(phone) AS mean_phone INTO food_data."default".downsampled_orders FROM orders GROUP BY time(30m) END...

https://docs.influxdata.com/influxdb/v0.13/guides/downsampling_and_retention/# RP 的数据管理策略https://docs.influxdata.com/influxdb/v0.13/query_language/database_management/#retention-policy-management#每个database创建时，默认会自动创建一个RP每个database可以有多个RPwrite时如果不知道RP，默认...

### APIhttps://docs.influxdata.com/influxdb/v0.13/concepts/api/## write curl -i -XPOST 'http://192.168.1.12:8086/write?db=test_dba' --data-binary 'cpu_load_short,host=server01,region=us-west value=0.64 1434055562000000000'## query# pretty=true， 以json格式输出curl -GET 'http://192.168.1...

https://github.com/influxdata/influxdb-relay# 依赖 go 1.5++### 原理只负责write的高可用，write时根据配置的每个节点都要写一次，相当于多写read需要其他工具做Load Balance# 安装，Install influxdb-relay to your $GOPATH/bingo get -u github.com/influxdata/influxdb-relay### docker 编译BuildingTh...

https://docs.influxdata.com/influxdb/v0.13/administration/backup_and_restore/##### 备份# 备份 metastore, InfluxDB’s metastore contains internal information about the status of the system:#  including: user information, database/shard metadata, and which retention policies are enabledinf...

https://docs.influxdata.com/influxdb/v0.13/administration/authentication_and_authorization/#authorization# /etc/influxdb/influxdb.conf# 必须在未开启前创建用户[http]  auth-enabled = false|true### 授权# admin# GRANT ALL PRIVILEGES TO # REVOKE ALL PRIVILEGES FROM CR...

# 存储引擎https://docs.influxdata.com/influxdb/v0.13/concepts/storage_engine/一开始使用LevelDB(Log Structured Merge Tree or LSM Tree)，0.9后使用BoltDB( mmap B+Tree database )# 添加yum源> vim /etc/yum.repos.d/influxdb.repo[influxdb]name = InfluxDB Repository - RHEL \$releaseverbaseurl = http...