Running large DB's on FreeBSD

[Peter Jeremy]

On Tue, 2006-Oct-24 02:21:06 +0200, Ronald Klop wrote:
>>On Oct 23, 2006, at 4:44 PM, Mike Jakubik wrote:
>>>advanced features, but if they are not used, then what is the  
>>>advantage? (I really like the InnooDB storage in MySQL)

One nice thing about MySQL is the plethora of backends - you can
pick the backend to suit the type of data and access methods.

>Example: writing 1 bit on 1 disk needs to read some info from all disks to  
>recalculate the parity. So this doesn't scale very well.

Any sane RAID-5 implementation will regenerate the parity by
new_parity = old_parity XOR old_data XOR new_data
Though this still turns a single write into 2 reads and 2 writes.

Basically: Don't use RAID-5.

-- 
Peter Jeremy
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-stable/attachments/20061024/8ef9cf82/attachment.pgp