Home > Workload Solutions > Oracle > Guides > Design Guide — MySQL InnoDB Cluster on Dell EMC PowerStore T > Virtual machines
We used the following design principles and best practices to create the VMs.
We created multiple SCSI controllers to optimize and balance the I/O for the different database disks, as shown in the following table:
Controller |
Purpose |
SCSI bus sharing |
Type |
SCSI 0 |
Guest operating system |
None |
VMware Paravirtual |
SCSI 1 |
MySQL REDO, BINLOG |
Physical |
VMware Paravirtual |
SCSI 2 |
MySQL DATA |
Physical |
VMware Paravirtual |
SCSI 3 |
MySQL TEMP, UNDO |
Physical |
VMware Paravirtual |
We chose the controller type VMware Paravirtual for optimal performance.
We assigned the following properties to all database-related virtual disks such as DATA, Log, Temp, and Undo:
The following figure shows the hard disk properties:
The following table shows the amount of virtual CPU (vCPU) and virtual memory (vMem) that we assigned to the production and snapshot database VMs in this solution.
Characteristic |
Value |
vCPUs |
12 |
Memory |
256 GB |
The following figure shows the VM memory reservation:
The following figure shows the VM CPU properties: