• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 77
  • Last Modified:

SFLOW recorder

I just want to record all sflow logs into a mysql table is there any program like this ?

we have wrote one with perl but there are too many rows so we could not succeded
1 Solution
btanExec ConsultantCommented:
May want to check out the below tools. but as precaution, the massive collection will not be scalable with MySQL as it is storage-intensive and incredibly slow to access. Nonetheless, it is viable and in storing maybe instead of updating bulk huge records dump into MySQL, maybe consider avoiding SQL UPDATEs as much as possible and use only INSERTs. And have regime to keep the SQL schema lean to include only required fields, strip off all the others. It may fare better.

(quite updated as latest is as of Aug 14, also it has a "Careful SQL support") pmacct is a small set of passive network monitoring tools to measure, account, classify, aggregate and export IPv4 and IPv6 traffic. http://www.pmacct.net/

Scrutinizer is another (commercial) tool that should be already using mysql. May have to check further and it has a Scrutinizer Free Edition (supports unlimited interfaces on up to 5 routers. Stores data for 24 hours). https://www.plixer.com/Scrutinizer-Netflow-Sflow/distributed-flow-collectors.html

sflowtool or ntop as collector and dumping to db

FYI, here is an article on "A Survey of Network Traffic Monitoring and Analysis Tools" which is also good to check out with its comparison and feedbacks http://www.cs.wustl.edu/~jain/cse567-06/ftp/net_traffic_monitors3/index.html
FireBallITAuthor Commented:
Thank you
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

We Need Your Input!

WatchGuard is currently running a beta program for our new macOS Host Sensor for our Threat Detection and Response service. We're looking for more macOS users to help provide insight and feedback to help us make the product even better. Please sign up for our beta program today!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now