The high-level design principle of the SGs and volumes for the small configuration call for:
- Separate parent SGs for each of the 10 databases
- Dedicated child storage groups (CSGs) and thin volumes for the guest OS, OCR/VD, Grid Infrastructure Management Repository (GIMR), DATA, REDO, FRA, and TEMP
Table 41 shows the SG and volume design for one database set in the small configuration. Replicate the design for the subsequent sets in the small configuration, as shown in Table 42 and Table 43. As shown in the tables, create dedicated OS, OCR, GIMR, DATA, REDO, FRA (OLTP production and test/dev), and TEMP (OLAP production) CSGs for each database.
Note: Because the three OLTP test/dev databases (D2, D3, and D4 in this example) belong to the same database cluster, create OS, OCR, and GIMR SGs only once to be used cluster-wide.
Table 41. Small configuration: SG and volume design of OLTP production databases
C1-TP-SG |
C1-OS |
1 |
550 |
550 |
C1-OCR |
3 |
20 |
60 |
C1-GIMR |
1 |
50 |
50 |
C1-DATA-D1 |
4 |
300 |
1,200 |
C1-REDO-D1 |
4 |
20 |
80 |
C1-FRA-D1 |
1 |
100 |
100 |
Total |
|
14 |
|
2,040 |
Table 42. Small configuration: SG and volume design of OLTP test/dev databases
C2-TD-D2-SG |
C2-OS |
1 |
550 |
550 |
C2-OCR |
3 |
20 |
60 |
C2-GIMR |
1 |
50 |
50 |
C2-DATA-D2 |
4 |
300 |
1,200 |
C2-REDO-D2 |
4 |
20 |
80 |
C2-FRA-D2 |
1 |
100 |
100 |
Total |
|
14 |
|
2,040 |
Parent SG |
Child SG |
Number of volumes |
Size per volume (GB) |
Total size (GB) |
C2-TD-D3-SG |
C2-DATA-D3 |
4 |
300 |
1,200 |
C2-REDO-D3 |
4 |
20 |
80 |
C2-FRA-D3 |
1 |
100 |
100 |
Total |
|
9 |
|
1,380 |
Parent SG |
Child SG |
Number of volumes |
Size per volume (GB) |
Total size (GB) |
C2-TD-D4-SG |
C2-DATA-D4 |
4 |
300 |
1,200 |
C2-REDO-D4 |
4 |
20 |
80 |
C2-FRA-D4 |
1 |
100 |
100 |
Total |
|
9 |
|
1,380 |
|
|
|
|
|
|
|
Table 43. Small configuration: SG and volume design of OLAP production databases
C3-AP-SG |
C3-OS |
1 |
1,100 |
1,100 |
C3-OCR |
3 |
20 |
60 |
C3-GIMR |
1 |
50 |
50 |
C3-DATA-D5 |
4 |
600 |
2,400 |
C3-REDO-D5 |
4 |
20 |
80 |
C3-TEMP-D5 |
1 |
400 |
400 |
Total |
|
14 |
|
4,090 |
Note: The DATA, REDO, and FRA volumes for the test/dev databases are generated using AppSync software. For details, see Creating a repurpose copy.
As shown in Table 44, each ESXi host sees 960 SCSI devices or paths in the small configuration. This number is well below the ESXi 6.5 limit of 2,048, leaving sufficient capacity for additional volumes, if needed.
Table 44. Small configuration: Total SCSI devices or paths
4 |
2 |
4 x 2 = 8 |
60 |
2 |
60 x 2 = 120 |
120 x 8 = 960 |
