JP_TechGroup
asked on
Advice on Database Server Setup
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks guys. I appreciate the feedback... and I must need sleep..
I said Raid 0 meaning Raid 1! Thanks again.
I said Raid 0 meaning Raid 1! Thanks again.
ASKER