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ötz Reinicke - IT-Koordinator < goetz.reini...@filmakademie.de> 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ötz > -- > Götz Reinicke > IT-Koordinator > > Tel. +49 7141 969 420 > Fax +49 7141 969 55 420 > E-Mail goetz.reini...@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=vegiv...@tuxera.be > >
