You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

We are using PingER and PlanetLab landmarks for geolocation in TULIP. PlanetLab landmarks are manually updated with the help of perl script "insert_planetlab.pl" which is under tulip directory /afs/slac.stanford.edu/package/pinger/tulip. This scripts loops over monthly active hosts in PlanetLab and inserts new one based on thier availability.PingER nodes are updated with the help of  automated script "create_sites-xml"(updated by trscrontab job running in pinger@pinger.slac.stanford.edu)  which is located under TULIP directory.

There is also another process to update the landmarks manually. To do that first we need to skim through the schema of  landmarks table of Tulip database

 +----------------------+--------------+------+-----+---------------------+-------+
| Field                | Type         | Null | Key | Default             | Extra |
+----------------------+--------------+------+-----+---------------------+-------+
| nodeID               | int(11)      |      |     | 0                   |       |
| name                 | varchar(80)  |      |     |                     |       |
| hostName             | varchar(80)  | YES  |     | NULL                |       |
| ipv4Addr             | varchar(15)  | YES  |     | NULL                |       |
| domain               | varchar(80)  | YES  |     | NULL                |       |
| description          | varchar(200) | YES  |     | NULL                |       |
| pingerNickname       | varchar(50)  | YES  |     | NULL                |       |
| pingerMonitor        | tinyint(1)   | YES  |     | NULL                |       |
| pingerBeacon         | tinyint(1)   | YES  |     | NULL                |       |
| notCheckedAtSlac     | tinyint(1)   | YES  |     | NULL                |       |
| enabled              | tinyint(1)   | YES  |     | 1                   |       |
| institution          | varchar(100) | YES  |     | NULL                |       |
| city                 | varchar(100) | YES  |     | NULL                |       |
| state                | varchar(100) | YES  |     | NULL                |       |
| country              | varchar(100) | YES  |     | NULL                |       |
| continent            | varchar(100) | YES  |     | NULL                |       |
| latitude             | float        | YES  |     | NULL                |       |
| longitude            | float        | YES  |     | NULL                |       |
| serviceInterfaceType | varchar(30)  | YES  |     | NULL                |       |
| planetLabScript      | varchar(120) | YES  |     | NULL                |       |
| pingURL              | varchar(120) | YES  |     | NULL                |       |
| tracerouteURL        | varchar(120) | YES  |     | NULL                |       |
| pingPacketSize       | int(11)      | YES  |     | NULL                |       |
| tulipScalingFactor   | smallint(6)  | YES  |     | NULL                |       |
| tulipTier            | smallint(6)  | YES  |     | NULL                |       |
| lastUpdateDate       | timestamp    | YES  |     | 0000-00-00 00:00:00 |       |
| comments             | text         | YES  |     | NULL                |       |
+----------------------+--------------+------+-----+---------------------+-------+

  • No labels