InfluxDB: Difference between revisions
Jump to navigation
Jump to search
| Line 37: | Line 37: | ||
=Premiers Pas= |
=Premiers Pas= |
||
==Via l'interface Web== |
|||
Créez une base : mydb |
|||
Ajoutez un point dans la série temporelle log_lines (write point) |
|||
<pre> |
|||
{ "line":"here's some useful log info from paul@influx.com", "like":1 } |
|||
</pre> |
|||
puis un autre |
|||
<pre> |
|||
{ "line":"here's another useful log info from paul@influx.com", "like":2} |
|||
</pre> |
|||
puis un autre |
|||
<pre> |
|||
{ "line":"here's some useful log info from didier@donsez.com", "like":1 } |
|||
</pre> |
|||
Exécutez les requêtes suivantes: |
|||
<pre> |
|||
select line from log_lines |
|||
</pre> |
|||
<pre> |
|||
select line from log_lines where line =~ /paul@influx.com/ |
|||
</pre> |
|||
<pre> |
|||
select line from log_lines where like > 1 |
|||
</pre> |
|||
<pre> |
|||
select like from log_lines |
|||
</pre> |
|||
<pre> |
|||
select like from log_lines |
|||
where time > now() - 1d |
|||
</pre> |
|||
Agrégat temporel |
|||
<pre> |
|||
select mean(like) from blog |
|||
group by time(1m) |
|||
where time > now() - 1d |
|||
</pre> |
|||
==Via l'interface REST== |
|||
<pre> |
|||
curl -G 'http://localhost:8086/db/mydb/series?u=root&p=root&pretty=true' --data-urlencode "q=select * from log_lines" |
|||
</pre> |
|||
=Premières Requêtes= |
=Premières Requêtes= |
||
Revision as of 12:53, 30 October 2014
https://github.com/influxdb/influxdb
open-source distributed time series database with no external dependencies.
(metrics, events, and analytics)
developped in Go language
Voir https://speakerdeck.com/pauldix/introducing-influxdb-an-open-source-distributed-time-series-database
Demo sur http://play.influxdb.com/ (source code)
InfluxDB @ AIR
Installation
On OS X
brew update brew install influxdb
Démarrage
influxdb -config=/usr/local/etc/influxdb.conf
Naviguez sur http://localhost:8083/ username : root & password : root
Pensez à changer ces valeurs quand vous mettez influxdb en production
Premiers Pas
Via l'interface Web
Créez une base : mydb
Ajoutez un point dans la série temporelle log_lines (write point)
{ "line":"here's some useful log info from paul@influx.com", "like":1 }
puis un autre
{ "line":"here's another useful log info from paul@influx.com", "like":2}
puis un autre
{ "line":"here's some useful log info from didier@donsez.com", "like":1 }
Exécutez les requêtes suivantes:
select line from log_lines
select line from log_lines where line =~ /paul@influx.com/
select line from log_lines where like > 1
select like from log_lines
select like from log_lines where time > now() - 1d
Agrégat temporel
select mean(like) from blog group by time(1m) where time > now() - 1d
Via l'interface REST
curl -G 'http://localhost:8086/db/mydb/series?u=root&p=root&pretty=true' --data-urlencode "q=select * from log_lines"