-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathstarlight.txt
105 lines (77 loc) · 5.09 KB
/
starlight.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
insert into allsites (am_urn, am_name, longitude, latitude)
values ('', 'EMBL-European Bioinformatics Institute', 0.186, 52.08); -- 317
insert into allsites (am_urn, am_name, longitude, latitude)
values ('', 'CANARIE', -75.69, 45.42); -- 318
insert into allsites (am_urn, am_name, longitude, latitude)
values('', 'NIH', -77.10, 39.00); -- 319
insert into allsites (am_urn, am_name, longitude, latitude)
values('', 'U. Chicago', -87.72, 41.71); -- 320
insert into allsites (am_urn, am_name, longitude, latitude)
values('', 'StarLight', -87.61, 41.895); -- 321
insert into allsites (am_urn, am_name, longitude, latitude)
values('', 'StarLight SDX', -87.61, 41.895); -- 322
create table starlight_node (like lwtesting_stitchtest_node including defaults);
create table starlight_link (like lwtesting_stitchtest_link including defaults);
insert into starlight_node(site_id, name, client_id, zoom_level, status)
values (317, 'EMBL', 'node-embl', 0, 'up'); -- 7
insert into starlight_node(site_id, name, client_id, zoom_level, status)
values (318, 'CANARIE', 'node-canarie', 0, 'up'); -- 8
insert into starlight_node(site_id, name, client_id, zoom_level, status)
values (319, 'NIH', 'node-nih', 0, 'up'); -- 9
insert into starlight_node(site_id, name, client_id, zoom_level, status)
values (320, 'U. Chicago', 'node-uchicago', 0, 'up'); -- 10
insert into starlight_node(site_id, name, client_id, zoom_level, status)
values (321, 'StarLight', 'node-starlight', 0, 'up'); -- 11
insert into starlight_node(site_id, name, client_id, zoom_level, status)
values (322, 'StarLight SDX', 'node-starlight-sdx', 0, 'up'); -- 12
insert into starlight_link(from_id, from_if_name, to_id, to_if_name, status, link_id)
values (7, 'eth1', 12, 'eth1', 'up', 'embl-link');
insert into starlight_link(from_id, from_if_name, to_id, to_if_name, status, link_id)
values (8, 'eth1', 12, 'eth1', 'up', 'canarie-link');
insert into starlight_link(from_id, from_if_name, to_id, to_if_name, status, link_id)
values (9, 'eth1', 12, 'eth1', 'up', 'nih-link');
insert into starlight_link(from_id, from_if_name, to_id, to_if_name, status, link_id)
values (10, 'eth1', 12, 'eth1', 'up', 'uchicagol-link');
insert into starlight_link(from_id, from_if_name, to_id, to_if_name, status, link_id)
values (11, 'eth1', 12, 'eth1', 'up', 'starlight-link');
create table starlight_metrics (id serial primary key, ts integer, thruput_mbps integer);
insert into starlight_metrics (ts, thruput_mbps) values ( 1425682829, 5);
insert into starlight_metrics (ts, thruput_mbps) values (1425682829, 5);
insert into starlight_metrics (ts, thruput_mbps) values (1425682835, 5);
insert into starlight_metrics (ts, thruput_mbps) values (1425682840, 5);
insert into starlight_metrics (ts, thruput_mbps) values (1425682845, 6);
insert into starlight_metrics (ts, thruput_mbps) values (1425682850, 6);
insert into starlight_metrics (ts, thruput_mbps) values (1425682855, 6);
insert into starlight_metrics (ts, thruput_mbps) values (1425682861, 7);
insert into starlight_metrics (ts, thruput_mbps) values (1425682866, 7);
insert into starlight_metrics (ts, thruput_mbps) values (1425682871, 7);
insert into starlight_metrics (ts, thruput_mbps) values (1425682876, 8);
insert into starlight_metrics (ts, thruput_mbps) values (1425682882, 8);
insert into starlight_metrics (ts, thruput_mbps) values (1425682887, 8);
insert into starlight_metrics (ts, thruput_mbps) values (1425682892, 9);
insert into starlight_metrics (ts, thruput_mbps) values (1425682897, 9);
insert into starlight_metrics (ts, thruput_mbps) values (1425682902, 9);
insert into starlight_metrics (ts, thruput_mbps) values (1425682906, 10);
insert into starlight_metrics (ts, thruput_mbps) values (1425682912, 10);
insert into starlight_metrics (ts, thruput_mbps) values (1425682917, 10);
insert into starlight_metrics (ts, thruput_mbps) values (1425682922, 10);
insert into starlight_metrics (ts, thruput_mbps) values (1425682927, 10);
---- We need to add these metrics to
Scripts for Ali
enable_link
disable_link
synchronize_metrics
grab_generic_metrics_data.php?metrics=thruput_mbps&senders=canarie&tablename=starlight_metrics
grab_generic_metrics_data&metrics=thruput_mbps&senders=canarie&tablename=starlight_metrics
PGPASSWORD=0mlisg00d4u psql -h 155.99.144.155 -u oml2 gec22 -c"update starlight link set status = 'down' where id = 10"
begin transaction;
....
commit;
----
Details:
ssh [email protected] -p 35898
Look at files in /tmp/links
If a file is there, the link is 'up', otherwise 'down'.
python sync_data.py --outfile /tmp/bar.out --dbhost 155.99.144.115 --dbtable starlight_metrics --dbfield thruput_mbps --dbtable_link starlight_link
http://155.99.144.115/html/charttest.php?data_type=generic&metrics=thruput_mbps&senders=canarie,ebi,nih,chicago,starlight&tablename=starlight_metrics
http://155.99.144.115/html/table.php?base_name=starlight&lat=40&lon=-40&zoom=3&data_type1=none&data_type2=none&data_type3=none&data_type4=none&data_type5=none