New install - is Innodb the proper path yet?

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
SteveBeauchemin
Posts: 524
Joined: Mon Oct 14, 2013 7:19 pm

New install - is Innodb the proper path yet?

Post by SteveBeauchemin »

I need to setup 3 new Nagios XI servers. I have been hearing Innodb spoken about for a long time.

So, are we there yet? Should I invest the sweat equity to make this work for me?

Or, is it too soon. Will a new version of Nagios XI down the road handle this for me.

Please advise.

Thanks

Steve B
XI 5.7.3 / Core 4.4.6 / NagVis 1.9.8 / LiveStatus 1.5.0p11 / RRDCached 1.7.0 / Redis 3.2.8 /
SNMPTT / Gearman 0.33-7 / Mod_Gearman 3.0.7 / NLS 2.0.8 / NNA 2.3.1 /
NSClient 0.5.0 / NRPE Solaris 3.2.1 Linux 3.2.1 HPUX 3.2.1
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: New install - is Innodb the proper path yet?

Post by scottwilkerson »

To the best of my knowledge, XI is going innodb just for the nagiosxi database in 5.5.0 which is slated to be out withing a few months.

All the rest of the DB's are staying MYISAM
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
SteveBeauchemin
Posts: 524
Joined: Mon Oct 14, 2013 7:19 pm

Re: New install - is Innodb the proper path yet?

Post by SteveBeauchemin »

Thank you Scott.

One last question... For my new servers, can I install Mariadb 10.2 instead of using the Mariadb 5.5 that Red Hat defaults to. Will I regret this?

Thanks

Steve B
XI 5.7.3 / Core 4.4.6 / NagVis 1.9.8 / LiveStatus 1.5.0p11 / RRDCached 1.7.0 / Redis 3.2.8 /
SNMPTT / Gearman 0.33-7 / Mod_Gearman 3.0.7 / NLS 2.0.8 / NNA 2.3.1 /
NSClient 0.5.0 / NRPE Solaris 3.2.1 Linux 3.2.1 HPUX 3.2.1
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: New install - is Innodb the proper path yet?

Post by scottwilkerson »

I can't honestly say because we haven't tested it.

My guess it is will work fine, but I do not know the changes made between 5.5 to 10.2, and have no idea of the ramifications. If you are going to do this I would highly suggest doing it on a testing environment first.
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
SteveBeauchemin
Posts: 524
Joined: Mon Oct 14, 2013 7:19 pm

Re: New install - is Innodb the proper path yet?

Post by SteveBeauchemin »

Thank you Scott.

That is a 'No' for me. I'll stick with the Mariadb 5.5 / Mysql 5.5 instead of trying the Mariadb 10.2 / Mysql 5.7

Steve B
XI 5.7.3 / Core 4.4.6 / NagVis 1.9.8 / LiveStatus 1.5.0p11 / RRDCached 1.7.0 / Redis 3.2.8 /
SNMPTT / Gearman 0.33-7 / Mod_Gearman 3.0.7 / NLS 2.0.8 / NNA 2.3.1 /
NSClient 0.5.0 / NRPE Solaris 3.2.1 Linux 3.2.1 HPUX 3.2.1
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: New install - is Innodb the proper path yet?

Post by scottwilkerson »

SteveBeauchemin wrote:Thank you Scott.

That is a 'No' for me. I'll stick with the Mariadb 5.5 / Mysql 5.5 instead of trying the Mariadb 10.2 / Mysql 5.7

Steve B
Sounds goo locking up thread
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Locked