RPS Notes and RPS REMOS Relational Schema Peter A

RPS Notes and RPS/REMOS Relational Schema Peter A. Dinda

RPS Toolkit • Extensible toolkit for implementing resource signal prediction systems • Easy “buy-in” for users • C++ and sockets (no threads) • Prebuilt prediction components • Libraries (sensors, time series, communication) • Users have bought in • Incorporated in CMU Remos, BBN Qu. O • Various research users http: //www. cs. northwestern. edu/~pdinda/RPS. html

Conceptual Model of an RPS-based System RPS components can be composed in other ways

Common Configuration

Queries and Data Models for Prediction and Measurement In RPS and Remos Peter A. Dinda Remos Meeting 3/9/99

Measurement/Prediction Queries • “Where can I find a load measurement stream for the host firenze? ” – source: tcp: firenze: 5000, source: udp: 239. 99. 99: 5000 • “Give me the latest prediction server implementation for ALPHA DUX 3. 2” – blob(executable) • “Where can I find a prediction buffer for the underlying load measurement stream “firenze””? – requestresponse: tcp: pyramid: 8193

Resource Queries • “I need 1 to 4 machines, all the same OS and arch, with a combined memory of 1 GB” – (mojave), (sahara), ((poconos, pyramid, foo), (man ch 1, 2, 3, 4), etc) • . . .

Database Schema benchmarks BT numproc mhz arch os osv mem vmem dasd perfblob note UR hostdata ip numproc mhz arch os osv mem vmem dasd loc user note UR hosts ip name datasources dsid dst flowssources dsid ip 1 ip 2 nodesource dsid ip modules mid mt dsid note moduleexecs mt arch os minosv ver execblob note endpoints mid epid endpointdata epid ct ip port fn note UR UR

Query Example [pdinda@firenze ~]$ find_hosts_mem. pl minmem maxmem minnum maxnum limit [samearchos] [pdinda@firenze ~]$ find_hosts_mem. pl 512 1024 1 3 5 1 Host solutions select host 1. name, hd 1. arch, hd 1. os, hd 1. mem as Total. Mem hd 1. mem <= 1024 order by Total. Mem desc limit 5 +------------+-------+-----+ | name | arch | os | Total. Mem | +------------+-------+-----+ | mojave. cmcl. cs. cmu. edu | ALPHA | DUX | 1024. 00 | | sahara. cmcl. cs. cmu. edu | ALPHA | DUX | 1024. 00 | +------------+-------+-----+ from hosts as host 1, hostdata as hd 1 where 2 Host solutions select host 1. name, hd 1. arch, hd 1. os, host 2. name, hd 2. arch, hd 2. os, hd 1. mem+ hd 2. mem as Total. Mem from host 2, hostdata as hd 2 where host 1. ip=hd 1. ip and host 2. ip=hd 2. ip and hd 1. mem + hd 2. mem >= 512 and host 2. ip order by Total. Mem desc limit 5 +---------------------------+-------+-------+-----+ | name | arch | os | Total. Mem | +---------------------------+-------+-------+-----+ | poconos. cmcl. cs. cmu. edu | ALPHA | DUX | firenze. cmcl. cs. cmu. edu | I 386 | LINUX | 512. 00 | | poconos. cmcl. cs. cmu. edu | ALPHA | DUX | INNUENDO. TRUST. CS. CMU. EDU | I 386 | LINUX | 512. 00 | | poconos. cmcl. cs. cmu. edu | ALPHA | DUX | pyramid. cmcl. cs. cmu. edu | ALPHA | DUX | 512. 00 | | firenze. cmcl. cs. cmu. edu | I 386 | LINUX | poconos. cmcl. cs. cmu. edu | ALPHA | DUX | 512. 00 | | INNUENDO. TRUST. CS. CMU. EDU | I 386 | LINUX | poconos. cmcl. cs. cmu. edu | ALPHA | DUX | 512. 00 | +---------------------------+-------+-------+-----+ host 1. ip=hd 1. ip and hd 1. mem >= 512 and hosts as host 1, hostdata as hd 1, hosts as hd 1. mem + hd 2. mem <= 1024 and host 1. ip != 3 Host solutions select host 1. name, hd 1. arch, hd 1. os, host 2. name, hd 2. arch, hd 2. os, host 3. name, hd 3. arch, hd 3. os, hd 1. mem+ hd 2. mem+ hd 3. mem as Total. Mem from hosts as host 1, hostdata as hd 1, hosts as host 2, hostdata as hd 2, hosts as host 3, hostdata as hd 3 where host 1. ip=hd 1. ip and host 2. ip=hd 2. ip and host 3. ip=hd 3. ip and hd 1. mem + hd 2. mem + hd 3. mem >= 512 and hd 1. mem + hd 2. mem + hd 3. mem <= 1024 and host 1. ip != host 2. ip and host 1. ip != host 3. ip and host 2. ip != host 3. ip order by Total. Mem desc limit 5 +---------------------------+-------+-------+--------------+-------+-----+ | name | arch | os | Total. Mem | +---------------------------+-------+-------+--------------+-------+-----+ | poconos. cmcl. cs. cmu. edu | ALPHA | DUX | INNUENDO. TRUST. CS. CMU. EDU | I 386 | LINUX | firenze. cmcl. cs. cmu. edu | I 386 | LINUX | 640. 00 | | poconos. cmcl. cs. cmu. edu | ALPHA | DUX | pyramid. cmcl. cs. cmu. edu | ALPHA | DUX | firenze. cmcl. cs. cmu. edu | I 386 | LINUX | 640. 00 | | INNUENDO. TRUST. CS. CMU. EDU | I 386 | LINUX | poconos. cmcl. cs. cmu. edu | ALPHA | DUX | firenze. cmcl. cs. cmu. edu | I 386 | LINUX | 640. 00 | | pyramid. cmcl. cs. cmu. edu | ALPHA | DUX | poconos. cmcl. cs. cmu. edu | ALPHA | DUX | firenze. cmcl. cs. cmu. edu | I 386 | LINUX | 640. 00 | | poconos. cmcl. cs. cmu. edu | ALPHA | DUX | firenze. cmcl. cs. cmu. edu | I 386 | LINUX | INNUENDO. TRUST. CS. CMU. EDU | I 386 | LINUX | 640. 00 | +---------------------------+-------+-------+--------------+-------+-----+