NagiosXI remote mysql upgrade

[mejokj]

Hello,

Currently our mysql database for the nagiosxi is the below version's, The database is remote mysql. So we need to update the remote mysql database and its OS. kindly recommend is there any impact on doing this upgrade on mysql and OS. Also please suggest the versions which we need to update and steps.

Server version: 5.5.65-MariaDB MariaDB Server
OS: centos 7.7
Nagiosxi: 5.6.X

[benjaminsmith]

Hi @mejokj,

Nagios XI will support any version below 10.x. My CentOS test server is running 5.5.65, and that is the latest provided by the distribution (just did a yum update and went from 5.5.64 to 5.5.65).

If you do plan to upgrade to this version, be sure to take a full backup, this will include the local and remote databases.
Backing Up and Restoring Your Nagios XI System

I would recommend using the package manager to handle the upgrade. It's a pretty simple process (see below).

It's also worth mentioning that as of 5.7.5 STRICT_TRANS_TABLES mode is enabled by default. This should be disabled and we have a knowledgebase article on how to do this.

Nagios XI - STRICT_TRANS_TABLES

I hope that helps and let me know if you have more questions.

Reference:
Chapter 3 Upgrading MySQL with the MySQL Yum Repository