View Single Post
  #1  
Old 8th December 2009, 11:30
longvnit longvnit is offline
Junior Member
 
Join Date: Mar 2009
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Cool Problems with MySQL Cluster (Help)

Hi ,
I am tring to install one MySQL Cluster ,
But i have some problems,

Network topologies includes :
a . 01 Server cluster management IP : 192.168.1.5
b . 03 Server Cluster Node : IP 192.168.1.2 -> 192.168.1.4

Code:
File /usr/local/mysql/var/mysql-cluster/config.ini
Code:
[NDBD DEFAULT]
NoOfReplicas=3
DataMemory=80M    # How much memory to allocate for data storage
IndexMemory=18M   # 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.
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
# Section for the cluster management node
[NDB_MGMD]
NodeId = 1
# IP address of the management node (this system)
HostName=192.168.1.5
# Section for the storage nodes
[NDBD]
NodeId = 2
# IP address of the first storage node
HostName=192.168.1.3
DataDir=/usr/local/mysql/var/mysql-cluster
BackupDataDir=/usr/local/mysql/var/mysql-cluster/backup
DataMemory=100M
[NDBD]
NodeId = 3
# IP address of the second storage node
HostName=192.168.1.4
DataDir=/usr/local/mysql/var/mysql-cluster
BackupDataDir=/usr/local/mysql/var/mysql-cluster/backup
DataMemory=100M
 
[NDBD]
NodeId = 4
# IP address of the second storage node
HostName=192.168.1.2
DataDir=/usr/local/mysql/var/mysql-cluster
BackupDataDir=/usr/local/mysql/var/mysql-cluster/backup
DataMemory=100M
 
 
 
# one [MYSQLD] per storage node
[MYSQLD]
NodeId = 5
[MYSQLD]
NodeId = 6
[MYSQLD]
NodeId = 7
Code:
File /etc/my.cnf
Code:
[client]
socket=/tmp/mysql.sock
[mysqld]
ndbcluster
ndb-connectstring=192.168.1.5
default-storage-engine=NDBCLUSTER
[mysql_cluster]
ndb-connectstring=192.168.1.5
I have some problems bellow :

1. not connected, accepting connect from any hosts
I don't know why that ?

2. I run ndbd on three servers then only server 192.168.1.3 have connect into server Cluster Management , although three server is same.
Code:
[ndbd(NDB)]     3 node(s)
id=2    @192.168.1.3  (mysql-5.1.39 ndb-7.0.9, starting, Nodegroup: 0)
id=3 (not connected, accepting connect from 192.168.1.4)
id=4 (not connected, accepting connect from 192.168.1.2)
 
[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.1.5  (mysql-5.1.39 ndb-7.0.9)
 
[mysqld(API)]   3 node(s)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)
Server 192.168.5.2 & .5.4 can't connect to server cluster management 192.168.1.5

When i run command : ndbd on server 192.168.1.2 or .4 then server cluster management show :

Node 4: Forced node shutdown completed. Occured during startphase 0. Caused by error 2805: 'Illegal file system path(Configuration error). Permanent error, external action needed'.

Please help me slove these problems.
Thanks so much.
Reply With Quote
Sponsored Links