Peering Matcher

A small tool to quickly find what IXPs a given set of Autonomous Systems
have in common according to PeeringDB. As arguments you can supply 1 or more ASNs,
and it will show you only the IXPs where all ASNs intersect.
alice:peering job$ ./peeringmatcher.py 
Peering Matcher 0.1
usage: peeringmatcher.py ASN1 [ ASN2 ] [ ASN3 ] [ etc.. ]
    example: ./peeringmatcher.py 5580 16509
    In case a single ASN is given as an argument, the program will match
    against the default_asn in the code.
    Written by Job Snijders <job.snijders@atrato-ip.com>.
    Many thanks to http://peeringdb.net
alice:peering job$ 

Download & install

Code: peeringmatcher at github.com

Prerequisites: python, mysql-python, prettytable, ipaddr

Examples

alice:peering job$ ./peeringmatcher.py 2906
Common IXPs according to PeeringDB.net - time of generation: 2012-10-17 09:59:21
+-----------------------------+-------------------------+-----------------------------+
|             IXP             |     AS2906 - Netflix    | AS5580 - Atrato IP Networks |
+-----------------------------+-------------------------+-----------------------------+
|       Equinix Ashburn       |     206.223.115.238     |       206.223.115.204       |
|                             |   2001:504:0:2::2906:1  |     2001:504:0:2::5580:1    |
+-----------------------------+-------------------------+-----------------------------+
|       LINX Juniper LAN      |      195.66.225.101     |      2001:7f8:4::15cc:1     |
|                             |       195.66.224.6      |        195.66.225.111       |
|                             |    2001:7f8:4::b5a:1    |                             |
|                             |    2001:7f8:4::b5a:2    |                             |
+-----------------------------+-------------------------+-----------------------------+
|       NetNod Stockholm      |    2001:7f8:d:ff::43    |        194.68.123.199       |
|                             |      194.68.123.43      |        195.69.119.199       |
|                             |    2001:7f8:d:fe::43    |      2001:7f8:d:fc::199     |
|                             |      194.68.128.43      |       195.245.240.199       |
|                             |                         |        194.68.128.199       |
|                             |                         |      2001:7f8:d:fb::199     |
|                             |                         |      2001:7f8:d:fe::199     |
|                             |                         |      2001:7f8:d:ff::199     |
+-----------------------------+-------------------------+-----------------------------+
|       Equinix Chicago       |     206.223.119.156     |        206.223.119.45       |
|                             |   2001:504:0:4::2906:1  |     2001:504:0:4::5580:1    |
+-----------------------------+-------------------------+-----------------------------+
|       LINX Extreme LAN      |       195.66.236.6      |        195.66.237.111       |
|                             |   2001:7f8:4:1::b5a:2   |     2001:7f8:4:1::15cc:1    |
+-----------------------------+-------------------------+-----------------------------+
|        Telx New York        |     206.126.115.225     |     2001:504:17:115::25     |
|                             |   2001:504:17:115::225  |        206.126.115.25       |
+-----------------------------+-------------------------+-----------------------------+
|            AMS-IX           |      195.69.146.250     |        195.69.144.229       |
|                             | 2001:7f8:1::a500:2906:2 |        195.69.145.229       |
|                             | 2001:7f8:1::a500:2906:1 |   2001:7f8:1::a500:5580:1   |
|                             |      195.69.147.250     |   2001:7f8:1::a500:5580:2   |
+-----------------------------+-------------------------+-----------------------------+
|         Telx Atlanta        |    2001:478:132::113    |        198.32.132.118       |
|                             |      198.32.132.113     |      2001:478:132::118      |
+-----------------------------+-------------------------+-----------------------------+
|            LONAP            |    2001:7f8:17::b5a:1   |     2001:7f8:17::15cc:1     |
|                             |      193.203.5.229      |         193.203.5.98        |
+-----------------------------+-------------------------+-----------------------------+
|       Equinix New York      |    2001:504:f::2906:1   |        198.32.118.114       |
|                             |      198.32.118.176     |        2001:504:f::72       |
+-----------------------------+-------------------------+-----------------------------+
| CoreSite - Any2 Los Angeles |     206.223.143.215     |   2001:504:13:0:0:0:0:212   |
|                             | 2001:504:13:0:0:0:0:215 |       206.223.143.212       |
+-----------------------------+-------------------------+-----------------------------+
|             NOTA            |      198.32.125.71      |        198.32.125.70        |
|                             |    2001:478:124::1071   |       2001:478:124::70      |
+-----------------------------+-------------------------+-----------------------------+
|            NYIIX            |      198.32.160.90      |        198.32.160.39        |
|                             | 2001:504:1::a500:2906:1 |   2001:504:1::a500:5580:1   |
+-----------------------------+-------------------------+-----------------------------+


Alice:peering job$ ./peeringmatcher.py 5580 2906 16509 12859
Common IXPs according to PeeringDB.net - time of generation: 2012-10-17 09:59:21
+------------------+-------------------------+-------------------------+-----------------------------+----------------------+
|       IXP        |     AS2906 - Netflix    |     AS12859 - BIT BV    | AS5580 - Atrato IP Networks | AS16509 - Amazon.com |
+------------------+-------------------------+-------------------------+-----------------------------+----------------------+
| LINX Juniper LAN |      195.66.225.101     |   2001:7f8:4:0::323b:1  |      2001:7f8:4::15cc:1     |    195.66.225.175    |
|                  |       195.66.224.6      |      195.66.225.51      |        195.66.225.111       |                      |
|                  |    2001:7f8:4::b5a:1    |                         |                             |                      |
|                  |    2001:7f8:4::b5a:2    |                         |                             |                      |
+------------------+-------------------------+-------------------------+-----------------------------+----------------------+
| LINX Extreme LAN |       195.66.236.6      |   2001:7f8:4:1::323b:2  |        195.66.237.111       |    195.66.237.175    |
|                  |   2001:7f8:4:1::b5a:2   |      195.66.237.51      |     2001:7f8:4:1::15cc:1    |                      |
+------------------+-------------------------+-------------------------+-----------------------------+----------------------+
|      AMS-IX      |      195.69.146.250     |      195.69.144.35      |        195.69.144.229       |    195.69.146.100    |
|                  | 2001:7f8:1::a500:2906:2 | 2001:7f8:1::a501:2859:1 |        195.69.145.229       |    195.69.146.217    |
|                  | 2001:7f8:1::a500:2906:1 |      195.69.144.200     |   2001:7f8:1::a500:5580:1   |                      |
|                  |      195.69.147.250     | 2001:7f8:1::a501:2859:2 |   2001:7f8:1::a500:5580:2   |                      |
+------------------+-------------------------+-------------------------+-----------------------------+----------------------+
Alice:peering job$