Antwort: Nagios 3 - Migration to mysql

[Sascha.Runschke at gfkl.com]

> Actually everything is working just fine, except the machine has a 
> 75-100% CPU Load, although I have already tweaked around the settings.
> 
> 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.
> 
> Question is:
> 
> - How do I migrate the existing performance data to the mysql 
> database (I have very little knowledge of databases)

You can't unless you are already logging performance data into mysql.
Nagios itself does not log performance data at all.

> - What is the command to send the performance data to the mysql database

Use the NDO Utils. Google is your friend.
Otherwise you need to dump the RRD databases of PNP and import
that into mysql with a script - but that script you need to write
yourself I guess.

> - PNP4Nagios: How do I tell PNP4Nagios to pull its performance data 
> from the mysql database

You can't. PNP4Nagios stores its data in RRD databases. There is no
way to push it into a mysql DB and on the other hand, it wouldn't make
sense either for PNP.

> I have found very little information about this, so any help is 
> greatly appreciated.

I guess that's mainly since you misunderstood something. Nagios
naturally doesn't have the need a mysql backend. Nagios does have the
NDO Utils, which store realtime and historical data in a mysql DB, but
that's only for third-party applications that need that data. Mainly
there is nagiosgrapher and nagvis, maybe NagiosBP.

On a sidenote: it's a bad, bad idea to have critical services
running on your monitoring server. Service monitoring is always
stressing the machine when your installation is not exactly small
and you check often.

Conclusions:

- get a bigger server
- get faster storage
- move the other services from your nagios server

Regards
        Sascha



GFKL Financial Services AG
Vorstand: Dr. Peter Jänsch (Vors.), Jürgen Baltes, Dr. Tom Haverkamp
Vorsitzender des Aufsichtsrats: Dr. Georg F. Thoma
Sitz: Limbecker Platz 1, 45127 Essen, Amtsgericht Essen, HRB 13522

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