Raid level suggestions for mysql-server

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+0 or 0+1 as 1.2TB would be more than enought.

Or may be I do split things up like this: one raid 1 for the system, one
raid 1 for logfiles, one raid 1+0/0+1 for the database.

Any suggestions?


Thanks and best regards,

Götz
--
Götz Reinicke
IT-Koordinator

Tel. +49 7141 969 420
Fax +49 7141 969 55 420
E-Mail goetz.reinicke@filmakademie.de

Filmakademie Baden-Württemberg GmbH
Akademiehof 10
71638 Ludwigsburg
www.filmakademie.de

Eintragung Amtsgericht Stuttgart HRB 205016
Vorsitzende des Aufsichtsrats:
Prof. Dr. Claudia Hübner
Staatsrätin für Demographischen Wandel und für Senioren im Staatsministerium

Geschäftsführer:
Prof. Thomas Schadt

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Raid level suggestions for mysql-server

Gšötz Reinicke - IT Koordinator wrote:

> Hi,
>=20
> soon I'll get a SUN X4170 with 8*2,5" SAS 300 GB harddisks. (24 GB
> RAM)
>=20
> 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.)
>=20
> What would be a good raid-Layout for the server?
>=20
> I was thinking of one large 1+0 or 0+1 as 1.2TB would be more than
> enought.
>=20
> Or may be I do split things up like this: one raid 1 for the system,
> one raid 1 for logfiles, one raid 1+0/0+1 for the database.
>=20
> Any suggestions?

I have a very similar HP box with 8 drives too - I've got it running on=
e
RAID1 (2x72Gb) for system and one RAID6 (6x146Gb) for data.


/Per Jessen, Zürich


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Raid level suggestions for mysql-server

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, often leaving a lot of unused raw storage space.

The system was usually deployed on a single disk, being more-or-less
static and easily reproducible.. Once you are booted and primed, the
system disk barely gets touched.. all the important stuff is in RAM.

- michael dykman

On Sun, Nov 1, 2009 at 2:42 PM, Per Jessen wrote:
> 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 raid-Layout for the server?
>>
>> I was thinking of one large 1+0 or 0+1 as 1.2TB would be more than
>> enought.
>>
>> Or may be I do split things up like this: one raid 1 for the system,
>> one raid 1 for logfiles, one raid 1+0/0+1 for the database.
>>
>> Any suggestions?
>
> I have a very similar HP box with 8 drives too - I've got it running one
> RAID1 (2x72Gb) for system and one RAID6 (6x146Gb) for data.
>
>
> /Per Jessen, Zürich
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=3Dmdykman=
@gmail.com
>
>



--=20
- michael dykman
- mdykman@gmail.com

"May you live every day of your life."
Jonathan Swift

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg