Let me start out by saying that I am not a Database administrator. My company has been running a Dev and a Test MySQL Database on Vms running on local storage of our ESXi hosts. Each Database is made up of 3 Vms. 2 days ago I Migrated the 6 VMs from the local storage of the ESXi hosts onto a connected Datastore that is located on our ontap. Once we turned on the MySQL services the Databases were unusably slow. Our network connections we over saturated and it casued a lot of other issues.
My question for you all today is is there a better way to do this?
We have 4 1G network cables connected to the ESXi host. Our netapp is connected to the switches with 4 10Gb cables? If I increased the network connection from the ESXi to 2 10Gb connection would that help?
Should the Databases not be located on VM? Can I build them directly on the netapp similar to the Microsoft SQL application?
I know this may require a big explanation so thank you for reading through this!