Determine the numbers and capacities of log disks and data disks before deployment. Table-1 provides disk planning examples for SQL Server. You can increase the capacities of log disks as needed.
Table-1 SQL Server disk planning examples
|
Database |
Number |
Drive letter |
Shared volume size |
Storage pool name |
Disk group name |
|
SQL Server 2016 |
1 |
/dev/vdb |
100 GB |
LOG1 |
LOG |
|
2 |
/dev/vdc |
100 GB |
LOG2 |
LOG |
|
|
3 |
/dev/vdd |
100 GB |
LOG3 |
LOG |
|
|
4 |
/dev/vde |
200 GB |
DATA1 |
DATA |
|
|
5 |
/dev/vdf |
200 GB |
DATA2 |
DATA |
|
|
6 |
/dev/vdg |
200 GB |
DATA3 |
DATA |
|
|
7 |
/dev/vdh |
200 GB |
DATA4 |
DATA |
|
|
8 |
/dev/vdi |
200 GB |
DATA5 |
DATA |
|
|
9 |
/dev/vdj |
200 GB |
DATA6 |
DATA |
|
|
10 |
/dev/vdk |
200 GB |
DATA7 |
DATA |
Determine the numbers and capacities of log disks and data disks before deployment. Table-2 provides disk planning examples for MySQL. You can increase the capacities of log disks as needed.
Table-2 MySQL disk planning examples
|
Database |
Number |
Drive letter |
Shared volume size |
Storage pool name |
Disk group name |
|
My SQL 5.7 |
1 |
/dev/vdb |
100 GB |
LOG1 |
LOG |
|
2 |
/dev/vdc |
100 GB |
LOG2 |
LOG |
|
|
3 |
/dev/vdd |
100 GB |
LOG3 |
LOG |
|
|
4 |
/dev/vde |
200 GB |
DATA1 |
DATA |
|
|
5 |
/dev/vdf |
200 GB |
DATA2 |
DATA |
|
|
6 |
/dev/vdg |
200 GB |
DATA3 |
DATA |
|
|
7 |
/dev/vdh |
200 GB |
DATA4 |
DATA |
|
|
8 |
/dev/vdi |
200 GB |
DATA5 |
DATA |
|
|
9 |
/dev/vdj |
200 GB |
DATA6 |
DATA |
|
|
10 |
/dev/vdk |
200 GB |
DATA7 |
DATA |
Determine the numbers and capacities of log disks, data disks, and quorum disks before deployment. Table-3 provides disk planning examples for Oracle. You can increase the capacities of log disks as needed.
Table-3 Oracle disk planning examples
|
Database |
Number |
Drive letter |
Shared volume size |
Storage pool name |
Disk group name |
|
Oracle 12C |
1 |
/dev/vdb |
100 GB |
LOG1 |
LOG |
|
2 |
/dev/vdc |
100 GB |
LOG2 |
LOG |
|
|
3 |
/dev/vdd |
100 GB |
LOG3 |
LOG |
|
|
4 |
/dev/vde |
200 GB |
DATA1 |
DATA |
|
|
5 |
/dev/vdf |
200 GB |
DATA2 |
DATA |
|
|
6 |
/dev/vdg |
200 GB |
DATA3 |
DATA |
|
|
7 |
/dev/vdh |
200 GB |
DATA4 |
DATA |
|
|
8 |
/dev/vdi |
200 GB |
DATA5 |
DATA |
|
|
9 |
/dev/vdj |
200 GB |
DATA6 |
DATA |
|
|
10 |
/dev/vdk |
50 GB |
GRID1 |
GRID |