Nagios Support Forum

Hi,

I already did as the manual suggested and copied the create TABLE from the installation file /tmp/nagiosxi/nagiosxi/nagiosxi-db/nagiosxi_db.sql
Now with the ALTER TABLE you mention and modifying the max_allowed_packet on mysql the import went fine and it seems all is working OK on nagiosxi

Now only remains to decide the plan for do all of this on the Production environment.

After making that work I decided to have a little bit more fun and tried to migrate all the nagios database to a MAriaDB-Galera cluster we have meaning I had to convert all tables from MyISAM to Innodb. I'm just going to say that even though I didn't have any kind of problem doing the migration, the performance afterwards is awful. The home pages takes arround 30 secs to load and trying to access the services section on core config manager takes about 1 minute. I guess could try some performance improvements on the DDBBs but as I'm sure this kind of setup won't be supported by Nagios I'm just going to pass.

Yes on both. There are very likely improvements you can make to speed up a clustered environment and yes that is not in scope of support.

HI,

I was trying to install nagiosxi 2014R1.2 on a fresh centos 7 but apparently is not supported. Is there a workaround for this? My initial idea was migrate my production Nagiosxi that is centos 6 running 2014R1.2 to a new centos 7 server and upgrade then to 5.3.4. If not I guess I have to use the my nagios test server as a middle server for the whole process as I don't want to touch my production environment.

No other than walking through the script and addressing each failure, some of which may be very time intensive.

You can do it from a CentOS 6 system. XI backup/restore procedure is relatively agnostic about OS and OS version, it's more picky about XI version.