A first step to merge Cacti Installations (Part 1)

It is not the first time, that this questions arises. Nowadays, there are lots of command line scripts, but nothing readily available for merging. But what the hell is the big issue, why this is not possible yet?

To answer this question, we have to leave the web administration view and turn to the database layout. This can be done the hard way by using mysql from command line. Or instead, use phpMyAdmin. When examining any table, you’ll find a column named „id“, which uniquely identifies any entry. This is a known good practice for relational databases. In most cases, the „id“ is created automatically, each time a new record is inserted. This is known as auto-increment.

To join several tables, Cacti uses these „id“ fields. They are unique for a single Cacti installation. If you add e.g. some graph template on one Cacti installation, distinct „id“s will be provided. Joining the same template on a different installation will usually create a different set of „id“s. E.g. a specific graph template may have id=42 on one installation and id=21 on another one.

By simply inserting all records of a Cacti installation into a different one, this will break the whole database.

Stay tuned to find a way to overcome this problem.