Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Prometheus remote read influxdb

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!

like image 871
musca999 Avatar asked Oct 18 '18 20:10

musca999


People also ask

Can Prometheus use InfluxDB?

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.

How does Prometheus remote read work?

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.

How do I monitor InfluxDB?

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.

Which is better Prometheus or InfluxDB?

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.


1 Answers

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.

like image 181
Saleh Avatar answered Oct 19 '22 00:10

Saleh