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:Geert Vanderkelen (gee@mysql.com)
Date:04/29/2008 06:56:05 AM
List:com.mysql.lists.cluster

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'.

2. Do I need to add a [NDBD] entry in config.ini and have HostName point to the same server again? Ie:

You mean [MYSQLD] I guess?

[NDBD DEFAULT] NoOfReplicas=2 [MYSQLD DEFAULT] [NDB_MGMD DEFAULT] [TCP DEFAULT] [NDB_MGMD] HostName=10.8.106.134 [NDBD] HostName=10.12.38.72 DataDir=/var/lib/mysql-cluster [NDBD] HostName=10.23.38.70 DataDir=/var/lib/mysql-cluster [MYSQLD] [MYSQLD]

(should I add another node here?) [MYSQLD] HostName=10.8.106.134

You can add a few more [MYSQLD] or [API], without Hostname. Or you can leave the Hostname. The SQL Node with nodeid 6 will then only be allowed to run on host with IP 10.8.106.134, in your example.

Cheers,

Geert

-- Geert Vanderkelen, Senior Support Engineer MySQL GmbH, Germany, www.mysql.com