InfluxDB

1.语法示例

select * from events where state == 'NY';
 
select * from log_lines where line =~ /error/i;
 
select * from events where customer_id == 23 and type == 'click';
 
select * from response_times where value > 500;
 
select * from events where email !~ /.*gmail.*/;
 
select * from nagios_checks where status != 0;
 
select * from events 
where (email =~ /.*gmail.* or email =~ /.*yahoo.*/) and state == 'ny';
 
delete from response_times where time > now() - 1h
//注意空格

非常容易上手, 还支持Group By, Merging Series, Joining Series， 并内置常用统计函数，比如max, min, mean 等

2.influxdb

Docker学习系列3-Influxdb使用入门

http://blog.csdn.net/u011537073/article/details/52852759

搭建telegraf、influxdb、grafana监控平台监控docker容器

http://blog.csdn.net/will0532/article/details/78344319

创建保存策略

CREATE RETENTION POLICY halfday ON bsm_monitor_db DURATION 12d REPLICATION 1 DEFAULT

运行命令

docker run -d -p 8083:8083 -p8086:8086 --expose 8090 --expose 8099 --name influxsrv tutum/influxdb:0.8.8

运行telegraf镜像

docker run -d -p 8083:8083 -p 8086:8086 -e ADMIN_USER="root" -e INFLUXDB_INIT_PWD="root" -e PRE_CREATE_DB="telegraf" --name influxdb tutum/influxdb:latest
docker run -d --name=telegraf -v /root/telegraf/telegraf.conf:/etc/telegraf/telegraf.conf -v /var/run:/var/run telegraf

页面中插入数据

treasures,captain_id=pirate_king value=2

curl插入数据

curl -d "cpu1,host:serverA,region=us_west value=0.64" "http://172.28.0.96:8086/write?db=telegraf"

六代单传的老代码，到底能不能动

不能动——“我还有老婆和孩子”

动完之后，会不会只剩下删库跑路这个结果了。

不动才10个bug，动完1000个bug。