> -----Ursprüngliche Nachricht-----
> Von: Götz Reinicke - IT-Koordinator
> Gesendet: Mittwoch, 25. November 2009 12:05
> An: mysql@stripped
> Betreff: Virtual servers, Raid 10 or Raid 01 - your opinions?
> I do get two new Sun Fire X4170 servers with 8 SAS 300GB HDs, 24 GB RAM
> 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
Concl.: RAID 10 is a good choice!
> Also I was thinking, to use one RAID 1 for the virtualisation-system
> 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
mount SECOND_RAID10 /data/mysql_slave
ifconfig bond0:0|eth1:0 virtualip netmask ....
ifconfig bond0:1|eth1:1 virtualip1 netmask ....
datadir = /data/mysql_master
data-dir = /data/mysql_slave
Is this what you are searching for?