Matin, Hmm, that might work for what I am looking to do. Thanks for the suggestion. Though, I think (still pondering), for the long term, I would like to see a write out naitively to a db (I think....).
Chris On Wed, 2006-02-22 at 23:30, Martin Knoblauch wrote: > Arjun, > > instead of hacking "gmetad", another option could be to just write a > script/program that queries a running "gmetad" tcp-port and feed the > data from the received XML stream into your DB. That way you could > avoid touching the existing ganglia code alltogether. > > Just for curiosity, how would you use the data in the DB? Any initial > ideas about the table layout? > > Cheers > Martin > > --- Arjun <[EMAIL PROTECTED]> wrote: > > > Martin, > > > > Thanks for the tip. Yes, it seems that the rrd_helpers.c file is > > where I > > will have to start. > > I think that maybe we should have a separate helper file for MySql > > insertion > > (or any DB insertion) > > and have that as a separate option for ganglia. So people will have a > > choice > > of where to store data. > > > > Yes, storing data in a DB will introduce the capacity issue which rrd > > avoided but in my case > > I need the data to be stored in a DB and capacity is not an issue. > > For cases > > where capacity is an issue, > > it should be fairly easy to write a cron-type script for > > truncating/deleting > > data older than a particular date. > > > > I'll keep you updated on my progress in this area. Unfortunately I'm > > new to > > C programming so its slow going. > > Do let me know if you have any further suggestions/ideas/advice. > > > > Thanks and regards > > Arjun > > > > On 2/22/06, Martin Knoblauch <[EMAIL PROTECTED]> wrote: > > > > > > Arjun, > > > > > > only comments I have: > > > > > > - yes pleaase. Having the metrics stored in a "real" DB is > > something I > > > am very interested in. Although this may have some issues like > > > capacity, being able to view/search 1-hour stats over the last year > > > would be great. > > > > > > - modifying "gmetad" seems to be the most likely way. Have a look > > at > > > the stuff provided by the "rrd_helpers.c" source and how its used. > > > > > > Cheers > > > Martin > > > > > > --- Arjun <[EMAIL PROTECTED]> wrote: > > > > > > > Chris, > > > > > > > > Sure thing. Will let you know if I get anything or write > > anything. > > > > Yes, I guess it will be a gmetad modification. > > > > > > > > In my case, I'm not interested in transferring data from RRD to > > mysql > > > > offline but > > > > rather have gmetad write to the MySql DB directly instead of RRD. > > > > > > > > I think there are probably already some tools available for > > > > transferring or > > > > importing data > > > > from RRD to MySql. If I come across any I'll let you know. > > > > > > > > Regards > > > > Arjun > > > > > > > > > > > > On 2/22/06, Chris Croswhite <[EMAIL PROTECTED]> wrote: > > > > > > > > > > it will be part of gmetad, I believe it writes out the data > > into > > > > the rrd > > > > > db's. > > > > > > > > > > As another option, you could script out a dump call on all the > > rrd > > > > db's > > > > > and plug the values into your sql table, but this would give > > you > > > > numbers > > > > > you would have to translate (e.g. map the numbers to what they > > > > > represent). > > > > > > > > > > I am VERY interested in getting the same functionality, so any > > code > > > > or > > > > > information you get, could you please share with me. I will do > > the > > > > > same. > > > > > > > > > > Thanks, > > > > > Chris > > > > > > > > > > On Wed, 2006-02-22 at 10:37, Arjun wrote: > > > > > > Hi Chris, > > > > > > > > > > > > Any ideas on where (in the codebase) I can start ? I don't > > mind > > > > doing > > > > > > the code modifications myself as long as I can get a > > jumpstart. > > > > (I'm a > > > > > > bit pressed for time so I'd rather have an existing solution) > > > > > > > > > > > > regds > > > > > > Arjun > > > > > > > > > > > > On 2/22/06, Chris Croswhite <[EMAIL PROTECTED]> wrote: > > > > > > I am looking to do something like this as well. > > > > > > > > > > > > TIA, > > > > > > Chris > > > > > > > > > > > > On Wed, 2006-02-22 at 10:02, Arjun wrote: > > > > > > > Hi Folks, > > > > > > > > > > > > > > I have a requirement to integrate ganglia to a DB > > such > > > > as > > > > > > MySql so > > > > > > > that gmetad should store retreived data in > > > > > > > MySql instead of an RRD. > > > > > > > > > > > > > > Has anyone already done this and if so can someone > > > > please > > > > > > point me to > > > > > > > the code/docs etc ? > > > > > > > > > > > > > > If it has not been done then can someone guide as > > to > > > > where I > > > > > > should > > > > > > > start modifying code so that gmetad writes > > > > > > > to MySql rather than RRD ? Some detailed insight > > would > > > > be > > > > > > very > > > > > > > welcome. > > > > > > > > > > > > > > Thanks and regards > > > > > > > Arjun > > > > > > > PennState University > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------ > > > Martin Knoblauch > > > email: k n o b i AT knobisoft DOT de > > > www: http://www.knobisoft.de > > > > > > > > ------------------------------------------------------ > Martin Knoblauch > email: k n o b i AT knobisoft DOT de > www: http://www.knobisoft.de > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting language > that extends applications into web and mobile media. Attend the live webcast > and join the prime developer group breaking into this new coding territory! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 > _______________________________________________ > Ganglia-developers mailing list > Ganglia-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ganglia-developers
