Advice on Database Server Setup
Posted on 2014-03-20
Ok experts, I am looking for suggestions as to the best way to handle what just got dumped in my lap. I have to set up a new database server to house both SQL and MySQL. The work load on the SQL server I will catagorize as low (maybe 20 total users running ACT from Sage. The MySQL needs quite a bit more oomph... 75 users running a read intensive software.
The box I have to work with has:
Server 2012 Standard on LSI 9271 card - RAID 0 2 Tb
There are 8 additional drives on the onboard LSI 2208 which are currently configured into 2 RAID 10 arrays, 2 Tb each. (These can be re-configured to whatever)
Dual Intel XEON E5-2650s with 128 Gb memory.
I can think of several ways to go. I'd love to use Hyper-V and set up a virtual windows server for SQL and another virtual Redhat server for MySQL for ease of management and backup, but I am concerned about the performance hit this may cause.
In any case, I'd love to have your input. Thanks in advance for you suggestions.