Nagios 3 - Migration to mysql

[Marc Powell]

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