An administrator migrated a physical MySQL database to a Nutanix cluster. After migration, peak load IOPS are lower than expected and latency is higher.
Which two steps should the administrator take to improve this behavior? (Choose two.)
A.
Create additional vDisks for SQL data.
B.
Use LVM to stripe the SQL data across multiple vDisks.
C.
Ensure that SQL data vDisks are thin provisioned.
D.
Ensure that SQL data vDisks are thick provisioned.
Nutanix storage architecture uses distributed data paths, where each vDisk represents a distributed logical object. The performance best practices for databases state:
“Multiple vDisks provide parallelism across the Nutanix storage stack, increasing I/O queue depth and distributing operations across multiple CVMs.”
Also, the guidance for Linux-based database workloads specifies:
“Using LVM striping across multiple vDisks increases throughput by merging multiple I/O channels and enhancing parallel read/write operations.”
Thin vs thick provisioning is irrelevant for performance in a Nutanix environment, as both types deliver identical I/O performance due to the metadata-driven storage engine.
Thus, database performance benefits from additional vDisks and striping across them.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit