InfluxDB
Developed in go language, InfluxDB is a Time Series database with very interesting performances and data compression.
Data ingestion is easy to implement and its integration into reporting tools like Grafana very mature.
InfluxDB v2, Flux language and SQL databases March 8th, 2021
Great new feature of the InfluxDB v2 time series databases and its Flux language : the gateways to SQL databases engines (PostgreSQL, MySQL, Microsoft SQL Server…).
From InfluxDB, to interact with SQL databases, 2 straightforward functions : sql.from and sql.to
Use cases and specific considerations about data types conversions.
InfluxDB - Flux language, advanced features March 1st, 2021
The new Flux language introduced in InfluxDB v2 addresses many InfluxQL language limitations.
Overview of advanced Flux features : joins, pivots, histograms, computed columns (map), custom aggregate functions (reduce).
In most topics, real use cases are discussed : joining data when timestamps differ by a few seconds, simulating outer joins waiting for the new join methods to come (left, right…), building histograms without cumulative data but the difference… InfluxDB v2 : Flux language, quick reference guide and cheat sheet February 19th, 2021
InfluxDB v2 Flux language, quick reference guide and cheat sheet.
Querying data, filters, windowing, joins, pivots, histograms, map, reduce, SQL data sources… InfluxDB - Moving from InfluxQL to Flux language February 5th, 2021
Moving from InfluxQL (SQL-Like) to InfluxDB v2 Flux language is confusing at the beginning, but you learn the mechanics very quickly.
An overview of the migration of existing InfluxQL queries to Flux (filters, windowing, copying data, etc.). InfluxDB - Migration to version 2 February 1st, 2021
InfluxDB v2 has been released in November 2020.
Upgrading from InfluxDB v1.8 to InfluxDB v2 is quite easy, bear in mind :
- A database + retention policy is a bucket in version 2.
- Backward compatibility with 1.x API is guaranteed, but only for authenticated 1.x users.
- Continuous queries must be migrated to Flux tasks.
- InfluQL is replaced by Flux language.
- Native support of OpenTSDB, Graphite… protocols is removed, Telegraf must be implemented.
InfluxDB v2, Getting started. Preparing the migration from version 1.7 February 17th, 2020
The migration to InfluxDB v2 will need adjustments, many InfluxDB v1 functionalities are replaced in version 2. Migration procedure from version 1.x to version 2 is not yet unveiled, surely it will preconize export/import methods.
The terminology is a little bit modified in version 2 : a database is now a bucket and an organization is necessarily attached to a bucket. No changes about the InfluxDB Line protocol.
In this article : getting started with InfluxDB v2 and the breaks to manage when scheduling migration from version 1.x
InfluQL is replaced by the language Flux, Continuous queries are replaced by tasks.
Native support of the protocols Graphite, OpenTSDB… is removed, Telegraf will have to be used. Grafana plugin for Flux is not yet fully ready. Understanding, installing and using the time series database InfluxDB 1.7 February 7th, 2020
InfluxDB is a high performance time series database with efficient compression.
The architecture is well designed (measurements retentions, shards) with easy ingestion, natively or through common time series protocols (OpenTSDB, Graphite…).
Queries are SQL Like and the reporting is intuitive with Grafana or Chronograf.
This introduction to InfluxDB v 1.7 also points out the breaks with the next major version 2.0.