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
|
create table cloud_seed(
cloud_id int unique,
cloud_name varchar(50),
status varchar(10),
type varchar(15),
version varchar(10)
);
create table server_process(
server varchar(50),
cloud_id int,
server_pid int,
export_dir varchar(100),
port int,
snum int,
status varchar(15),
logfile varchar(50)
);
create table client_process(
client varchar(50) ,
cloud_id int,
client_pid int,
mount_pt varchar(100),
port int,
cnum int,
status varchar(15),
logfile varchar(50)
);
create table server_pool(
servername varchar(50) ,
status varchar(10),
ipaddress varchar(15)
);
create table client_pool(
clientname varchar(50) ,
status varchar(10),
ipaddress varchar(15)
);
insert into server_pool (servername,status,ipaddress) values
("ec2-67-202-6-25.compute-1.amazonaws.com","free","10.212.187.79");
insert into server_pool (servername,status,ipaddress) values
("ec2-174-129-181-3.compute-1.amazonaws.com","free","10.244.145.156");
insert into server_pool (servername,status,ipaddress) values
("ec2-75-101-171-113.compute-1.amazonaws.com","free","10.244.43.207");
insert into server_pool (servername,status,ipaddress) values
("ec2-67-202-34-30.compute-1.amazonaws.com","free","10.244.163.32");
insert into client_pool (clientname,status,ipaddress) values
("ec2-72-44-36-203.compute-1.amazonaws.com","free","10.245.222.227");
|