Anyone used ClickHouse as remote_write?

[an...@signoz.io]

Has anyone sent Prometheus Metrics to ClickHouse?

I need to understand how metric types Counter and Gauge be ingested to ClickHouse? ClickHouse has a rollup feature to sum up events before ingestion but the Counters are already summed up. Also, Gauge metric can decrease over time. I can't clearly see how this can be handled in ClickHouse.

There is a repo to remote_write to clickhouse 
https://github.com/mindis/prom2click#getting-started

Will the table schema work for my above concerns?

[Aliaksandr Valialkin]

Probably you need VictoriaMetrics instead of ClickHouse. It is built on top of ClickHouse architecture ideas, which give good performance. It provides PromQL-like query language instead of SQL - MetricsQL - which is better suited for typical queries for monitoring. See https://faun.pub/victoriametrics-creating-the-best-remote-storage-for-prometheus-5d92d66787ac and https://valyala.medium.com/how-victoriametrics-makes-instant-snapshots-for-multi-terabyte-time-series-data-e1f3fb0e0282 .

--
You received this message because you are subscribed to the Google Groups "Prometheus Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to prometheus-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/5973e5ec-e070-45be-8dca-d18120d4d5e4n%40googlegroups.com.

--

Best Regards,

Aliaksandr Valialkin, CTO VictoriaMetrics

[an...@signoz.io]

I want to store trace data also in ClickHouse and thus a single pane for metrics and traces. 
Though I would say I have heard good things about Victoria Metrics. Can you point me towards using Clickhouse as remote_write?