?
Solved

SFLOW recorder

Posted on 2014-12-21
2
Medium Priority
?
66 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 64

Accepted Solution

by:
btan earned 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
This program is used to assist in finding and resolving common problems with wireless connections.
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…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
Suggested Courses

743 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