Re: Several Questions regarding sFlow Database

From: Neil McKee (neil_mckee@inmon.com)
Date: 11/08/01

  • Next message: Neil McKee: "Well-kept secrets: URL queries"

    aaron wrote:
    >
    > Dear Sir or Madam,
    >
    > I am a trial user of Inmon Traffic Server and have several questions,
    > 1. What kind of built-in database does the Traffic Server support? Does it support an external database?

    The internal database is in a custom binary format, well suited to
    storing this kind of data, and smart about things like subnet masks. It
    uses flat files under the /home/inmon/data directory. The details are
    not published.

    If you wanted to load data into an external database, then you could do
    that using a script (e.g. perl, wget) to extract data in ASCII format
    and then load it into whatever tables you wanted to store there.

    > 2. Can I define the data duration, i.e. how long or certain capacity? How will the system do when the data duration is over my config, replace the old data with new one or directly drop the new data?

    The configuration file allows you to specify:

    KeepActiveMinutes = <minutes>
     (data per interface by minute...Monitor->Traffic and Query->Interface
    Traffic)

    KeepHistoryDays = <days>
     (consolidated hourly history...Query->Site Traffic, Query->Site Service
    and Query->Interface Counters)

    KeepFreeMBytes = <MBytes>
     If the disk fills up, the oldest history data will be deleted
    automatically until KeepFreeMBytes are free.

    For details, see the help page on the configuration file.

    > 3. How do I backup the data? If yes, can I backup data for a specific time frame or certain capacity?

    If you wanted to back the data up, you can back up the contents of
    /home/inmon/data/historyData. Be careful not to use a backup utility
    that locks the filesystem, though. The Traffic Server does not behave
    well under those conditions.

    > 4. How do I delete the old data?
    Happens automatically, see above.

    > Thank you very much in advance for your assistance. I look forward to your reply.

    If you have more questions, please ask.

    regards,
    neil

    -- 
    Neil McKee, InMon Corp.
    tel: +1 (415) 661-6343
    //www.inmon.com
    



    This archive was generated by hypermail 2b29 : 11/08/01 EST