var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
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?
SCSI hands down. And I would recommend at least RAID on the SCSI with a hardware RAID controller as well.
raid 1 is horrible for mysql
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.
http://Ethr.net [email protected]
West Coast AT&T / Level3 / Savvis
Bandwidth, Colocation, Dedicated Server, Managed IP Service, Hardware Load Balancing Service, Transport Service, 365 Main St, SFO / 200 Paul Ave, SFO / PAIX, PAO / Market Post Tower, 55 S. Market, SJC / 11 Great Oaks, Equinix, SJC
SATA Raptors might also work nicely for you (if SATA is an option)... they rival SCSI speeds at a lower price.
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.