Compaq ProLiant 6500 Compaq Parallel Database Cluster Model PDC/O2000 for Orac - Page 126

Planning the Grouping of Physical Disk Storage Space

Page 126 highlights

4-18 Compaq Parallel Database Cluster Model PDC/O2000 for Oracle8i and Windows 2000 Administrator Guide The following general guidelines apply to RAID selection for a cluster with RA4000/RA4100 Arrays using Oracle8i Parallel Server: I Oracle recommends that some form of disk fault tolerance be implemented in the cluster. I In order to ease the difficulty of managing dynamic space allocation in an Oracle Parallel Server raw volume environment, Oracle recommends the creation of "spare" raw volumes that can be used to dynamically extend tablespaces when the existing datafiles approach capacity. The number of these spare raw volumes should represent from 10 to 30 percent of the total database size. To allow for effective load balancing, the spares should be spread across a number of disks and controllers. The database administrator should decide, on a case by case basis, which spare volume to use based on which volume would have the least impact on scalability (for both speedup and scaleup). Planning the Grouping of Physical Disk Storage Space Figure 4-5 shows how the physical storage space in one RA4000/RA4100 Array that contains eight physical disk drives might be grouped for an Oracle8i Parallel Server database. RA4000/4100 Array Disk Disk Disk Disk Disk Disk Disk Disk Drive Drive Drive Drive Drive Drive Drive Drive Create logical drive arrays with Compaq Array Configuration Utility RAID 5 Disk Array RAID 1 Disk Array RAID 1 Disk Array Create extended partitions with Disk Management Create logical partitions with Disk Management Extended Partition / D / E / F / G /H / I / J / Extended Partition Extended Partition / K / L / / M / N / Figure 4-5. RA4000/RA4100 Array disk grouping for a PDC/O2000 cluster

  • 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
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247

4-18
Compaq Parallel Database Cluster Model PDC/O2000 for Oracle8i and Windows 2000 Administrator Guide
The following general guidelines apply to RAID selection for a cluster with
RA4000/RA4100 Arrays using Oracle8
i
Parallel Server:
Oracle recommends that some form of disk fault tolerance be
implemented in the cluster.
In order to ease the difficulty of managing dynamic space allocation in
an Oracle Parallel Server raw volume environment, Oracle recommends
the creation of
spare
raw volumes that can be used to dynamically
extend tablespaces when the existing datafiles approach capacity. The
number of these spare raw volumes should represent from 10 to
30 percent of the total database size. To allow for effective load
balancing, the spares should be spread across a number of disks and
controllers. The database administrator should decide, on a case by case
basis, which spare volume to use based on which volume would have
the least impact on scalability (for both speedup and scaleup).
Planning the Grouping of Physical Disk
Storage Space
Figure 4-5 shows how the physical storage space in one RA4000/RA4100
Array that contains eight physical disk drives might be grouped for an
Oracle8
i
Parallel Server database.
RA4000/4100 Array
Disk
Drive
Disk
Drive
Disk
Drive
Disk
Drive
Disk
Drive
Disk
Drive
Disk
Drive
Disk
Drive
Create extended
partitions with
Disk Management
Extended
Partition
Extended
Partition
Extended
Partition
RAID 5
Disk Array
Create logical drive
arrays with
Compaq Array
Configuration Utility
RAID 1
Disk Array
RAID 1
Disk Array
Create logical
partitions with
Disk Management
/ D / E / F / G /H / I
/ J /
/ K / L /
/ M / N /
Figure 4-5.
RA4000/RA4100 Array disk grouping for a PDC/O2000 cluster