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
FireBallITAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
http://blog.sflow.com/2011/12/sflowtool.html
http://www.ntop.org/solutions/flow-based-monitoring/

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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
FireBallITAuthor Commented:
Thank you
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Network Analysis

From novice to tech pro — start learning today.