Hi
Can you suggest why should or Should not I Offload Mysql for Performance of Nagios XI . Any Performance Data and Statistics available for for justification of Offloading Mysql to Seperate server
Can you give me some link / information as justification to increase performance in case of Offloaded Mysql for Large environment .
Practically I need a Justification Document and Data for Offloading Mysql for Performance issue .
Thanks
Mysql Offloading for Nagios XI
-
benjaminsmith
- Posts: 5324
- Joined: Wed Aug 22, 2018 4:39 pm
- Location: saint paul
Re: Mysql Offloading for Nagios XI
Hello @biswajit.banerjee,
In short, the reason for offloading the database is that it can reduce CPU / Memory resources on the XI Server. However, it also introduces additional resources required to transmit data/back and forth over the network. It depends on the network setup ( best to use a dedicated NIC and implement Jumbo frames for the most benefit). Unfortunately, we don't have published data and improvements. We've seen customers offload the database and move it back again locally. I would recommend taking other steps to improve performance before offloading the database.
Maximizing Performance in Nagios XI
Let us know if you have any further questions.
In short, the reason for offloading the database is that it can reduce CPU / Memory resources on the XI Server. However, it also introduces additional resources required to transmit data/back and forth over the network. It depends on the network setup ( best to use a dedicated NIC and implement Jumbo frames for the most benefit). Unfortunately, we don't have published data and improvements. We've seen customers offload the database and move it back again locally. I would recommend taking other steps to improve performance before offloading the database.
Maximizing Performance in Nagios XI
Let us know if you have any further questions.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Be sure to check out our Knowledgebase for helpful articles and solutions!
-
biswajit.banerjee
- Posts: 152
- Joined: Fri Dec 08, 2017 10:24 pm
Re: Mysql Offloading for Nagios XI
Thanks
You inputs are appreciated
You inputs are appreciated
-
scottwilkerson
- DevOps Engineer
- Posts: 19396
- Joined: Tue Nov 15, 2011 3:11 pm
- Location: Nagios Enterprises
- Contact:
Re: Mysql Offloading for Nagios XI
Great!biswajit.banerjee wrote:Thanks
You inputs are appreciated
Locking thread