4 messages in com.mysql.lists.clusterRe: recognize between network partiti...
FromSent OnAttachments
Kenji HIROHAMA22 Apr 2008 03:15 
Jonathan Miller22 Apr 2008 16:15 
Anatoly Pidruchny22 Apr 2008 21:42 
Anatoly Pidruchny22 Apr 2008 21:58 
Subject:Re: recognize between network partition and node failure
From:Jonathan Miller (jmil@mysql.com)
Date:04/22/2008 04:15:10 PM
List:com.mysql.lists.cluster

Hi,

IF there is no arbitrator when your 2 data nodes go down, the whole cluster will go down because there is no process to do the arbitration.

If you take the 2 data nodes down first, then the management node, the other 2 nodes will stay up.

/Jeb

Kenji HIROHAMA wrote:

Hello Jonathan,

If so, MySQL Cluster entirely go down when only one management node is down and two data node go down?

We expect two data node still work in that case.

Thanks, Kenji

On Tue, Apr 22, 2008 at 10:59 PM, Jonathan Miller <jmil@mysql.com> wrote:

Hi,

In any case that the Data Nodes can not reach the arbitrator such as in e going down, then all will shutdown as a safe guard.

-- Best wishes, /Jeb

Jonathan Miller Cluster Lead QA Developer Certified Cluster Database Administrator Sun Microsystems / MySQL Austin, Texas US www.mysql.com www.sun.com

I'm Certified, are you? http://www.mysql.com/certification/index.html

Kenji HIROHAMA wrote:

Hello,

I perhaps asked someone in the past, but would like to ask to make sure.

Let's say; there are five servers, named A, B, C, D, and E

one data node are running on each server, A, B, C, and D one management node is runnning on one server, E

If network fails and MySQL Cluster split into two parts, such as, "A, B" and "C, D, E".

Then, "A, B" will go down because they can not reach Arbitrator.

Then, my question is, if "C, D, E" go down at the exactlly same time, "A, B" wil go down?

Or, still "A, B" keep working?

In my understanding, if some of data node go down exactlly at the same time, they are treated as network failure.

Hope someone can answer.

Thanks, Kenji

-- Best wishes, /Jeb

Jonathan Miller Cluster Lead QA Developer Certified Cluster Database Administrator Sun Microsystems / MySQL Austin, Texas US www.mysql.com www.sun.com

I'm Certified, are you? http://www.mysql.com/certification/index.html