InfluxDB

InfluxDB 是一个 Go 语言开发的开源(MIT)分布式时间序列数据库。

TICK堆栈

• Telegraf 数据采集
• InfluxDB 数据存储
• Chronograf 数据可视化
• Kapacitor 监控告警&ETL

应用场景

• 定制DevOps监控(Custom DevOps Monitoring)
• 实时分析(Real Time Analytics)
• 物联网和传感器数据(IoT and Sensor Data)
• 云计算(Cloud & OpenStack)
• 异常检测(Anomaly Detection)
• 消息(Messaging)
• 个性化(Personalization)
• 股票交易(Equities Trading)
• 市政基础设施管理(Municipal Infrastructure Management)
• GPS服务(GPS Services)
• 量子物理研究(Quantum Physics Research)
• POS系统(Point of Sale Systems)
• 制造业和家庭自动化(Manufacturing & Home Automation)
• 运输和物流(Transportation & Material Logistics)

指南

OS X 安装

$ brew update
$ brew install influxdb
$ influxd
$ influx
Visit https://enterprise.influxdata.com to register for updates, InfluxDB server management, and monitoring.
Connected to http://localhost:8086 version 0.9.6.1
InfluxDB shell 0.9.6.1
> create database mydb
> show databases
> use mydb
> show series
> show measurements
> show tag keys
> show field keys

指南

创建数据库

curl -G 'http://localhost:8086/query' --data-urlencode "q=CREATE DATABASE mydb"

插入数据

curl -XPOST 'http://localhost:8086/write?db=mydb' -d 'cpu,host=server01,region=uswest load=42 1434055562000000000'
curl -XPOST 'http://localhost:8086/write?db=mydb' -d 'cpu,host=server02,region=uswest load=78 1434055562000000000'
curl -XPOST 'http://localhost:8086/write?db=mydb'-d 'cpu,host=server03,region=useast load=15.4 1434055562000000000'

查询数据

curl -G http://localhost:8086/query?pretty=true --data-urlencode "db=mydb" --data-urlencode "q=SELECT * FROM cpu WHERE host='server01' AND time < now() - 1d"

分析数据

curl -G http://localhost:8086/query?pretty=true --data-urlencode "db=mydb" --data-urlencode "q=SELECT mean(load) FROM cpu WHERE region='uswest'"

Grafana

Grafana 是面向 Graphite, InfluxDB & OpenTSDB 可视化仪表盘。

图集

• 

  TICK堆栈

• 

  TICK堆栈

• 

  IoT

• 

  OpenStack告警日志指标管理

• 

  实时分析

• 

  DevOps监控

链接

• InfluxDB官网
• InfluxDB @ GitHub
• InfluxData Blog
• How to send sensor data to InfluxDB from an Arduino Uno