I recently started a new job that uses a MySQL server (ver 5.5) running on Windows Server 2012 R2 Standard to host the database used by the entire company (100+ workstations). The database is hosted on the C: drive on a server with 2 hard drives in RAID 1. We are experiencing sever performance issues and from looking at server performance, the storage is the bottleneck. I want to move the database to a NAS connected to the server via iSCSI and have a couple of questions:
1. Is running the database on a NAS via iSCSI a recommended configuration? In my mind, it cannot be worse than what we already have.
2. Is moving the database as simple as creating a directory on the NAS, copying the data folder over, and changing the "datadir" value in the my.ini file?
Any help would be appreciated.