search

LMacPhail / zabbix-history-influxdb

A loadable module for zabbix which will export history data to an InfluxDB repository.
GNU General Public License v2.0
44 stars 15 forks source link

History export-import #12

Open levkar opened 5 years ago

levkar commented 5 years ago

Is there a module/script/documentation for exporting historical data from zabbix db (with tag fields in this module like hosts, groups, applications) and importing it into influxdb?

I believe this will be very useful for those who want to use this module.

myhellone commented 5 years ago

I was just about to ask.... any help?

i-ky commented 5 years ago

How much history do you store in Zabbix database? Typically it's something between a week and a month. I don't think it's worth the effort, you simply start using the module and allow a transition period, after which InfluxDB will store exactly the same amount of data as Zabbix history table.

Exporting trends is a different story and, perhaps, requires a different schema in InfluxDB.

myhellone commented 5 years ago

I need store minimum a 13 months of history... Influx is only for "backups". But now I must check annother options...

i-ky commented 5 years ago

Well, theoretically we can implement this as a Simple check item key. You will execute it once using "Check now" functionality. It will perform a select * from history and then will process these values as if they were real-time data.

levkar commented 5 years ago

We wrote an export SQL for history and trends which is in influxdb format. Once we test we can share if you anyone is interested.

myhellone commented 5 years ago

I can test it :)