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!
It's difficult without knowing your infrastructure (storage hardware? disk speed? ssd? sata? sas?) but 10g from the server instead of 1G will help it alot also if possible increasing mtu to 9k on the portgroup/vlan? used to connect to the storage (9k end to end).