Advice on Database Server Setup

Posted on 2014-03-20
Last Modified: 2014-03-27
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.
Question by:JP_TechGroup
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 40

Accepted Solution

lcohan earned 400 total points
ID: 39943640
This is what I would do assuming you are ok with MySQL running on Windows:

Server 2012 Standard on LSI 9271 card - RAID 0 2 Tb -> change this to least RAID 1 and
install all applications (SQL,MySQL) with their own System Databases - I.E. SQL master,tempdb,etc...

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)
-> I would leave them as they are and use one for SQL and one for MySQL user databases assuming the 2TB is enough for each.

Dual Intel XEON E5-2650s with 128 Gb memory.
-> I would configure SQL MAX Memory to 60GB leaving plenty for OS and MySQL - this can be even further reduced if MySQL will need to use more RAM

Author Comment

ID: 39943730
Hmm.... Why Stripe the OS volume? Mirrored drive not fast enough for all the throughput?
LVL 58

Assisted Solution

by:Cliff Galiher
Cliff Galiher earned 100 total points
ID: 39943925
Unless that MySQL database is *very* poorly optimized (more of a developer issue than an IT Pro issue), 75 users is still a drop in the bucket when you consider there are some fairly formidable websites out there that run on the LAMP stack and process thousands of unique hits a second (such as store product searches where page caching is not as useful.)

I'd never make any firm decisions without having more information. Which means actually turning on some performance counters and *seeing* what your I/O load is like. But speculatively I'd think you'll be fine with little to no changes. You already have two arrays, so whether one array is hosting MySQL and the other SQL server, or whether one is hosting a windows OS with SQL server and the other a Linux variant with MySQL is really rather a minor change considering most of the I/O on either array would still be SQL-related. OS overhead is usually minimal for any OS. And the addition of a parent/host? Also negligible.

I really don't think you have a lot to worry about performance-wise given your current configuration. You could fairly safely make the change you want with little to no hardware changes and very little concern for a sudden performance issue. And, as mentioned, you can even verify that suspicion with a little sleuthing in performance counters.

Author Closing Comment

ID: 39959165
Thanks guys. I appreciate the feedback... and I must need sleep..
I said Raid 0 meaning Raid 1! Thanks again.

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is intended for those who are new to PHP error handling (  It addresses one of the most common problems that plague beginning PHP develop…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question