Nagios 3 - Migration to mysql

[Andrew Davis]

Plus, for what its worth, on most systems these days you can move an HD 
to another system with more CPU/RAM which would negate the muck up all 
the Nagios stuff.

Virtualization is an alternative as well. We run Nagios and Cacti on one 
server and four instances of Splunk on four other servers. Last month, 
we used VMWare's P2V tool to make all five physical servers virtual, 
then moved them to a a Sun X4100 running ESXi. The only cost was the 
server. The overall load of each individual virtual server is under 50% 
and the ESXi box itself is sitting at only 30% load.

If disk space is an issue, another alternative is to clone the HD(s), 
then perhaps move to another server (in the case of going to IDE or SATA 
to SAS or SCSI, this is likely a must).

  A. Davis
  Email:     nccomp at gmail.com

  "There is no limit to what a man can accomplish
   if he doesn't care who gets the credit." - Ronald Reagan



Marc Powell wrote:
> On May 14, 2009, at 8:10 AM, Harald Böhmecke wrote:
>
>   
>> Hi,
>>
>> I have a productive Nagios instance with 200 clients and 1200  
>> Services.
>>
>> PNP4Nagios is also installed and working.
>>
>> Actually everything is working just fine, except the machine has a  
>> 75-100% CPU Load, although I have already tweaked around the settings.
>>     
>
> 75-100% cpu load isn't necessarily bad. What's the load average and  
> specs for the box? What do you see in top using the CPU the most/most  
> often? With 1200 services and assuming checks every 5 minutes, any  
> machine in the last decade should be able to handle that. Are you sure  
> it's nagios that's the problem?
>
>   
>> I want Nagios to have a mysql backend on another server so that the  
>> CPU Load decreases as other (also critical) services are currently  
>> running on this machine, which are starting to show errors.
>>     
>
> This won't help since nagios doesn't use a mysql backend. If you add  
> NDOUtils to do this, it's only adding processing, not replacing any  
> processing.
>
>   
>> - How do I migrate the existing performance data to the mysql  
>> database (I have very little knowledge of databases)
>>     
>
> You'd have to dump all the RRD databases (man rrddump), munge that  
> data and insert it into the DB. It won't help though because of (3)  
> below...
>
>   
>> - What is the command to send the performance data to the mysql  
>> database
>>     
>
> This is complex and beyond the scope of this list. It's also pretty  
> much unrelated to nagios. It won't help though because...
>
>   
>> - PNP4Nagios: How do I tell PNP4Nagios to pull its performance data  
>> from the mysql database
>>     
>
> PNP4Nagios doesn't appear to support storing or reading performance  
> data from a database.
>
> --
> Marc
>
>
> ------------------------------------------------------------------------------
> The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
> production scanning environment may not be a perfect world - but thanks to
> Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
> Series Scanner you'll get full speed at 300 dpi even with all image 
> processing features enabled. http://p.sf.net/sfu/kodak-com
> _______________________________________________
> Nagios-users mailing list
> Nagios-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
> ::: Messages without supporting info will risk being sent to /dev/null
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20090514/165ecfde/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image 
processing features enabled. http://p.sf.net/sfu/kodak-com
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null