20 messages in com.mysql.lists.clusterRe: SQL Node Setup Question
FromSent OnAttachments
Burhan Khalid28 Apr 2008 03:45 
ewen fortune28 Apr 2008 04:12 
Burhan Khalid28 Apr 2008 04:59 
ewen fortune28 Apr 2008 05:23 
Burhan Khalid28 Apr 2008 15:07 
ewen fortune29 Apr 2008 00:14 
ewen fortune29 Apr 2008 05:32 
Geert Vanderkelen29 Apr 2008 06:06 
Burhan Khalid29 Apr 2008 06:17 
ewen fortune29 Apr 2008 06:50 
Geert Vanderkelen29 Apr 2008 06:56 
Geert Vanderkelen29 Apr 2008 07:10 
Burhan Khalid29 Apr 2008 07:49 
ewen fortune29 Apr 2008 08:00 
Geert Vanderkelen29 Apr 2008 08:53 
Burhan Khalid30 Apr 2008 01:19 
Jon Stephens30 Apr 2008 03:13 
Burhan Khalid30 Apr 2008 05:13 
ewen fortune30 Apr 2008 05:16 
Burhan Khalid30 Apr 2008 05:52 
Subject:Re: SQL Node Setup Question
From:ewen fortune (ewen@gmail.com)
Date:04/29/2008 08:00:03 AM
List:com.mysql.lists.cluster

Hi Burhan,

Yes, the data nodes continue to function as a cluster even without the management node running. Indeed the management node is only really needed to start the cluster.

Ewen

On Tue, Apr 29, 2008 at 4:49 PM, Burhan Khalid <b.kh@kuwaitnet.net> wrote:

We are having a bit of a discussion on this implementation, and I'm looking for a very clear answer to the following:

1. If the cluster manager is offline, can the nodes replicate data? If I have one manager node, and 3 data nodes; the manager node is dead. There is a load balancer that is forwarding 3306 between the 3 data nodes (which are also SQL nodes); in this scenario, is the database synchronized between the nodes even if the manager is down?

Thanks, Burhan

Geert Vanderkelen wrote:

On Apr 29, 2008, at 15:56 , Geert Vanderkelen wrote:

On Apr 29, 2008, at 15:17 , Burhan Khalid wrote:

Hi Geert:

If my SQL node and my management node are the same physical machine, then:

1. What should I put in /etc/my.cnf for the ndb_connectstring? The same IP that the data nodes are using or localhost?

Should be the same, but using same connectstring everywhere is probably 'nicer'.

Typo! I meant, "Shouldn't be the same", what Ewen said, defaults to localhost, but everywhere the IP from the ndb_mgmd is better/nicer/clearer.