Solved

SFLOW recorder

Posted on 2014-12-21
2
55 Views
Last Modified: 2015-04-07
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
0
Comment
Question by:Cahit Eyigunlu
2 Comments
 
LVL 61

Accepted Solution

by:
btan earned 500 total points
ID: 40512931
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
 

Author Closing Comment

by:Cahit Eyigunlu
ID: 40710809
Thank you
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

As companies replace their old PBX phone systems with Unified IP Communications, many are finding out that legacy applications such as fax do not work well with VoIP. Fortunately, Cloud Faxing provides a cost-effective alternative that works over an…
If you're not part of the solution, you're part of the problem.   Tips on how to secure IoT devices, even the dumbest ones, so they can't be used as part of a DDoS botnet.  Use PRTG Network Monitor as one of the building blocks, to detect unusual…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now