search

Icinga / icinga2

The core of our monitoring platform with a powerful configuration language and REST API.
https://icinga.com/docs/icinga2/latest
GNU General Public License v2.0
1.98k stars 571 forks source link

Add Support for TimeScaleDB #8816

Open jgrammen-agilitypr opened 3 years ago

jgrammen-agilitypr commented 3 years ago

Is your feature request related to a problem? Please describe.

icinga2 supports influxdb for its timeseries data (performance metrics), but it would be nice if it supported timescaleDB. The reason for the request is that timescaleDB appears to be the only opensource tsdb (time series db) that supports HA. and since Icinga2 supports HA via master _> master, it would be nice if the timeseries data could also be HA

timescale DB is based on postgresql

Describe the solution you'd like

Add a "feature" to icinga2 to enable timescaleDB to be a destination for performance metrics

Describe alternatives you've considered

influxDB only supports HA in the enterprise (paid) version.

Additional context

Add any other context or screenshots about the feature request here.

Darkentik commented 1 year ago

Hey, as we run into the problem, that our fresh installed and configured influxdb2 (2.6.1) lost all time series data after reboot. We are shocked after this loss of data, because we consider the docs for configuration and there we found no mistake. The www search is very frustrating for this topic, because we are not the only ones with this problem and there aren't quit good docs for this setup.

So it would be cool if we would have a writer for timescaledb. It is often said as the better alternative to influxdb2. Pros are sql syntax and no new flux and the better ram handling.

jamessewell commented 2 months ago

Hello! Has anyone tried the PostgreSQL connector? If you can create the hypertables up front (I'm not sure if this is possible with icinga?) then everything should just work in TimescaleDB