If you are going to put everything on the mirrored drives, I would make sure you have plenty of RAM. Your worst case scenario is having the OS doing a lot of paging, due too lack of RAM, while your database is very active. The OS will always use the disk (i.e. writing logs), but if you can keep the OS activity to minimum, your performance hit should be negligible.
Get all the performance you can out of tweaking the MySQL and other settings first, then you can resort to the hardware. I assume you are using software mirroring and perhaps even just one IDE controller for both drives (master/slave setup). Both give you performance hits, especially having one controller. But it's definitely a workable setup that still should give you decent performance.
On Jul 28, 2004, at 3:30 PM, Rick Dwyer wrote:
Hello all.
I want to install MySQL on a RAID mirror drive using two ATA 125GB for the mirror. I know in a webserver config, it's best to put the boot OS on one drive and the shared serving folder on the RAID mirror drive. Under a MySQL server, if I install the OS and MySQL all on the mirror drive ( I can get rid of the standard 80gb drive the computer ships with) are there draw backs or problems with such a config??? (ex. speed)
My config is a Mac Dual Processor G4 1.25 Ghtz running 10.3 with MysQL 4.0.15. both drives are 120GB 7200RM IDE Hitachi Deskstar's.
Thanks. Rick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
