Virtual servers, Raid 10 or Raid 01 - your opinions?

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.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: Virtual servers, Raid 10 or Raid 01 - your opinions?

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

Obviously raid 10 would be better choice!.

Recommended for safety and performance.

Thanks,
Krishna Ch. Prajapati


On Wed, Nov 25, 2009 at 4:34 PM, Götz Reinicke - IT-Koordinator <
goetz.reinicke@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.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=3Dprajapatikc@gmail.com
>
>

--000e0cd312c6e7384d0479307ad8--

Re: Virtual servers, Raid 10 or Raid 01 - your opinions?

--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ötz Reinicke - IT-Koordinator <
goetz.reinicke@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.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=3Dvegivamp@tuxera.b=
e
>
>

--0016e64603ea1d17db0479309dc5--

AW: Virtual servers, Raid 10 or Raid 01 - your opinions?

> -----Ursprüngliche Nachricht-----
> Von: Götz Reinicke - IT-Koordinator
> [mailto:goetz.reinicke@filmakademie.de]
> Gesendet: Mittwoch, 25. November 2009 12:05
> An: mysql@lists.mysql.com
> Betreff: Virtual servers, Raid 10 or Raid 01 - your opinions?
>=20
> Hi,

Hi,
=20
> I do get two new Sun Fire X4170 servers with 8 SAS 300GB HDs, 24 GB =
RAM
> each.
>=20
> Right now, we do not have a lot of data in our databases (5 small LAMP
> servers), which should be consolidated.
>=20
> (The second Sun Fire X4170 will be the Webserver-Sun, the DB-Traffic
> will have his own gbit switch (Webserver-Sun <-> MySQL-Sun) )
>=20
> There are more reads than writes.
>=20
> To simplify matters, I'd like to use virtual MySQL-Servers (Master and
> Slave) on the sun and use one large raid.

Putting the question a bit higher for better understanding.
> What RAID would be the better choice? 10 or 01?

Generally RAID 10 is more robust and fault tolerant. Some things =
depending on
the controller if it's smart or not. But rebuilding the raid in case of =
an error
is much faster with RAID10.

If you want to know more read
http://www.pcguide.com/ref/hdd/perf/raid/levels/multXY-c.htm l

Concl.: RAID 10 is a good choice!
=20
> Also I was thinking, to use one RAID 1 for the virtualisation-system
> and
> the other six harddisks for the virtual servers.

It's not fully clear to me what you mean with virtual MySQL-Servers.

You should buy 2 * 73k 15RPM for the OS to have the mysql data =
separated. If
this is not practical/possible you have to put the os and mysqldata =
together.
Not nice, but well. Nothing is perfect ;)

2 RAID10 with 4*300GB. ~ 600GB cap. each

mount FIRST_RAID10 /data/mysql_master=20
mount SECOND_RAID10 /data/mysql_slave

ifconfig bond0:0|eth1:0 virtualip netmask ....
ifconfig bond0:1|eth1:1 virtualip1 netmask ....

/etc/my.cnf

[mysqld101]
bind-address virtualip1
datadir =3D /data/mysql_master
....

[mysqld102]
bind-address virtualip2
data-dir =3D /data/mysql_slave

Is this what you are searching for?

HTH!

Regards
Majk

--
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: AW: Virtual servers, Raid 10 or Raid 01 - your opinions?

Majk.Skoric@eventim.de schrieb:
>> -----Ursprüngliche Nachricht-----
>> Von: Götz Reinicke - IT-Koordinator
>> [mailto:goetz.reinicke@filmakademie.de]
>> Gesendet: Mittwoch, 25. November 2009 12:05
>> An: mysql@lists.mysql.com
>> Betreff: Virtual servers, Raid 10 or Raid 01 - your opinions?
>>
>> Hi,
>
> 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.
>
> Putting the question a bit higher for better understanding.
>> What RAID would be the better choice? 10 or 01?
>
> Generally RAID 10 is more robust and fault tolerant. Some things depending on
> the controller if it's smart or not. But rebuilding the raid in case of an error
> is much faster with RAID10.
>
> If you want to know more read
> http://www.pcguide.com/ref/hdd/perf/raid/levels/multXY-c.htm l
>
> Concl.: RAID 10 is a good choice!

Thanks.

>> Also I was thinking, to use one RAID 1 for the virtualisation-system
>> and
>> the other six harddisks for the virtual servers.
>
> It's not fully clear to me what you mean with virtual MySQL-Servers.

I'll install Citrix Xen Server and than two or more virtual Redhat EL /
Centos/ .... Servers on one SUN Fire server. (Next year I'll get some
more physical servers for clustering/failover/loadbalance)

So I'll use two disks for the xen server software and one raid 10 for
the virtual machines.

>
> HTH!

It did. Thanks.

/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: AW: Virtual servers, Raid 10 or Raid 01 - your opinions?

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

I'm not really clear on what you hope to accomplish by putting two virtual
servers on the same host ?



On Wed, Nov 25, 2009 at 1:35 PM, Götz Reinicke - IT-Koordinator <
goetz.reinicke@filmakademie.de> wrote:

> Majk.Skoric@eventim.de schrieb:
> >> -----Ursprüngliche Nachricht-----
> >> Von: Götz Reinicke - IT-Koordinator
> >> [mailto:goetz.reinicke@filmakademie.de]
> >> Gesendet: Mittwoch, 25. November 2009 12:05
> >> An: mysql@lists.mysql.com
> >> Betreff: Virtual servers, Raid 10 or Raid 01 - your opinions?
> >>
> >> Hi,
> >
> > Hi,
> >
> >> I do get two new Sun Fire X4170 servers with 8 SAS 300GB HDs, 24 GB RA=
M
> >> 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.
> >
> > Putting the question a bit higher for better understanding.
> >> What RAID would be the better choice? 10 or 01?
> >
> > Generally RAID 10 is more robust and fault tolerant. Some things
> depending on
> > the controller if it's smart or not. But rebuilding the raid in case of
> an error
> > is much faster with RAID10.
> >
> > If you want to know more read
> > http://www.pcguide.com/ref/hdd/perf/raid/levels/multXY-c.htm l
> >
> > Concl.: RAID 10 is a good choice!
>
> Thanks.
>
> >> Also I was thinking, to use one RAID 1 for the virtualisation-system
> >> and
> >> the other six harddisks for the virtual servers.
> >
> > It's not fully clear to me what you mean with virtual MySQL-Servers.
>
> I'll install Citrix Xen Server and than two or more virtual Redhat EL /
> Centos/ .... Servers on one SUN Fire server. (Next year I'll get some
> more physical servers for clustering/failover/loadbalance)
>
> So I'll use two disks for the xen server software and one raid 10 for
> the virtual machines.
>
> >
> > HTH!
>
> It did. Thanks.
>
> /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=3Dvegivamp@tuxera.b=
e
>
>

--00151774051c508b570479329b68--