hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Dedicated Server : 2nd dedicated server setup - what is recommended?
Reply

Forum Jump

2nd dedicated server setup - what is recommended?

Reply Post New Thread In Dedicated Server Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 04-12-2012, 07:36 PM
hornstar hornstar is offline
WHT Addict
 
Join Date: Dec 2005
Location: Australia, Brisbane
Posts: 147
Arrow

2nd dedicated server setup - what is recommended?


My database is 3+ gigs, I have 1.5 million posts, nearly 700k members, and my database seems to not be handling too well (I've done optimizations on the server and am running LiteSpeed), So I feel it is time to get a 2nd server added which will run my database.

What server hardware/software is most important for the 2nd server which will only be running my database?

1. Is high amount of ram important? Roughly how much would you recommend?

2. Are the hard drives important? Are these okay WD Raptor 10k drives + hardware raid 1? or Should I get SSD hard drives for this server?

3. Will Raid make a difference for this database server? With a tight budget in mind what would be a good raid set up for money wise.

4. Is the quality of the server the most important? Would this do the job good Dell 1U x3220 Quad-core CPU ? OR should I be looking at getting something else?

5. What software would you recommend be installed on this database server to make the most of it.

Thanks all



Sponsored Links
  #2  
Old 04-12-2012, 08:33 PM
pjkenned pjkenned is offline
Junior Guru
 
Join Date: Apr 2012
Posts: 213
Generally, get as much RAM as you can. If you are building a box, you need to at least populate all DIMM channels. (4/ CPU for LGA 2011, 3/ CPU for LGA 1355/ 1366, 2/ for LGA 1155 and 1156.

If you can, best to get enterprise firmware drives when doing RAID. They handle unrecoverable bit errors better when in redundant arrays because they assume there is data to rebuild the lost bits rather than go into heroic recovery mode possibly causing system hangs for the several second duration.

RAID 1 is great as is RAID 10. Software RAID 1/ 10 is generally pretty good if you can.

A Xeon X3220 in a 1U will consume quite a bit of power from the CPU and fans to move the heat if power is a consideration. Speed wise, the X3220 is going to be about equivalent to a Sandy Bridge dual core + hyper threading and something like a E3-1230 will be much faster.

  #3  
Old 04-12-2012, 08:37 PM
net net is offline
Community Liaison
 
Join Date: Mar 2003
Posts: 10,890
No matter how optimized the server is, if your IO is not good, then it will still suffer.

If you are changing server, look for Raid10 and more ram.

Database needs good IO and ram.

__________________
JoneSolutions.Com + SSS = Your Number One Choice On The Net - since 2001

You are most welcome to email me at sales @ jonesolutions.com .

Sponsored Links
  #4  
Old 04-13-2012, 05:34 AM
hornstar hornstar is offline
WHT Addict
 
Join Date: Dec 2005
Location: Australia, Brisbane
Posts: 147
Thanks, I am still not sure if I will get SSD drives or 15K Drives. Is SSD drives going to make a big difference?

I think I will do Raid 1 (Can you do that with SSD drives?)

I might look at starting with 8 gigs of memory, hopefully that will be enough.

Is there any software that I should consider?

  #5  
Old 04-13-2012, 06:04 AM
Taylor - Megahertz H Taylor - Megahertz H is offline
Premium Member
 
Join Date: Jun 2010
Posts: 166
SSD will still be a massive improvement compared to 15k drives, it has what? 10 times faster seek time in comparison with higher data read/writing capabilities, if you got the money go SSD

  #6  
Old 04-13-2012, 02:22 PM
funkywizard funkywizard is offline
unghhh... Baaandwidth....
 
Join Date: Jan 2005
Posts: 8,664
You absolutely should get an SSD. "database starting to run slow" is almost always a disk i/o issue. There may be other issues such as ram, cpu, etc, but almost always disk i/o becomes an issue way before that. A decent SSD can provide 40x the performance of a regular sata drive, or even 10x the performance of a couple of 15k scsi drives. You might even find that getting an SSD in your current server to store the database on will be sufficient that you don't need a separate database server at all.

__________________
IOFLOOD.com -- We Love Servers
Need More Ram? 12 core 72gb ram servers are here!
Email (sales [at] ioflood . com) for details.

Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
BLACK FRIDAY - DEDICATED SERVER STOCK SALE - 2ND MONTH FREE - SETUP FREE & SAME DAY! FN-Mark Dedicated Hosting Offers 6 12-01-2011 01:14 AM
Best recommended Server Setup EricTham Hosting Security and Technology 2 09-11-2007 11:46 AM
Unmetered Dedicated Server | FREE : Setup, Windows 2003 Std, 2nd 400GB HD | Low Price VINAX Dedicated Hosting Offers 4 09-04-2007 03:40 AM
[UK] Dedicated Servers from 50 w/ 50% 2nd month rental + free setup sentientinternet Dedicated Hosting Offers 3 01-27-2007 08:51 AM
How to setup a 2nd dedicated server DNS values optionsmaster Hosting Security and Technology 0 11-29-2004 09:36 PM

Related posts from TheWhir.com
Title Type Date Posted


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?