G
G
geebv2016-08-09 20:19:44
Database
geebv, 2016-08-09 20:19:44

What database is best for storing data from sensors?

From one sensor every 5 seconds 1kb of data. About 10,000 sensors. For a day 10000kb * 12 * 60 * 24 \u003d 165 GB per day. Store data for no more than a day.
It is ideal to directly write to the database without queues and so on.
Requests: for plotting a graph (the last 1000 data on the sensor) - single requests.

  • Cassandra. Cons: Difficult to set up. Resource intensive.
  • ClickHouse pros/cons???
  • BoltDB No ttl, ...??
  • More options?

Answer the question

In order to leave comments, you need to log in

3 answer(s)
N
nirvimel, 2016-08-10
@nirvimel

RRDtool , for example.

G
geebv, 2016-08-10
@geebv

nats -> influxdb

I
index0h, 2016-08-09
@index0h

Look aside: statsd -> graphite, or statsd -> influxdb

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question