Re: Raid level suggestions for mysql-server

2009-11-02 Thread Michael Dykman
In one of the more effective high-loads shops I have worked in, we deployed RAID 1 for logs and RAID 10 for data. The number of disks we put into those RAID 10's depended on anticipated load of the specific application. We often found ourselves needing additional spindles to meet high I/O needs,

Re: Raid level suggestions for mysql-server

2009-11-01 Thread Per Jessen
Gšötz Reinicke - IT Koordinator wrote: > Hi, > > soon I'll get a SUN X4170 with 8*2,5" SAS 300 GB harddisks. (24 GB > RAM) > > This system could be our new central mysql-server for some > LAMP-systems. (right now about 50 GB mysql data total, roughly 60-70% > reads.) > > What would be a good ra

Raid level suggestions for mysql-server

2009-11-01 Thread Gšötz Reinicke - IT Koordinator
Hi, soon I'll get a SUN X4170 with 8*2,5" SAS 300 GB harddisks. (24 GB RAM) This system could be our new central mysql-server for some LAMP-systems. (right now about 50 GB mysql data total, roughly 60-70% reads.) What would be a good raid-Layout for the server? I was thinking of one large 1+