Network Operations Guide
nanog at daork.net
Sat Sep 8 14:30:42 UTC 2007
On 25/08/2007, at 7:04 AM, Bill Nash wrote:
> On Fri, 24 Aug 2007, Bill Nash wrote:
>> I built a perl daemon using Net::BGP and DBI that inserted and
>> routes, on update, into an SQL db. I could then query to my hearts
>> content, beating up a db with full routes with all the efficiency
>> of SQL.
>> It's simple as hell and works great.
> Just to answer a bunch of off-list mails en masse, no, I do not have a
> copy of this code for distribution. I wrote it originally for an
> ex-employer, so I don't have a copy. I plan on rebuilding it, it's
> simple, so if you have use cases for a tool like this, shoot me an
> off list with your thoughts. Time permitting, I'll rebuild and post. I
> need it for some of my own purposes anyway, might as well make it suck
An alternative that I've been meaning to tinker with for some time
might be to use OpenBGPd/zebra/quagga dumping to a file, and load
that file in to SQL.
I like that a bit more than INSERT/DELETE direct to SQL, because
those dump files are dumps of all BGP messages, as well as table
states, so you can move to any point in time when diagnosing problems.
A quick google reveals http://nms.lcs.mit.edu/software/bgp/bgptools/
- tools that can deal with SQL and MRT dump files.
More information about the NANOG