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
Solved

Replacing traditional server HDs with SSD for gaining in DB performance?

Posted on 2012-03-27
17
604 Views
Last Modified: 2012-03-27
Hi,

I've got two virtual Windows Server 2008 32bit running on VMWare ESXi 4.0 on the RAID1 partition of a HP ProLiant DL360 G5. One of the virtual servers is used as a PostgreSQL database server. A colleague of mine is now trying to boost the read-performance of the DB and suggested to use (consumer) solid state disks ... but I'm a bit skeptical. So what is your advice?

Does this make sense? And what exactly would I have to do?
- backup my virtual machines
- replace the two disks
- create a new RAID1
- reinstall VMWare ESXi
- restore the virtual machines
- start and everything will be fine?

Thanks!

Jerome
0
Comment
Question by:Xeronimo
  • 8
  • 7
  • 2
17 Comments
 
LVL 119

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 500 total points
ID: 37770735
RAID1 for a datastore will give you poor performance, because you do not have many IOPS.

You also do not mention what type of disks you have? SAS or SATA.

I would leave the RAID1 disks in place, I would then install ESXi onto a USB flash drive. 2GB USB flash drive is supported internally on the G5.

Here is the VMware KB on installing 4.1 on USB/SD:
http://kb.vmware.com/kb/1020655

Here is the VMware KB on installing 5.0 on USB/SD:
http://kb.vmware.com/kb/2004784

Install Consumer SSDs, Boot ESXi 4.1, and move the existing Virtual Machines from old datastore (RAID 1) to newer SSD datastore.

At this time you may want to consider ESXi 5.0, because it's SSD aware, and you can also use some space on the SSD for Host Cache Configuration to help Machine Swapping, under extreme memory pressure.

Copy your VMs from one datastore to the new datastore as per my article


HOW TO: Clone or Copy a virtual machine in VMware vSphere Hypervisor ESX/ESXi 4.x or ESXi 5.0

As for Consumer SSDs, we use them in ESXi, we use OCZ, Corsair and Kingston.

IOPS, Latency is far better, and your performance will be better as well.
0
 

Author Comment

by:Xeronimo
ID: 37770755
hanccocka:

Ok, thanks so far! I'll check those out.

And so I can install ESXi on a simple USB stick, plug it into the USB port and then boot the server from it? Didn't know that was possible (and recommended) with servers?

On a side note: what RAID would you use on datastores then? I've got RAID5 on my other data stores. But in the case of the ProLiant, the datastore is the two internal SAS drives.

As for ESXi 5, I've got to check with our budget ...
0
 
LVL 119
ID: 37770765
RAID 10.

As for RAID with SSDs, personally I would not bother, just make sure you have good backups.

SSDs die!
0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 119
ID: 37770768
We've been deploying ESXi on USB since 2004, yes it's supported, and that's why the G5 has an internal USB port for this purpose of Embedded ESXi!
0
 
LVL 55

Expert Comment

by:andyalder
ID: 37770806
So long as you get a USB stick that it atually boots from :(

As far as consumer grade SSDs are concerned you can use them but the fans may go on full speed if they do not have thermal sensors. For read speed RAID 5 or RAID 10 are both good, RAID 5 isn't good for write speed but I take it that that is not important here.
0
 

Author Comment

by:Xeronimo
ID: 37770855
Little update/correction here: the current configuration is 4 SAS 10k disks as RAID5 in the ProLiant.

@hanccocka: Sorry for being a bit slow here but so you would do it like this:
- install ESXi on a USB stick for the internal USB port of the ProLiant
- replace the 4 internal SAS disks with 4 SSDs (do I need a new controller or something for this?)
- leave the SSDs as RAID0 and define them as datastore
- restore the virtual machines back on that datastore
?

@andy:
- so which USB sticks will boot and which won't?
- the fans going full speed would not be ideal ... which SSDs would you recommend then?
- and you would, unlike hanc, use RAID on the SSDs?

Thank you
0
 
LVL 119
ID: 37770884
use 2GB SanDisks sticks

your method is correct.

do you really need 4 SSDs?
0
 

Author Comment

by:Xeronimo
ID: 37770887
Another update: I just noticed that we recently got new a vSphere5 licence, good! :)
0
 

Author Comment

by:Xeronimo
ID: 37770919
@hancc:

Ok, I will get such sticks then!

Uh, you're right ... maybe I don't need 4 disks if I won't use them as RAID in the first place ... But so can I simply use them inside of the ProLiant instead of the SAS disks? I guess I need special cases to connect them? Which ones would that be ... I'm obviously not really a hardware guy ;)

But so in that case I would then:
- backup the virtual machines
- power the server down, take out all the SAS disks, insert one or two SSDs
- install vSphere5 on a USB stick, stick it in the ProLiant and boot from it
- define a new datastore based on the SSDs
- restore the VMs, start them.

Right?
0
 
LVL 119
ID: 37770932
no real need to remove SAS disks.

you will be able to use as long as you get the mechanics correct.
0
 

Author Comment

by:Xeronimo
ID: 37770939
@hancc:

But if I don't remove them SAS disks where will I connect the SSDs ... ?
0
 
LVL 119
ID: 37770946
in the chassis, you have eight slots?
0
 
LVL 55

Expert Comment

by:andyalder
ID: 37770956
0
 

Author Comment

by:Xeronimo
ID: 37770971
@hanccocka:

No, only 4 slots! It's a ProLiant 360 G5. Although the HP website indicates 6 for the G5 (our server is in a different building) ... have to check that again. But in that case I could indeed simply add two SSDs ... yet I'm quite sure there are only 4 slots ...

But in that case I could simply replace them, right?
0
 

Author Comment

by:Xeronimo
ID: 37770977
@andy: thanks, and those also work with SSDs? I only see SCSI or SATA disks mentioned on that site ...
0
 
LVL 119
ID: 37770993
SSDs are SATA
0
 

Author Comment

by:Xeronimo
ID: 37770996
Uh, ok ... stupid question then ;)

Thanks!
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Patching ESXi Host via PowerCLI 10 40
Linux mount of Windows Shared Now Fails 8 75
Restore VM Creates MAC Conflict. 6 43
Migrating Windows vCenter Server 5.5 to VCSA 6.5 8 49
If we need to check who deleted a Virtual Machine from our vCenter. Looking this task in logs can be painful and spend lot of time, so the best way to check this is in the vCenter DB. Just connect to vCenter DB(default DB should be VCDB and using…
In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
Teach the user how to install and configure the vCenter Orchestrator virtual appliance Open vSphere Web Client: Deploy vCenter Orchestrator virtual appliance OVA file: Verify vCenter Orchestrator virtual appliance boots successfully: Connect to the …
Teach the user how to install log collectors and how to configure ESXi 5.5 for remote logging Open console session and mount vCenter Server installer: Install vSphere Core Dump Collector: Install vSphere Syslog Collector: Open vSphere Client: Config…

839 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