HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

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.