Page 1 of 1
Nagios XI 5 - MySQL Version
Posted: Tue Aug 02, 2016 4:42 pm
by maxiz1987
Hi All,
I have a question that I wanted to ask - Which is the version of MySQL in Nagios XI 5?
Because I have ran the following query and I got:
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.1.73 |
+-----------+
Is the version 5.1 ? This version is really old and deprecated and I am not sure if this is correct.
Can anyone help me with this?
Regards,
Re: Nagios XI 5 - MySQL Version
Posted: Tue Aug 02, 2016 4:45 pm
by Box293
It's whatever version your OS repository provides.
Re: Nagios XI 5 - MySQL Version
Posted: Tue Aug 02, 2016 4:47 pm
by mcapra
My recent XI 5.2.9 install is using the same version:
Code: Select all
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.1.73 |
+-----------+
Strictly speaking, which MySQL version you can use is only limited by what your PHP environment supports (through mysqli or similar connectors).
Re: Nagios XI 5 - MySQL Version
Posted: Wed Aug 03, 2016 9:53 am
by maxiz1987
But do you know if I use MySQL 5.6 or 5.7 if it is supported by Nagios ?
I wanted to do an offload of the DB running the Nagios and the DB both on different RHEL 7 Machines.
Re: Nagios XI 5 - MySQL Version
Posted: Wed Aug 03, 2016 10:01 am
by mcapra
maxiz1987 wrote:But do you know if I use MySQL 5.6 or 5.7 if it is supported by Nagios ?
Strictly speaking it's more an issue with your PHP environment than it is with Nagios. If you're running a clean XI system or deployed from the OVA, your installation should be able to handle MySQL 5.6 without issues. Just be sure to snapshot/backup prior to transitioning.
Re: Nagios XI 5 - MySQL Version
Posted: Mon Sep 12, 2016 5:05 pm
by maxiz1987
Hi Guys - This thread could be closed.
Thanks for your assistance.
Regards,