Issues with 5.5.0 and offloading MySQL database

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
rajasegar
Posts: 1018
Joined: Sun Mar 30, 2014 10:49 pm

Re: Issues with 5.5.0 and offloading MySQL database

Post by rajasegar »

hbouma wrote:Thank you. That answers my questions about the uninstall script.

Just waiting for the updated documents regarding offloading the database to a separate server. Thanks!
Offloading is not a magic pill for performance issues.
I had to move it back to address a serious problem with scheduling totally screwing up.

FYI
https://support.nagios.com/forum/viewto ... 16&t=48089
Creating ram drives and rrdcached is a far better choice at addressing performance issues from my experience.
5 x Nagios 5.6.9 Enterprise Edition
RHEL 6 & 7
rrdcached & ramdisk optimisation
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Issues with 5.5.0 and offloading MySQL database

Post by scottwilkerson »

rajasegar wrote:
hbouma wrote:Thank you. That answers my questions about the uninstall script.

Just waiting for the updated documents regarding offloading the database to a separate server. Thanks!
Offloading is not a magic pill for performance issues.
I had to move it back to address a serious problem with scheduling totally screwing up.

FYI
https://support.nagios.com/forum/viewto ... 16&t=48089
Creating ram drives and rrdcached is a far better choice at addressing performance issues from my experience.
I would agree with this.
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
hbouma
Posts: 483
Joined: Tue Feb 27, 2018 9:31 am

Re: Issues with 5.5.0 and offloading MySQL database

Post by hbouma »

scottwilkerson wrote:
rajasegar wrote:
hbouma wrote:Thank you. That answers my questions about the uninstall script.

Just waiting for the updated documents regarding offloading the database to a separate server. Thanks!
Offloading is not a magic pill for performance issues.
I had to move it back to address a serious problem with scheduling totally screwing up.

FYI
https://support.nagios.com/forum/viewto ... 16&t=48089
Creating ram drives and rrdcached is a far better choice at addressing performance issues from my experience.
I would agree with this.
Thank you both for the input. The offloading of the Database was not made for performance reasons, but instead was a requirement we were given in order to use Nagios in our environment. RAMDisk is already in place and rrdcached is being implemented. We just need to make sure we implement the separation properly prior to our go live.
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Issues with 5.5.0 and offloading MySQL database

Post by scottwilkerson »

sounds good
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Locked