Nagios, MySQL and trending

[Rodger Allen]

Carroll, Jim P [Contractor] wrote:

> Can anyone make any other suggestions?

At our site, I am currently experimenting with having the 
serviceperfdata written to a FIFO, and having a (perl) daemon read from 
this pipe and pop the data into a mysql database.

This is not perfect, given that it adds another point of failure, but 
the current results look good.

We have also added a few patches to some of the core plugins to add some 
perfdata to be returned in a consistent manner.  We chose to use a 
format using the ucd MIB, but we are a little selective in what gets 
returned.  The whole OID is not used, but as the last part should be 
reasonably distinct, it should be okay.

For example, the return for check_swap is like:
Swap ok - Swap used: 32% (81596416 out of 254943232) | 
memAvailSwap=173346816, memTotalSwap=254943232

For "check_disk", we add an instance variable:
dskPath.1=/, dskTotal.1=5148636, dskUsed.1=4674744, dskPercent.1=91%,
dskPath.2=/boot, dskTotal.2=15522, dskUsed.2=1862, dskPercent.2=13%

Doing it this way made it much easier to parse out the performance data, 
instead of having to create a new regex (or whatever) for each $OUTPUT$ 
returned to extract the data.


I can supply some more details, if you are interested.


>>It might interest you to know that database support is being dropped.

Well, there goes the idea of trying to work out how to integrate the 
performance data collection into the nagios core.  :-(



Rodger


-- 
Rodger Allen                           | "te occidere possunt sed
r.allen at awayweb.com                    | te edere non possunt nefas
Mob: +61 402 209 256                   | est" DFW
GPG fingerprint = 958F 256F 5327 D14E 49EA 0681 05E6 2EC3 62E8 793F
Thawte fingerprint = 96:09:A2:3B:67:9F:B4:AE:C8:50:BC:2F:31:00:AB:14
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3501 bytes
Desc: S/MIME Cryptographic Signature
URL: <https://www.monitoring-lists.org/archive/users/attachments/20030102/dd3f75bf/attachment.bin>