/
Drive.php
226 lines (198 loc) · 7.98 KB
/
Drive.php
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
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
<?php
class Drive {
public function exist_tablespace($conn_db, $tablespace) {
global $error;
$sql = "select count(*) from dba_tablespaces where tablespace_name = '" . $tablespace . "'";
$state_id = oci_parse($conn_db, $sql);
$result = oci_execute($state_id);
if ($result != TRUE) {
$error->set_msg("Failed SQL = '$sql'");
return(ERROR);
}
$row = oci_fetch_array($state_id);
if ($row[0] == '1') {
return(TRUE);
} else {
return(FALSE);
}
}
public function create_tablespace($conn_db, $tablespace, $dg) {
global $error;
$result = self::exist_tablespace($conn_db, $tablespace);
if ($result == TRUE) {
$error->set_msg("Tablespace already exists.");
return(ERROR);
}
$sql = "CREATE BIGFILE TABLESPACE $tablespace DATAFILE '+$dg' SIZE 1M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO DEFAULT COMPRESS FOR OLTP";
$state_id = oci_parse($conn_db, $sql);
$result = oci_execute($state_id);
if ($result == FALSE) {
$error->set_msg("Failed SQL = '$sql'");
return(ERROR);
}
return(TRUE);
}
public function delete_tablespace($conn_db, $tablespace) {
global $error;
$sql = "DROP TABLESPACE $tablespace";
$state_id = oci_parse($conn_db, $sql);
$result = oci_execute($state_id);
if ($result != TRUE) {
$error->set_msg("Failed SQL = '$sql'");
return(ERROR);
}
return(TRUE);
}
public function fetch_dg_detail($conn_asm, $dg) {
global $error;
$sql = "SELECT TOTAL_MB, FREE_MB FROM V\$ASM_DISKGROUP WHERE NAME = '" . $dg . "'";
$state_id = oci_parse($conn_asm, $sql);
$result = oci_execute($state_id);
if ($result != TRUE) {
$error->set_msg("Failed SQL = '$sql'");
return(ERROR);
}
$row = oci_fetch_array($state_id, OCI_BOTH);
$dg_detail = array();
$dg_detail['space_total'] = $row['TOTAL_MB'];
$dg_detail['space_free'] = $row['FREE_MB'];
$dg_detail['space_used'] = $dg_detail['space_total'] - $dg_detail['space_free'];
$dg_detail['space_usage'] = round(100 * $dg_detail['space_used'] / $dg_detail['space_total']);
return($dg_detail);
}
public function update_storage_quota($conn_db, $customer_id, $max_gbytes) {
global $error;
$sql = "ALTER USER " . $customer_id . " QUOTA " . $max_gbytes. "G on " . $customer_id;
$state_id = oci_parse($conn_db, $sql);
$result = oci_execute($state_id);
if ($result != TRUE) {
$error->set_msg("Failed SQL = '$sql'");
return(ERROR);
}
return(TRUE);
}
public function update_compression($conn_db, $tablespace, $compression) {
global $error;
if ($compression == 'on') {
$sql = "ALTER TABLESPACE " . $tablespace . " DEFAULT COMPRESS FOR OLTP";
} elseif ($compression == 'off') {
$sql = "ALTER TABLESPACE " . $tablespace . " DEFAULT NOCOMPRESS";
} else {
$error->set_msg("Invalid compression mode specified.");
return(ERROR);
}
$state_id = oci_parse($conn_db, $sql);
$result = oci_execute($state_id);
if ($result != TRUE) {
$error->set_msg("Failed SQL = '$sql'");
return(ERROR);
}
return(TRUE);
}
public function fetch_member_disk($conn_asm, $dg) {
global $error;
$sql = "select v\$asm_disk.path, v\$asm_disk.os_mb, v\$asm_disk.header_status, v\$asm_disk.state from v\$asm_disk left outer join v\$asm_diskgroup on v\$asm_disk.group_number = v\$asm_diskgroup.group_number where v\$asm_diskgroup.name = '" . $dg . "'";
$state_id = oci_parse($conn_asm, $sql);
$result = oci_execute($state_id);
$array_disk = array();
while ($disk = oci_fetch_array($state_id, OCI_BOTH)) {
array_push($array_disk, $disk);
}
return($array_disk);
}
public function fetch_candidate_disk($conn_asm) {
global $error;
global $aws_instance_id;
global $aws_region;
$sql = "select path, os_mb ,header_status from v\$asm_disk where header_status = 'CANDIDATE' or header_status = 'FORMER'";
$state_id = oci_parse($conn_asm, $sql);
$result = oci_execute($state_id);
if (AWS == TRUE) {
$aws = new Aws($aws_instance_id, $aws_region);
}
$array_disk = array();
while ($disk = oci_fetch_array($state_id, OCI_BOTH)) {
if (AWS == TRUE) {
$aws_volume_id = $aws->fetch_volume_id_by_disk_path($disk['PATH']);
$disk['aws_volume_id'] = $aws_volume_id;
}
array_push($array_disk, $disk);
}
return($array_disk);
}
public function fetch_all_disk($conn_asm) {
global $error;
global $aws_instance_id;
global $aws_region;
$sql = "select path, os_mb ,header_status from v\$asm_disk";
$state_id = oci_parse($conn_asm, $sql);
$result = oci_execute($state_id);
if (AWS == TRUE) {
$aws = new Aws($aws_instance_id, $aws_region);
}
$array_disk = array();
while ($disk = oci_fetch_array($state_id, OCI_BOTH)) {
if (AWS == TRUE) {
$aws_volume_id = $aws->fetch_volume_id_by_disk_path($disk['PATH']);
$disk['aws_volume_id'] = $aws_volume_id;
}
array_push($array_disk, $disk);
}
return($array_disk);
}
public function disk_exist($conn_asm, $disk_path) {
global $error;
$sql = "select count(*) from v\$asm_disk where path = '" . $disk_path . "'";
$state_id = oci_parse($conn_asm, $sql);
$result = oci_execute($state_id);
$row = oci_fetch_array($state_id, OCI_BOTH);
if ($row['COUNT(*)'] == 1) {
return TRUE;
} else {
return FALSE;
}
}
public function fetch_available_device($conn_asm, $array_device_list) {
global $error;
$array_all_disk = self::fetch_all_disk($conn_asm);
foreach($array_all_disk as $k => $disk) {
if (in_array(str_replace('/dev/','',$disk['PATH']), $array_device_list)) {
$key_to_unset = array_search(str_replace('/dev/','',$disk['PATH']), $array_device_list);
unset($array_device_list[$key_to_unset]);
}
}
$available_device_list = array_values($array_device_list);
if (count($available_device_list) < 1) {
$error->set_msg("No more available device to attach.");
return(ERROR);
}
return($available_device_list[0]);
}
public function add_disk($conn_asm, $dg, $disk_path) {
global $error;
$sql = "ALTER DISKGROUP $dg ADD DISK '" . $disk_path . "'";
$state_id = oci_parse($conn_asm, $sql);
$result = oci_execute($state_id);
if ($result != TRUE) {
$error->set_msg("Failed SQL = '$sql'");
return(ERROR);
}
return(TRUE);
}
public function delete_disk($conn_asm, $dg, $disk_path) {
global $error;
$sql = "select v\$asm_disk.name from v\$asm_disk left outer join v\$asm_diskgroup on v\$asm_disk.group_number = v\$asm_diskgroup.group_number where v\$asm_diskgroup.name = '" . $dg . "' and v\$asm_disk.path = '" . $disk_path . "'";
$state_id = oci_parse($conn_asm, $sql);
$result = oci_execute($state_id);
$row = oci_fetch_array($state_id, OCI_BOTH);
$sql = "ALTER DISKGROUP $dg DROP DISK " . $row['NAME'];
$state_id = oci_parse($conn_asm, $sql);
$result = oci_execute($state_id);
if ($result != TRUE) {
$error->set_msg("Failed SQL = '$sql'");
return(ERROR);
}
return(TRUE);
}
}
?>