Chris McKeever wrote:
Just have two of each type of drive. And if you can only afford two. Just have one mirrored drive. It gets you the integrity and is much faster for random writing and reading than RAID 5.
RAID 5 is the wrong answer. If reliability is a big deal do mirroring. Otherwise get as much memory as you can afford and use any money left over to get the fastest disk drives you can afford. If you have multiple disks, spread things between different drives. OS on one, swap on another, indices on another, data on another, etc.
if you have all those drives, how are you going to mirror? you can
always set up a replication server for data mirroring realtime or do
the hot backup nightly and tar the files...RAID5 will get you back
through a drive failure -
make sure that what ever apps you have running will be easily migrated to making the calls against MySQL - some of the SQL is different (ie LIMIT instead of TOP, no stored procedures, different foreign key relationships, etc..)
sign me... Fed up at the Beach... [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
