From: Johan De Meersman
Date: November 25 2009 11:46am
Subject: Re: Virtual servers, Raid 10 or Raid 01 - your opinions?
List-Archive: http://lists.mysql.com/mysql/219507
Message-Id: <aaba5c100911250346k785fd5eao91b152ad624f1e7d@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=0016e64603ea1d17db0479309dc5

--0016e64603ea1d17db0479309dc5
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Decidedly RAID 10 - that is, a concatenation of mirrors. You get a lot more
redundancy that way.

Raid 01:

[A+B+C+D]
[E+F+G+H]

Here, a single disk lost in each concatenation (so two in total) loses you
the set. Probability is 1/8 * 4/7 (0.0714).

Raid 10:

[A] [B] [C] [D]
[E] [F] [G] [H]

Here, you will only lose your data if the exact two disks that make up a
single mirror die. Probability is 1/8 * 1/7 (0.0178).



On Wed, Nov 25, 2009 at 12:04 PM, G=F6tz Reinicke - IT-Koordinator <
goetz.reinicke@stripped> wrote:

> Hi,
>
> I do get two new Sun Fire X4170 servers with 8 SAS 300GB HDs, 24 GB RAM
> each.
>
> Right now, we do not have a lot of data in our databases (5 small LAMP
> servers), which should be consolidated.
>
> (The second Sun Fire X4170 will be the Webserver-Sun, the DB-Traffic
> will have his own gbit switch (Webserver-Sun <-> MySQL-Sun) )
>
> There are more reads than writes.
>
> To simplify matters, I'd like to use virtual MySQL-Servers (Master and
> Slave) on the sun and use one large raid.
>
> Also I was thinking, to use one RAID 1 for the virtualisation-system and
> the other six harddisks for the virtual servers.
>
> What RAID would be the better choice? 10 or 01?
>
> What do you think?
>
>
> Thanks for any suggestions and best regards,
>
>        G=F6tz
> --
> G=F6tz Reinicke
> IT-Koordinator
>
> Tel. +49 7141 969 420
> Fax  +49 7141 969 55 420
> E-Mail goetz.reinicke@stripped
>
> Filmakademie Baden-W=FCrttemberg GmbH
> Akademiehof 10
> 71638 Ludwigsburg
> www.filmakademie.de
>
> Eintragung Amtsgericht Stuttgart HRB 205016
> Vorsitzende des Aufsichtsrats:
> Prof. Dr. Claudia H=FCbner
> Staatsr=E4tin f=FCr Demographischen Wandel und f=FCr Senioren im
> Staatsministerium
>
> Gesch=E4ftsf=FChrer:
> Prof. Thomas Schadt
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=3Dvegivamp@stripped=
e
>
>

--0016e64603ea1d17db0479309dc5--