6 InfluxData is based on the TICK stack, the first open source platform for managing IoT time-series data at scale.
11 Single-node influxdb, enabled http frontend and admin web interface:
29 Single-node influxdb, SSL for http frontend:
40 key_file: /etc/influxdb/ssl/key.pem
41 cert_file: /etc/influxdb/ssl/cert.pem
43 Single-node influxdb where you specify paths for data and metastore directories. Custom
44 directories are created by this formula:
52 dir: '/opt/influxdb/data'
53 wal_dir: '/opt/influxdb/wal'
55 dir: '/opt/influxdb/meta'
57 InfluxDB server with customized parameters for the data service:
65 max_series_per_database: 20000000
66 cache_max_memory_size: 524288000
67 cache_snapshot_memory_size: 26214400
68 cache_snapshot_write_cold_duration: "5m"
69 compact_full_write_cold_duration: "2h"2h"
70 max_values_per_tag: 5000
72 Single-node influxdb with an admin user:
94 Single-node influxdb with new users:
105 password: keepsecret1
110 password: keepsecret2
112 Single-node influxdb with new databases:
126 Manage the retention policies for a database:
142 Where default values are:
150 Here is how to manage grants on database:
184 location: http://idb01.local:8086/write
187 location: http://idb02.local:8086/write
193 location: idb01.local:9096
195 location: idb02.local:9096
208 http_address: 0.0.0.0
219 Deploy influxdb apt repository (using linux formula):
230 source: 'deb https://repos.influxdata.com/${linux:system:os} ${linux:system:dist} stable'
231 key_url: 'https://repos.influxdata.com/influxdb.key'
233 InfluxDB client for configuring databases, users and retention policies:
267 InfluxDB client state's that uses curl can be forced to retry query if curl call fails:
278 Create an continuous queries:
287 cq_avg_bus_passengers: >-
288 SELECT mean("passengers") INTO "transportation"."three_weeks"."average_passengers" FROM "bus_data" GROUP BY time(1h)
291 Example how to add options to http/udp/data/admin that are not supported by the formula yet:
301 - 'max-row-limit = 20000'
305 - 'max-row-limit = 20000'
309 - 'something_else = 10'
312 - 'something_here = 55'
315 Rich example for RP and CQ for Telegraf vmstats collected:
344 SELECT sum(*) as sum_1m, count(*) as count_1m, median(*) as median_1m, mode(*) as mode_1m, mean(*) as mean_1m, max(*) as max_1m, min(*) as min_1m INTO "vmstats"."a_week".:MEASUREMENT FRO
346 SELECT sum(*) as sum_10m, count(*) as count_10m, median(*) as median_10m, mode(*) as mode_10m, mean(*) as mean_10m, max(*) as max_10m, min(*) as min_10m INTO "vmstats"."a_month".:MEASURE
348 SELECT sum(*) as sum_h, count(*) as count_h, median(*) as median_h, mode(*) as mode_h, mean(*) as mean_h, max(*) as max_h, min(*) as min_h INTO "vmstats"."a_month".:MEASUREMENT FROM /.*/
350 SELECT sum(*) as sum_d, count(*) as count_d, median(*) as median_d, mode(*) as mode_d, mean(*) as mean_d, max(*) as max_d, min(*) as min_d INTO "vmstats"."a_year".:MEASUREMENT FROM /.*/
352 SELECT sum(*) as sum_w, count(*) as count_w, median(*) as median_w, mode(*) as mode_w, mean(*) as mean_w, max(*) as max_w, min(*) as min_w INTO "vmstats"."a_year".:MEASUREMENT FROM /.*/
354 SELECT sum(*) as sum_m, count(*) as count_m, median(*) as median_m, mode(*) as mode_m, mean(*) as mean_m, max(*) as max_m, min(*) as min_m INTO "vmstats"."a_decade".:MEASUREMENT FROM /.*
356 SELECT sum(*) as sum_y, count(*) as count_y, median(*) as median_y, mode(*) as mode_y, mean(*) as mean_y, max(*) as max_y, min(*) as min_y INTO "vmstats"."a_decade".:MEASUREMENT FROM /.*
359 Prunning data and data management:
361 Intended to use in scheduled jobs, executed to maintain data life cycle above retention policy. These states are executed by
362 ``query.sls`` and you are expected to trigger ``sls_id`` individually.
371 drop_measurement_h2o: >-
372 DROP MEASUREMENT h2o_quality
374 DROP SHARD h2o_quality
375 drop_series_h2o_feet: >-
376 DROP SERIES FROM "h2o_feet"
377 drop_series_h2o_feet_loc_smonica: >-
378 DROP SERIES FROM "h2o_feet" WHERE "location" = 'santa_monica'
379 delete_h2o_quality_rt3: >-
380 DELETE FROM "h2o_quality" WHERE "randtag" = '3'
381 delete_h2o_quality: >-
382 DELETE FROM "h2o_quality"
385 .. code-block:: shell
387 salt \* state.sls_id influxdb_query_delete_h2o_quality influxdb.query
390 InfluxDB relay with HTTP outputs:
410 location: http://server1:8086/write
414 max_delay_interval: 30s
416 location: http://server2:8086/write
421 * https://influxdata.com/time-series-platform/influxdb/
423 Documentation and Bugs
424 ======================
426 To learn how to install and update salt-formulas, consult the documentation
429 http://salt-formulas.readthedocs.io/
431 In the unfortunate event that bugs are discovered, they should be reported to
432 the appropriate issue tracker. Use Github issue tracker for specific salt
435 https://github.com/salt-formulas/salt-formula-influxdb/issues
437 For feature requests, bug reports or blueprints affecting entire ecosystem,
438 use Launchpad salt-formulas project:
440 https://launchpad.net/salt-formulas
442 You can also join salt-formulas-users team and subscribe to mailing list:
444 https://launchpad.net/~salt-formulas-users
446 Developers wishing to work on the salt-formulas projects should always base
447 their work on master branch and submit pull request against specific formula.
449 https://github.com/salt-formulas/salt-formula-influxdb
451 Any questions or feedback is always welcome so feel free to join our IRC
454 #salt-formulas @ irc.freenode.net