Forum Discussion

Ravi_Rajan_1101's avatar
Ravi_Rajan_1101
Icon for Nimbostratus rankNimbostratus
Aug 11, 2005

Logging the Real time Information in Database

In Big v9, I can get the number connections on each server only on a real time basis. Can I do something to log this data in a database so that I can pull out a report from it? (Like, I want to see the number of connections being served by each server over a period of one month)

 

 

  • Colin_Walker_12's avatar
    Colin_Walker_12
    Historic F5 Account
    Ravi,

     

     

    This information is already stored in the statistics page of your admin web interface. If you navigate to the Statistics page (Overview -> Statistics), you can select which way you'd like to view the stats on the BigIP. Choosing the "Pools" option should allow you to see how many connections have been made to each server in each pool.

     

     

    This information is aggregate, and can be manually reset with the button at the bottom of that same page, or via the CLI with the bigpipe command.

     

     

    As for writing this information to a database with an iRule, this is not something that we currently offer. You could certainly achieve this by logging something unique to your log file when each connection is received, and having another script parse that information and log it historically any way you choose.

     

     

    The option I'd recommend varies based on your needs. Using the built in stats page is certainly easiest, since it's already there.

     

     

    Hopefully this helps. Be sure to let me know if you have further questions.

     

     

    -Colin
  • As of right now your only option is to build a iControl application to pull whatever statistics you wish off the device and log them in a database of your choosing. This offers the most flexibility as you can pick exactly the polling interval and the specific data items you wish.

     

     

    There are examples in the SDK on pulling down Virtual Server statistics. We provide the interfaces to get every stat on the box though so no matter what you want you should be able to dig it out with iControl.

     

     

    In a future release we are going to provide the ability to create user-defined statistics and integration with the performance graphs but I don't have a release date on that feature yet. When that happens though, you'll be able to tie into the System's Performance Graphs and have BIG-IP keep a history for you. Again, since the specs for this aren't complete yet, the extensibility of this may change at release time.

     

     

    -Joe
  • Posted By Joe on 8/11/2005 9:35:34 AM

     

     

    As of right now your only option is to build a iControl application to pull whatever statistics you wish off the device and log them in a database of your choosing. This offers the most flexibility as you can pick exactly the polling interval and the specific data items you wish.

     

     

    There are examples in the SDK on pulling down Virtual Server statistics. We provide the interfaces to get every stat on the box though so no matter what you want you should be able to dig it out with iControl.

     

     

    In a future release we are going to provide the ability to create user-defined statistics and integration with the performance graphs but I don't have a release date on that feature yet. When that happens though, you'll be able to tie into the System's Performance Graphs and have BIG-IP keep a history for you. Again, since the specs for this aren't complete yet, the extensibility of this may change at release time.

     

     

    -Joe

     

     

    There is another option... using SNMP to pull the information. e.g. with Cricket or similiar and use RRD's via rrdtool to hold & graph the stats.

     

     

    H