Home > Workload Solutions > Oracle > Guides > Design Guide — Oracle Big Data SQL on Dell EMC PowerFlex > VM operating system data store and hard disks design
To create VMs, we created data stores to host VM operating systems by using the PowerFlex volumes that were presented to the database server ESXi hosts. The following table shows the details:
Volume name |
Purpose |
Data store name |
TM_VM_ORACLE_OS |
ORACLE VM OS |
TM_VM_ORACLE_OS |
TM_VM_NN_OS |
HADOOP NAME NODE VM OS |
TM_VM_NN_OS |
TM_VM_DN1_OS |
HADOOP DATA NODE1 VM OS |
TM_VM_DN1_OS |
TM_VM_DN2_OS |
HADOOP DATA NODE2 VM OS |
TM_VM_DN2_OS |
TM_VM_NOSQL_OS |
ORACLE NOSQL VM OS |
TM_VM_NOSQL_OS |
TM_VM_SQL_OS |
SQL VM OS |
TM_VM_SQL_OS |
We mapped all Oracle-related disks (except VM OS disk) presented to the ESXi host from the PowerFlex as raw devices (RDM) to the database VM.
The following table shows the VMware virtual hard disk configuration of the VMs. It has information related to virtual hard disks that are assigned to the VMs, their purpose of usage and other details such as size, disk type, and sharing mode.
Hard disk |
Purpose |
Size (GB) |
Disk type |
Sharing |
VM hard disk configuration for Oracle VM |
||||
Hard disk1 |
GUEST OPERATING SYSTEM DISK |
800 |
VMDK |
No sharing |
Hard disk2 |
STAGING DATA |
600 |
RDM |
No sharing |
Hard disk3-4 |
DATA |
1200 |
RDM |
No sharing |
Hard disk5-8 |
REDO |
200 |
RDM |
No sharing |
Hard disk9 |
TEMP |
500 |
RDM |
No sharing |
Hard disk10 |
FRA |
200 |
RDM |
No sharing |
VM hard disk configuration for Hadoop name node VM |
||||
Hard disk1 |
GUEST OPERATING SYSTEM DISK |
800 |
VMDK |
No sharing |
Hard disk2 |
DATA |
4000 |
VMDK |
No sharing |
Hard disk3 |
STAGING DATA |
500 |
VMDK |
No sharing |
VM hard disk configuration for Hadoop data node1 VM |
||||
Hard disk1 |
GUEST OPERATING SYSTEM DISK |
800 |
VMDK |
No sharing |
Hard disk2-6 |
DATA |
3000 |
VMDK |
No sharing |
VM hard disk configuration for Hadoop data node2 VM |
||||
Hard disk1 |
GUEST OPERATING SYSTEM DISK |
800 |
VMDK |
No sharing |
Hard disk2-6 |
DATA |
3000 |
VMDK |
No sharing |
VM hard disk configuration for Oracle NoSQL VM |
||||
Hard disk1 |
GUEST OPERATING SYSTEM DISK |
800 |
VMDK |
No sharing |
Hard disk2 |
STAGING DATA |
100 |
VMDK |
No sharing |
Hard disk3-4 |
STORAGE NODE DATA |
200 |
VMDK |
No sharing |
VM hard disk configuration for Microsoft SQL Server VM |
||||
Hard disk1 |
GUEST OPERATING SYSTEM DISK |
800 |
VMDK |
No sharing |
Hard disk2-3 |
STAGING DATA |
1200 |
VMDK |
No sharing |
Hard disk4-5 |
DATA |
1000 |
VMDK |
No sharing |
Hard disk6 |
LOG |
200 |
VMDK |
No sharing |