3 ms·

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 th

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.

podoman 3y ago
Have not seen Victoria! Seems like they don't have a cloud offering though?
- nvartolomei 3y ago
  They do have a "managed" offering (on AWS): https://victoriametrics.com/products/managed/ https://victoriametrics.com/products/managed/.
  - podoman 3y ago
    Very cool. My mistake for overlooking that. Victoria metrics seems more like a metrics store? Something comparable to influx? Is that right?
    - hagen1778 3y ago
      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.html#data-model-differences https://docs.victoriametrics.com/guides/migrate-from-influx.... Disclaimer: I'm one of the VictoriaMetrics maintainers.
vadman97 3y ago
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.
- liketochill 3y ago
  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.
mekster 3y ago
Does it work well to store logs? I thought it's great for metrics.
potamic 3y ago
Clickhouse has been around for longer and battle tested at Yandex. In what cases might VictoriaMetrics be a better fit?
hodgesrm 3y ago
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 https://www.youtube.com/watch?v=sCrdp8hIhJM Disclaimer: I work for Altinity.

podoman 3y ago

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

nvartolomei 3y ago
They do have a "managed" offering (on AWS): https://victoriametrics.com/products/managed/ https://victoriametrics.com/products/managed/.
- podoman 3y ago
  Very cool. My mistake for overlooking that. Victoria metrics seems more like a metrics store? Something comparable to influx? Is that right?
  - hagen1778 3y ago
    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.html#data-model-differences https://docs.victoriametrics.com/guides/migrate-from-influx.... Disclaimer: I'm one of the VictoriaMetrics maintainers.

vadman97 3y ago

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.

liketochill 3y ago
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.

mekster 3y ago

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

potamic 3y ago

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

hodgesrm 3y ago

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 https://www.youtube.com/watch?v=sCrdp8hIhJM Disclaimer: I work for Altinity.