Hacker News Reader

Comment by liketochill | Hacker News Reader

Did you consider Victoria metrics at all? It is based on clickhouse design. I am considering it for time series type historian so different Application but I think it could work where clickhouse works too.

View on HN

Haven't heard of it unfortunately. What kind of time series data are you thinking of storing? If you're building an application on top of it, you're better off using an OLAP DB like ClickHouse, InfluxDB, etc. to have access to lower-level constructs.

My time series are from PLC in hydro electric power stations. Usually about 1000 series per turbine and another 1000 for general plant or river stuff. So it is just timestamp and bool, 16 or 32 bit u/int, or 32 bit float. Will just use grafana as front end. Seems to replace industry heavyweight offerings such as Osisoft Pi.

For those who have not used VictoriaMetrics, it is a high performance time series database that can drop-in replace Prometheus. We host ClickHouse at our company but use VictoriaMetrics for long term storage of prometheus metrics across tenants. It's fast, solid, and super economical to run.

If you want to learn more here's a webinar I did with Roman Kavronenko at VictoriaMetrics that compares it with ClickHouse.

https://www.youtube.com/watch?v=sCrdp8hIhJM

Disclaimer: I work for Altinity.

Does it work well to store logs? I thought it's great for metrics.

Clickhouse has been around for longer and battle tested at Yandex. In what cases might VictoriaMetrics be a better fit?

Have not seen Victoria! Seems like they don't have a cloud offering though?

They do have a "managed" offering (on AWS): https://victoriametrics.com/products/managed/.

Very cool. My mistake for overlooking that. Victoria metrics seems more like a metrics store? Something comparable to influx? Is that right?

Correct! It is a TimeSeries database for storing metrics. It is open source, including clustered version, and contains many additional tools for alerting, collecting and visualizing metrics. There are many in VictoriaMetrics community who switched from Influx to VictoriaMetrics due to performance reasons. See also the following doc comparing differences between these two here https://docs.victoriametrics.com/guides/migrate-from-influx....

Disclaimer: I'm one of the VictoriaMetrics maintainers.

Reply on news.ycombinator.com