combine multiple zabbix DBs into one

[kwd2]

Hi all,
first post, long time computer science guy, but a rookie to Zabbix. My org has serveral 10's of zabbix servers running and I have been asked to find a way to aggregate all of the information onto a single server.

Is that possible? ie if one had 2 zabbix servers running, is there a way to aggregate these together into a single zabbix server?

thansk
Ken

[allexpetrov]

Hi all,
first post, long time computer science guy, but a rookie to Zabbix. My org has serveral 10's of zabbix servers running and I have been asked to find a way to aggregate all of the information onto a single server.

Is that possible? ie if one had 2 zabbix servers running, is there a way to aggregate these together into a single zabbix server?

thansk
Ken

Hi kwd2,
I'm afraid that you actually can't, because you could mess with the items,hosts, groups, templates and values. I'm pretty sure that you can find similar host id or values with the same timestamp in those DBs.

Also, why you are using the 10's of servers instead of one(or in High Availability mode - two) server with 10's of proxies ? Then you will have only one database, but in such case it is better to have partitioning enabled.

Regards,
Alex!

[bbrendon]

I have been asked to find a way to aggregate all of the information onto a single server.

Is that possible?

It would definitely be a bit of work but you could write a script to do it.

[kwd2]

Hi,
the setup is 10's of servers because each one is a standalone cloud node that has to be configured for stand alone operation. All of the zabbix DBs are identical and we have we have many nodes up and running for various ends.

I hoping that since everything is stored in the db that it would be straightforward to combine instances.
thanks
Ken