Results 1 to 8 of 8
  1. #1

    Best Dedicated Server for MYSQL

    Hello everybody,
    I've a huge site that runs on PHP and MYSQL, I'm going to get a dedicated server and make it for MYSQL so I need to know what server should I get for MYSQL ?
    does it need to have lots of ram or should I get high CPU ?

    Please advice

  2. #2
    Generally, for large DB processing scenarios, go for the maximum amount of RAM you can afford, as well as that the server can support - however, bear in mind, operating systems would then require a 64bit version of the OS for RAM above 4GB on the server to make use of it / best efficiency.
    CPU also plays an importance, so it does come down to how much you want to spend on your server at the end of the day.
    HDD - the speak of the Hard Disk Drive would also play some part in this equation (based on opinions), however, it does depend on the actual size of the database, frequency of requests, etc. and also on whether you have your DB & PHP optimised for what you are doing on the server.
    A good two core, dual cpu server or a quad core (or dual quad core) server would be a good starting point ... again, depending on your budget!

  3. #3
    Join Date
    May 2006
    Teh Interweb
    In my experience I would have to say that RAM and DiskIO are your two biggest concerns. Get a lot of ram and fast disks. Every database server I have put up recently has 32GB of Ram and 15K drives.

    [[email protected]] ~ $ cat .signature
    cat: .signature: No such file or directory

  4. #4
    Join Date
    Dec 2006
    How big is your database? It's all very well saying "put 32gb of ram in" but if its only got a 4gb database that is a waste of money.

  5. #5
    Join Date
    Feb 2006
    Buffalo NY
    Quote Originally Posted by RBBOT View Post
    How big is your database? It's all very well saying "put 32gb of ram in" but if its only got a 4gb database that is a waste of money.
    He was just saying what he does personally - that is obviously based off his needs.

    As everyone has said it's RAM (for caching) and fast disks (for IO). One thing that people tend to overlook is the use of caching on the actual application level to prevent a lot of intensive requests from being needed.

    Depending on your scenario you might want to consider looking into something like memcached / apc backend cache for some things. You may find you don't even need a database server yet.
    Cody R.
    Hawk Host Inc. Proudly Serving websites since 2004.

  6. #6
    You need to be more spesific with your question anyway

  7. #7
    Join Date
    Oct 2009
    For database servers we normally suggest:

    1) 64-bit operating system
    2) a lot of memory
    3) fast disks (SCSI or SAS at 10/15k RPM)
    4) a customized my.cnf file to tweak several important settings to improve performance

  8. #8
    I agree with DedicatedXL, 64 bits is a must these days. You can max out the ram on a 64 bit system as well.

Similar Threads

  1. dedicated mysql server for under $200
    By boobird in forum Dedicated Server
    Replies: 16
    Last Post: 07-29-2008, 07:35 PM
  2. dedicated mysql server
    By valvehosting in forum Dedicated Server
    Replies: 6
    Last Post: 11-10-2007, 06:23 PM
  3. help needed about - how to optimize MySQL server on my Dedicated Server! details...
    By chessming in forum Hosting Security and Technology
    Replies: 6
    Last Post: 10-18-2006, 09:22 PM
  4. MySQL dedicated server or not
    By AbbasJaffarali in forum Hosting Security and Technology
    Replies: 4
    Last Post: 02-02-2005, 09:24 AM

Posting Permissions

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