RE: Very HA Mysql Cluster

From: Fabien FAYE <ffaye(at)dclux.com>
Date: Wed Sep 12 2007 - 18:27:31 EDT

Hi,

Yes the solution 4 is greet but only with 2 switch in the case of on switch going down the second one is here. We need also to have to link between the both rack of the cluster.

With only 1 switch the risk of down is increased.

Best regards

---

Fabien FAYE
Network & System Engineer
Email: ffaye@dclux.com
Datacenter Luxembourg S.A.
Tel: +352-261916-1
Fax: +352-26202996
http://www.dclux.com

---

-----Original Message-----
From: Mikael Ronström [mailto:mikael@mysql.com] Sent: Wednesday, September 12, 2007 6:48 PM To: Fabien FAYE
Cc: 'cluster@lists.mysql.com'
Subject: Re: Very HA Mysql Cluster

Hi,
Solution 4 seems like the best but 2 switches per rack seems an overkill, remember that you can
actually lose a rack and still continue. So even with single switch per rack you have no single
point of failure. Also Ethernet bonding is probably not necessary in that case.

Interesting configuration.

Rgrds Mikael

12 sep 2007 kl. 16.53 skrev Fabien FAYE:

> Hi,
>
> I need to have a very important availability on mysql cluster but I
> have questions about which solution is better.
>
> In this case, I have 2 mysql Api server and 2 or 4 NDB with 2 manager.
>
> Solution 1:
>
> My first idea is to have the mysql cluster in the same rack on the
> same switch.
>
> But if the switch going down or if i have no more power on this
> rack over the UPS time, the cluster going Down.
>
> Solution 2:
>
> Mysql cluster with 2 ndb servers, 2 manager server and 2 mysql
> servers on 2 switches, with bonding on 2 Ethernet port.
> But if I have no more power on the rack it is the same.
>
> Solution 3:
>
> Mysql cluster with 2 ndb servers, 2 manager servers and 2 mysql
> servers on 4 switches, with bonding on 2 Ethernet port, split in 2
> racks.
>
> But if I have no more power in 1 rack, split brain and a big risk
> of crash of the cluster.
>
> Solution 4:
>
> Mysql cluster with 2 ndb servers and 2 mysql servers on 4 switches,
> with bonding on 2 Ethernet port, split in 2 racks and external
> manager in a third rack with 2 switches.
>
> In this case I can have a full cluster operational
>
> Solution 5:
>
> Mysql cluster with 4 ndb servers, 2 manager servers and 2 mysql
> servers on 4 switches, with bonding on 2 Ethernet port.
>
> With NDB1 Group1 in rack 1
> With NDB2 Group1 in rack 2
>
> With NDB1 Group2 in rack 1
> With NDB2 Group2 in rack 2
>
> And in this case I have a full cluster operational.
>
> For you which solution is better?
>
> I hope my explanation is clear, but for me the solution 4 or 5 is
> the good solution but a mix of 4 and 5 is possible also.
>
> Best regards.
> --------------------------------------------
> Fabien FAYE
> Network & System Engineer
> Email: ffaye@dclux.com<mailto:ffaye@dclux.com>
> Datacenter Luxembourg S.A.
> Tel: +352-261916-1
> Fax: +352-26202996
> http://www.dclux.com<http://www.dclux.com/>
> --------------------------------------------
>
>
> ________________________________
> --------------------------------------------------------
>
> This e-mail and any attached files are confidential and intended
> solely for the use of the individual or entity to whom they are
> addressed. If you have received this e-mail by mistake, please
> notify the sender immediately and delete it from your system. You
> must not copy the message or disclose its contents to anyone.
>
> --------------------------------------------------------

---

This e-mail and any attached files are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail by mistake, please notify the sender immediately and delete it from your system. You must not copy the message or disclose its contents to anyone.

---

-- 
MySQL Cluster Mailing List
For list archives: 
http://lists.mysql.com/cluster
To unsubscribe:    
http://lists.mysql.com/cluster?unsub=lists@pantek.com

Received on Wed Sep 12 18:28:11 2007