MySQL Forums
Forum List  »  NDB clusters

Cluster problem
Posted by: Dimitar Dragoev
Date: July 13, 2006 06:40AM

Hi All,
I have following problem when trying to start MySQL Cluster:

I have 1 management node: 192.168.0.1 and two other machines with IPs: .2 and .3 for NDB and MySQL

This is my cluster configuration fail:
[ndbd default]
NoOfReplicas= 2
DataDir= /var/lib/mysql-cluster

[ndb_mgmd default]
DataDir= /var/lib/mysql-cluster

[ndb_mgmd]
Id=1
HostName= 192.168.0.1

[ndbd]
Id= 2
HostName= 192.168.0.2

[ndbd]
Id= 3
HostName= 192.168.0.3

[mysqld]
Id= 4
HostName= 192.168.0.2

[mysqld]
Id= 5
HostName= 192.168.0.3

On other two PCs I add in /etc/my.cnf:
[mysql_cluster]
ndb-connectstring=192.168.0.1

[mysqld]
ndbcluster
ndb-connectstring=192.168.0.1

The problem is that when I start NDBD on 192.168.0.2 it stuck on starting and here what I have in logs:
2006-07-13 15:32:30 [ndbd] INFO -- Version 5.0.22 --
2006-07-13 15:32:30 [ndbd] INFO -- Configuration fetched at 192.168.0.1 port 1186
2006-07-13 15:32:31 [ndbd] INFO -- Start initiated (version 5.0.22)

And this is repeated on management node log:
2006-07-13 14:41:00 [MgmSrvr] INFO -- Node 2: Initial start, waiting for 0000000000000008 to connect, nodes [ all: 000000000000000c connected: 0000000000000004 no-wait: 0000000000000000 ]
2006-07-13 14:41:03 [MgmSrvr] INFO -- Node 2: Initial start, waiting for 0000000000000008 to connect, nodes [ all: 000000000000000c connected: 0000000000000004 no-wait: 0000000000000000 ]
2006-07-13 14:41:06 [MgmSrvr] INFO -- Node 2: Initial start, waiting for 0000000000000008 to connect, nodes [ all: 000000000000000c connected: 0000000000000004 no-wait: 0000000000000000 ]
2006-07-13 14:41:09 [MgmSrvr] INFO -- Node 2: Initial start, waiting for 0000000000000008 to connect, nodes [ all: 000000000000000c connected: 0000000000000004 no-wait: 0000000000000000 ]
2006-07-13 14:41:12 [MgmSrvr] INFO -- Node 2: Initial start, waiting for 0000000000000008 to connect, nodes [ all: 000000000000000c connected: 0000000000000004 no-wait: 0000000000000000 ]
2006-07-13 14:41:15 [MgmSrvr] INFO -- Node 2: Initial start, waiting for 0000000000000008 to connect, nodes [ all: 000000000000000c connected: 0000000000000004 no-wait: 0000000000000000 ]
2006-07-13 14:41:18 [MgmSrvr] INFO -- Node 2: Initial start, waiting for 0000000000000008 to connect, nodes [ all: 000000000000000c connected: 0000000000000004 no-wait: 0000000000000000 ]
2006-07-13 14:41:21 [MgmSrvr] INFO -- Node 2: Initial start, waiting for 0000000000000008 to connect, nodes [ all: 000000000000000c connected: 0000000000000004 no-wait: 0000000000000000 ]
2006-07-13 14:41:24 [MgmSrvr] INFO -- Node 2: Initial start, waiting for 0000000000000008 to connect, nodes [ all: 000000000000000c connected: 0000000000000004 no-wait: 0000000000000000 ]


Also when I start MySQL daemon it fails to connect to management node and all I have is:
060713 15:33:23 mysqld started
060713 15:33:23 InnoDB: Started; log sequence number 0 43655
060713 15:33:33 [Note] /usr/sbin/mysqld-max: ready for connections.
Version: '5.0.22-max-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Experimental (GPL)

On management node I installed:
MySQL-ndb-management-5.0.22-0.glibc23.i386.rpm

And for other two I have:
MySQL-server-5.0.22-0.glibc23.i386.rpm
MySQL-Max-5.0.22-0.glibc23.i386.rpm
MySQL-ndb-storage-5.0.22-0.glibc23.i386.rpm
MySQL-client-5.0.22-0.glibc23.i386.rpm

Can someone help me to create MySQL cluster?

Options: ReplyQuote


Subject
Views
Written By
Posted
Cluster problem
2324
July 13, 2006 06:40AM
1205
July 18, 2006 06:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.