Nagios 3 - Migration to mysql

[Harald Böhmecke]

Thank you Marc and Sasha for the feedback. It is now clear to me that no
mysql backend is needed to decrease CPU Load.

Thanks for the tips on PNP4Nagios. 

To answer some of your questions:

- System Load is 3.5 on the 15 min counter.
- System specs:
Its a VM running on a DL585 with 32GB of RAM. 4 Opteron Processors. The
VM is currently 32-bit and is assigned 2 processors and 3,6GB RAM.
We have other low-demainding VMs running on the same machine.
- Top is always Nagios:
 4641 nagios    25   5 21684  10m 2440 S   15  0.3   2688:24 nagios3
15%CPU - 0.3 RAM
- Checks are every 5 mins
- I am certain Nagios is not the main problem, but I am currently
looking into lowering System Load/CPU usage.

The other Services we have currently running on the same machine have
very much to do with monitoring and the idea was to place them all in
one. Bosses love the word "centralized".

Anyway, I got the answers I needed.

Kindest regards to all,

Harald



-----Original Message-----
From: Marc Powell <marc at ena.com>
To: Nagios Users <nagios-users at lists.sourceforge.net>
Subject: Re: [Nagios-users] Nagios 3 - Migration to mysql
Date: Thu, 14 May 2009 09:55:57 -0500


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/e481a120/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