Results 1 to 6 of 6
-
04-12-2012, 07:36 PM #1WHT Addict
- Join Date
- Dec 2005
- Location
- Australia, Brisbane
- Posts
- 147
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
-
04-12-2012, 08:33 PM #2Web Hosting Guru
- Join Date
- Apr 2012
- Posts
- 275
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.
-
04-12-2012, 08:37 PM #3The Linux Specialist
- Join Date
- Mar 2003
- Location
- /root
- Posts
- 23,990
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.
Specially 4 U
Reseller Hosting: Boost Your Websites | Fully Managed KVM VPS: 3.20 - 5.00 Ghz, Pure Dedicated Power
JoneSolutions.Com is on the net 24/7 providing stable and reliable web hosting solutions, server management and services since 2001
Debian|Ubuntu|cPanel|DirectAdmin|Enhance|Webuzo|Acronis|Estela|BitNinja|Nginx
-
04-13-2012, 05:34 AM #4WHT 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?
-
04-13-2012, 06:04 AM #5Junior Guru
- Join Date
- Jun 2010
- Posts
- 178
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
-
04-13-2012, 02:22 PM #6
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
Phoenix, AZ Dedicated Servers in under an hour
★ Ryzen 9: 7950x3D ★ Dual E5-2680v4 Xeon ★
Contact Us: sales@ioflood.com ★
Similar Threads
-
BLACK FRIDAY - DEDICATED SERVER STOCK SALE - 2ND MONTH FREE - SETUP FREE & SAME DAY!
By FN-Mark in forum Dedicated Hosting OffersReplies: 6Last Post: 12-01-2011, 01:14 AM -
Best recommended Server Setup
By EricTham in forum Hosting Security and TechnologyReplies: 2Last Post: 09-11-2007, 11:46 AM -
Unmetered Dedicated Server | FREE : Setup, Windows 2003 Std, 2nd 400GB HD | Low Price
By VINAX in forum Dedicated Hosting OffersReplies: 4Last Post: 09-04-2007, 03:40 AM -
[UK] Dedicated Servers from £50 w/ 50% 2nd month rental + free setup
By sentientinternet in forum Dedicated Hosting OffersReplies: 3Last Post: 01-27-2007, 08:51 AM -
How to setup a 2nd dedicated server DNS values
By optionsmaster in forum Hosting Security and TechnologyReplies: 0Last Post: 11-29-2004, 09:36 PM