Migrating Nagios Database to Azure ( MyISAM to INNODB )

[rajsshah86]

Hi all
I have a query regarding migrating the nagios database to a separate MYSQL server in azure . Below are the details
- Server A: Nagios XI on linux redhat 7 ( including its default MARIADB database )

MY aim : to migrate this database on AZURE MYSQL server B . NAGIOS frontend will remain on Server A

I followed the approach mentioned here : https://assets.nagios.com/downloads/nag ... Server.pdf

The only issue that I noticed is that : NAgios XI uses 3 database ( nagiossql , nagiosxi , nagios ) . 2 of them ( nagiosxi and nagiossql are having INNODB as engine ) and nagios is having MyISAM DB engine .

MY AZURE SQL only supports INNODB , therefore while importing the nagios database instance I got the error . The remaining 2 database were imported successfully .
When I changed the ENGINE parameter on the SQL dump file for nagios to INNODB , it was also imported successfully . Although on HIGH level I see that everything is running . But I am not sure if this is the correct way . So my question is is it ok it I run nagios db instance as INNODB rather then MyISAM ??? will it have impact in any way ??

[lmiltchev]

So my question is is it ok it I run nagios db instance as INNODB rather then MyISAM ??? will it have impact in any way ??

This hasn't been tested, so we cannot guarantee a "problem-free" XI instance. According to our developers, this should work but it might be a bit slower than normal.

Having said that, I would highly recommend that you try it in a test environment first, prior to applying it to production.

With each XI license, you are entitled to a production, a test, and a backup server.

https://support.nagios.com/kb/article/n ... s-145.html