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 >
