Results 1 to 7 of 7
  1. #1

    Dedicated MySQL Server Performance

    Which of these two setups would you advise for a dedicated mysql server? The mysql server would have lots of reads and writes. More reads than writes.

    Single 10K RPM SCSI


    Dual 7200 RPM IDE in RAID - 1
    - RAID - 1 being able to double the read transaction rate.

    Thoughts, comments, advise, suggestions?

  2. #2
    Join Date
    Mar 2003
    California USA
    I say the scsi
    Steven Ciaburri | Proactive Linux Server Management -
    Managed Servers (AS62710), Server Management, and Security Auditing.

  3. #3

    SCSI hands down. And I would recommend at least RAID on the SCSI with a hardware RAID controller as well.

    Thank you.
    Peter M. Abraham
    LinkedIn Profile

  4. #4
    Join Date
    Nov 2002
    raid 1 is horrible for mysql

    trust me

  5. #5
    Join Date
    Nov 2002
    What you want is probably something like 5 x 18GB 10K RPM drive. We have one of these running RTG and it's much much much faster than a pair of IDE drive.

  6. #6
    SATA Raptors might also work nicely for you (if SATA is an option)... they rival SCSI speeds at a lower price.

  7. #7
    SCSI is still the performance leader, however the raid 1 option with a pair of IDE drives (on seperate controllers channels!) is always going to the second best option at a fraction of the cost.

Posting Permissions

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