Projects/InfluxDB Setup

From Playful Exploration
Jump to navigation Jump to search

Objective

  • Provide a Database for measurements
  • Manage memory smartly:
    • Allow for high sampling rates e.g. 4 values/second
    • Short retention for high sampling rate data e.g. 1 hour
    • Multiple levels of automatic down-sampling using aggregation with increasing retention for each level

Retention and Down-Sampling

sample rate/aggregate retention # of values InfluxDB Retention and Continuous Query Setup
0.25 seconds (raw data) 1 hour 14400

CREATE RETENTION POLICY default ON weather DURATION 1h REPLICATION 1 DEFAULT

15 minutes 10 years 345600

CREATE RETENTION POLICY _10years ON weather DURATION 1d REPLICATION 1

CREATE CONTINUOUS QUERY CQ_15min ON weather BEGIN SELECT median(value) as value INTO weather._10years.:measurement FROM /^[a-z].*/ GROUP BY time(15m) fill(none) END

  • 360000 measurement, 5.76MB at 16Byte per measurement