Results 1 to 6 of 6
  1. #1
    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

  2. #2
    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. #3
    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

  4. #4
    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. #5
    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. #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

  1. Replies: 6
    Last Post: 12-01-2011, 01:14 AM
  2. Best recommended Server Setup
    By EricTham in forum Hosting Security and Technology
    Replies: 2
    Last Post: 09-11-2007, 11:46 AM
  3. Replies: 4
    Last Post: 09-04-2007, 03:40 AM
  4. [UK] Dedicated Servers from £50 w/ 50% 2nd month rental + free setup
    By sentientinternet in forum Dedicated Hosting Offers
    Replies: 3
    Last Post: 01-27-2007, 08:51 AM
  5. How to setup a 2nd dedicated server DNS values
    By optionsmaster in forum Hosting Security and Technology
    Replies: 0
    Last Post: 11-29-2004, 09:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •