Chris McKeever wrote:
>
>>>
>>>
>>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 -
>
>
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.
>
>
>
>>>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...
>>>>info@stripped
>>>>
>>>>--
>>>>MySQL General Mailing List
>>>>For list archives: http://lists.mysql.com/mysql
>>>>To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>
