Cluster problem
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?
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.