I'm new to Prometheus but familiar with Influx (currently running 1.6).
My understanding is it's possible to configure Prometheus to remotely read data from influx with the following configuration in prometheus.yml:
remote_read:
url: "http://localhost:8086/api/v1/prom/read?db=bulkstats"
"bulkstats" is the database I'm trying to read data from in Prometheus. An example query that would work in influx would be:
SELECT "sess-curaaaactive" FROM "PDSNSYSTEM1" WHERE ("Nodename" = 'ALPRGAGQPNC') AND time >= now() - 6h"
However I cannot find one example of how to query that data from PromQL. Please help!
Blog: InfluxDB Now Supports Prometheus Remote Read & Write Natively. GitHub: Prometheus remote read and write API Support. Blog: InfluxDB and Kapacitor: An Enhanced Data Model and Functional Query Language.
The key idea of the remote read is to allow querying Prometheus storage (TSDB) directly without PromQL evaluation. It is similar to the Querier interface that the PromQL engine uses to retrieve data from storage. This essentially allows read access of time series in TSDB that Prometheus collected.
To monitor the internal performance of InfluxDB, enable the InfluxDB input plugin in the Telegraf configuration files used to run Telegraf on InfluxDB instances. The InfluxDB input plugin pulls InfluxDB internal metrics from the local InfluxDB /debug/vars endpoint.
If monitoring is what you're most interested in, Prometheus is your safest bet because of its many integrations and scalable model. If you're more likely to be using a time series database for IoT, sensors, or analytics, then you'll probably want to choose InfluxDB.
Here is the link which matches prometheus format with influxdb's one.
In terms of prometheus's jargon, in your example, sess-curaaaactive
is the metric name (measurement in influx) and ("Nodename" = 'ALPRGAGQPNC')
is just a label which prometheus attaches to the measurement to create a time series.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With