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) > > Thanks. > Rick
There are pro's and con's to either setup: - The more volumes you have (e.g. both an 80GB and a mirrored 125GB volume), the more opportunity you have to balance overall system IO and get the best performance. Mind you, that will take some tuning and understanding what portions of your system cause IO (e.g Operating system code, versus MySQL code, swap and actual read/write of the database data). - Putting your OS on a unmirrored volume is more risky than having it on the RAID 1 volume. Assuming its not a super-high performance situation, I would put everything on the RAID 1 volume. If its really high performance, you need an altogether different disk setup anyway. Hope this helps - Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
