Home > Workload Solutions > Oracle > Guides > Design Guide — MySQL InnoDB Cluster on Dell EMC PowerStore T > VMFS data stores
To create database VMs, we created four VMFS data stores to host VM operating systems by using the storage volumes that are presented to the database server ESXi hosts. The following table shows the details:
Volume name |
Purpose |
Data store name |
Accessible by ESXi hosts |
PROD_VM_1 |
PROD VM1 OS |
Prod_VM1_OS_DS |
Prod_Host1 |
PROD_VM_2 |
PROD VM2 OS |
Prod_VM2_OS_DS |
Prod_Host2 |
PROD_VM_3 |
PROD VM3 OS |
Prod_VM3_OS_DS |
Prod_Host3 |
DEV_VM_2 |
DEV VM1 OS |
DEV_VM2_OS_DS |
DEV_Host1 |
The following table shows the hard disk configuration and the SCSI controller identifier in the PROD database VM. All hard disks are VMFS disk type and are not shareable by any other database VMs. All the disks are Thick Provisioned EAGER Zeroed VMFS. For example, we created three data disks for three production VMs. The table represents the production VM1 VMFS datastore. Similarly, we created the VMFs volumes for Prod_Host2 and Prod_Host3.
Note: MySQL InnoDB Cluster features shared-nothing architecture.
Hard disk |
Purpose |
Size |
SCSI controller |
Disk type |
Sharing |
Compatibility mode |
Hard disk 1 |
Guest OS disk |
600 GB |
0 |
VMFS |
No sharing |
Physical |
Hard disk 2 |
DATA |
2 TB |
1 |
VMFS |
No sharing |
Physical |
Hard disk 3 |
REDO, BIN LOG |
2 TB |
2 |
VMFS |
No sharing |
Physical |
Hard disk 4 |
TEMP, UNDO |
100 GB |
3 |
VMFS |
No sharing |
Physical |