Is it possible to save data into two different databases in Influxdb?

Configuration
1

Hi,
I would like to setup Influxdb with 2 dbs each having different retantion policies. I managed to have it working in 1 dB, but I am not sure how to configure HA with 2.

1 Like
2

That’s not supported at the moment.

3

:frowning:

is there a workaround for this?
I have the following writing to the dB:

  - sensor.energy_meter_mains_power
  - sensor.energy_meter_openplan_power
  - sensor.water_heater_watts
  - sensor.hourly_energy_mains
  - sensor.daily_energy_mains
  - sensor.weekly_energy_mains
  - sensor.monthly_energy_mains
  - sensor.hourly_energy_openplan

all with the same retention policy (365 days). I don’t need the first 3 sensors that long, one month would be enough. Is there a way to delete old value? I dont mind doing it manually

4

If you are using node-red, you can use the node red influxdb node ( https://flows.nodered.org/node/node-red-contrib-influxdb ) to save data into different databases. It is very simple.

5

Are you planning to integrate the feature?

6

im not using node-red unfortunately :confused:

7

Since I’m not finding a newer thread: Has anyone considered/tried running a separate database server and setting it up to sync with HA’s database, SQLite, MariaDB, whichever?

1 Like