start influxdb
docker run \
-p 8086:8086 \
-e INFLUXDB_DB=cadvisor \
-e INFLUXDB_HTTP_AUTH_ENABLED=true \
-e INFLUXDB_ADMIN_USER=root \
-e INFLUXDB_ADMIN_PASSWORD=root \
--name=influxdb influxdb
add this to manage data directory
-v $PWD:/var/lib/influxdb
create DB
curl -XPOST 'http://localhost:8086/query?u=root&p=root' --data-urlencode "q=CREATE DATABASE mydb"
curl -XPOST 'http://localhost:8086/query?u=root&p=root' --data-urlencode "q=CREATE DATABASE cadvisor"
insert value
curl -XPOST 'http://localhost:8086/write?u=root&p=root&db=mydb' --data-binary 'cpu_load_short,host=server01,region=us-west value=0.64 1434055562000000000'
curl -XPOST 'http://localhost:8086/write?u=root&p=root&db=mydb' --data-binary 'cpu_load_short,host=server01,region=us-west value=0.7 1434055572000000000'
curl -XPOST 'http://localhost:8086/write?u=root&p=root&db=mydb' --data-binary 'cpu_load_short,host=server01,region=us-west value=0.55 1434055582000000000'
list databases
curl -XPOST 'http://localhost:8086/query?u=root&p=root' --data-urlencode 'q=SHOW DATABASES' | jq
list tables
curl -XPOST 'http://localhost:8086/query?u=root&p=root&db=mydb' -u root:root --data-urlencode 'q=SHOW MEASUREMENTS' | jq
select values
curl -XPOST 'http://localhost:8086/query?u=root&p=root&db=mydb' -u root:root --data-urlencode 'q=SELECT * FROM cpu_load_short'
start cli
docker exec -it influxdb influx
docker run \
--volume=/:/rootfs:ro \
--volume=/var/run:/var/run:ro \
--volume=/sys:/sys:ro \
--volume=/var/lib/docker/:/var/lib/docker:ro \
--volume=/dev/disk/:/dev/disk:ro \
--publish=8080:8080 \
--name=cadvisor \
--link influxdb:influxdb \
--privileged \
google/cadvisor:latest \
-storage_driver=influxdb \
-storage_driver_host=influxdb:8086 \
-storage_driver_db=cadvisor \
-storage_driver_user=root \
-storage_driver_password=root
docker run \
-p 3000:3000 \
--name=grafana \
-e "GF_SERVER_ROOT_URL=http://ideaz.world:3000" \
-e "GF_SECURITY_ADMIN_PASSWORD=secret" \
--link influxdb:influxdb \
grafana/grafana
docker run -p 3000:3000 -e INFLUXDB_HOST=0.0.0.0 -e INFLUXDB_PORT=8086 -e INFLUXDB_NAME=cadvisor -e INFLUXDB_USER=root -e INFLUXDB_PASS=root --link influxdb:influxdb --name grafana grafana/grafana
go to http://localhost:3000
in interface "add data source" > influxdb
http: http://influxdb:8086
database: cadvisor
user: root
password: root
method: POST
save