Solved

SFLOW recorder

Posted on 2014-12-21
2
60 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 63

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
fabric 1 31
Internet options/Settings 1 43
creating SVI on layer 3 switch 1 15
windows server 2012 R2 DHCP clustering ? 5 16
How to set-up an On Demand, IPSec, Site to SIte, VPN from a Draytek Vigor Router to a Cyberoam UTM Appliance. A concise guide to the settings required on both devices
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…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

791 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