Re: sql nodes not connected - problem - Alex Davies - com.mysql.lists.cluster

9 messages in com.mysql.lists.clusterRe: sql nodes not connected - problem

From	Sent On	Attachments
Rosario Pingaro	24 Dec 2005 09:27
Allproducts - James	25 Dec 2005 17:46
Rosario Pingaro	26 Dec 2005 02:48
Alex Davies	26 Dec 2005 03:53
Rosario Pingaro	26 Dec 2005 03:55
Alex Davies	26 Dec 2005 03:59
Jonathan Miller	27 Dec 2005 07:28
Mark Kirkwood	27 Dec 2005 14:18
Doug...@GOV.CA.GOV	27 Dec 2005 16:02

Subject:	Re: sql nodes not connected - problem
From:	Alex Davies (davi...@gmail.com)
Date:	12/26/2005 03:53:19 AM
List:	com.mysql.lists.cluster

You mention that "I have a 4node (2mgm, 2(dbd+sql) setup based on mysql 5.0.17." but you appear to be running MYSQL 4.1 - could this be causing problems? You cant connect a 5 mgm node to a 4.1 cluster.

Alex On 26/12/05, Rosario Pingaro <rpin...@nesec.it> wrote:

I have a working solution about 1mgm node, but when I configure the second mgm node, adding manually the ID for eachnode I got this strange behaviour where the two sql nodes are not able to connect. I have to specify the id because in a two mgm nodes scenario the ID is not given automaticly.

Regards Rosario

Hello Rosario: This is my config file , I just work with one managent nod and 2 sql nod , hope would help you something.

my.cnf [MYSQLD] ndbcluster ndb-connectstring=192.168.0.196 user=root port=3307

[MYSQL_CLUSTER] ndb-connectstring=192.168.0.196

config.ini [NDBD DEFAULT] # Options affecting ndbd processes on all data nodes: NoOfReplicas=2 # Number of replicas DataMemory=80M # How much memory to allocate for data storage IndexMemory=52M # How much memory to allocate for index storage # For DataMemory and IndexMemory, we have used the # default values. Since the "world" database takes up # only about 500KB, this should be more than enough for # this example Cluster setup. [TCP DEFAULT]

[NDB_MGMD] hostname=192.168.0.196 # Hostname or IP address of MGM node datadir=/usr/local/mysql/1/var # Directory for MGM node logfiles

[NDBD] hostname=192.168.0.197 # Hostname or IP address datadir=/usr/local/mysql/1/var # Directory for this data node's datafiles

[NDBD] hostname=192.168.0.198 # Hostname or IP address datadir=/usr/local/mysql/1/var # Directory for this data node's datafiles

[MYSQLD] hostname=192.168.0.197 # Hostname or IP address

[MYSQLD] hostname=192.168.0.198 # Hostname or IP address

show in ndb_mgm Connected to Management Server at: 192.168.0.196:1186 Cluster Configuration

--------------------- [ndbd(NDB)] 2 node(s) id=2 @192.168.0.197 (Version: 4.1.12, Nodegroup: 0, Master) id=3 @192.168.0.198 (Version: 4.1.12, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s) id=1 @192.168.0.196 (Version: 4.1.12)

[mysqld(API)] 2 node(s) id=4 @192.168.0.197 (Version: 4.1.12) id=5 @192.168.0.198 (Version: 4.1.12)

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender immediately by e-mail and delete this e-mail permanently.