一. 数据库配置
- 查询: show database
- 创建: CREATE DATABASE {database_name} [WITH [DURATION ] [REPLICATION ] [SHARD DURATION ] [NAME ]
- 删除: DROP DATABASE {database_name}
二. RETENTION POLICY
- 查询: SHOW RETENTION POLICIES
- 创建: CREATE RETENTION POLICY {retention_policy_name} ON {database_name} DURATION {duration} REPLICATION {n} [SHARD DURATION {duration}] [DEFAULT]
- CREATE RETENTION POLICY rp_10m on hubble duration 9408h0m0s REPLICATION 1 SHARD DURATION 168h0m0s
- CREATE RETENTION POLICY rp_1h on hubble duration 8760h0m0s REPLICATION 1 SHARD DURATION 168h0m0s
- CREATE RETENTION POLICY rp_6h on hubble duration 52560h0m0s REPLICATION 1 SHARD DURATION 168h0m0s
- 修改: ALTER RETENTION POLICY {rp_name} ON {database_name} DURATION {duration} REPLICATION {n} SHARD DURATION {duration} DEFAULT
- 删除: DROP RETENTION POLICY {rp_name} ON {database_name}
三. CONTINUOUS QUERY
- 查询: SHOW CONTINUOUS QUERY
- 删除: DROP CONTINUOUS QUERY {cq_name} ON {database_name}
四. API
InfluxDB API提供了较简单的方式用于数据库交互。该API使用了HTTP的方式,并以JSON格式进行返回。