How does NetMRG stores it's data?

rkogels

23-12-2003 06:10:28

Hi all,

Does netMRG store the retrieved SNMP data in an SQL db? Eg, are the internal RRDTool databases not used?

Thanks,
Rene

silfreed

23-12-2003 12:03:31

We store all gathered data in RRD files that RRDTOOL produces. We do store the last gathered value in the database, which we've found useful for hooking NetMRG to other programs. Anything specific you're trying to accomplish?

-Doug

rkogels

23-12-2003 15:37:01

Hi Doug,

Thanks for your answer. I wondered if all the SNMP data was stored in an SQL db so you could run some queries on it, like finding out when you had some peak values etc. This is a bit more problematic when you try to get it out od the RRD db.

Rene

silfreed

23-12-2003 15:44:41

Yes, it does make it more difficult in cases where you want to do what you're suggesting; but it does make it much nicer for us since we don't have to maintain the round robin database ourselves (and generate the graphs - *shudder*). It sounds like you've dealt with this in the past, so you probably already know about RRDTool's 'fetch' command - if not, that's the place to look.

-Doug

rkogels

23-12-2003 16:06:13

What is this "event" feature of netMRG? Does it send out events when some values are seen in the RRD db? So no use of the SQL db as you mentioned before?

Rene

silfreed

23-12-2003 16:22:51

The 'event' feature allows NetMRG take an action when some condition is met. For example, say when your router CPU hits 90% you'd like to page someone. This would require you to setup a 'Notification' to have someone paged. It just uses the last value it saved in the SQL table and compares it to the current value it just got.
The only value we store in the database is the last captured value (and the rate of change for Counters). This allows us to do simple comparisons like above.

-Doug

wulff

31-03-2005 15:43:12

as a continuation of the origional question, I am curious... how different would the data being stored by netmrg into RRD be that what mrtg-rrd creates in its rrd files?

The reason I am asking is because we are putting together OPNet's VNE Server and SPGuru on our network, and one of the items they request to make things "optimal" is flows, and while they support common things like CiscoWorks, etc, they also support MRTG, in normal or RRD format. My problem is probably the same as anyone using netmrg or any of the other "better" open source monitoring tools, MRTG is a bear. I quit using it almost 2-3 years ago. I have been using Zabbix, and I think in long term, its going to be a wonderful application, but I believe for my current needs that netmrg is much better solution.


on a side note, silfreed, can you send me an im or e-mail if you get a chance, I was curious about comparing notes on a few development things as an ISP (i looked over your resume). I'm the xaethios that IM'd you while you were away.


thanks

wulff

balleman

31-03-2005 22:20:05

With respect to RRD files, NetMRG and MRTG-RRD would use different names for the data sources stored in the RRDs, would likely have different geometries (more or less data points over each time period), and may have a different number of data sources per file. If the app your using supports 'generic' RRDs, then you should be fine, but if it depends on MRTG-RRD's particular use of RRDs, you'll have to do some (ok, probably lots) of conversion by dumping RRDs, mangling them, and restoring them into other RRDs.

wulff

01-04-2005 10:04:12

that is what I was afraid of... but i think I'm going to approach them with the concept that if they can import RRD files, they should make the import definable.


thanks

billn

12-04-2005 18:51:55

[quote9d16e188e2="rkogels"]Hi Doug,

Thanks for your answer. I wondered if all the SNMP data was stored in an SQL db so you could run some queries on it, like finding out when you had some peak values etc. This is a bit more problematic when you try to get it out od the RRD db.

Rene[/quote9d16e188e2]

I'm currently testing a small patch to the netmrg-collector that will insert raw collection into mysql alongside the rrd updates. I have a requirement for multiple pollers in disparate locations feeding the same front end, so this is the first step toward that solution. It require another local process on the front end to update the rrd's locally, but we'll see how it shakes out.

silfreed

12-04-2005 21:10:46

The last value is already inserted into the database along with getting updated in the .rrd files.

-Doug

marcioq

20-04-2005 17:15:33

Hi,

just one quick question. When you say the netmrg store the last value it is the "delta_val" on the monitors table ? it is diference between the current reading ("last_val" on monitors table) and the Last ? Could i use it to monitor if the traffic is to high ?

Thank´s

silfreed

20-04-2005 21:11:58

Yep.

-Doug