HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Server Operation (http://www.howtoforge.com/forums/forumdisplay.php?f=5)
-   -   Problems with MySQL Cluster (Help) (http://www.howtoforge.com/forums/showthread.php?t=41640)

longvnit 8th December 2009 11:30

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.

falko 9th December 2009 14:41

Quote:

Originally Posted by longvnit (Post 212947)
Server 192.168.5.2 & .5.4 can't connect to server cluster management 192.168.1.5

Is that a typo? Do you mean 192.168.1.2 and 192.168.1.4?

longvnit 9th December 2009 17:22

Quote:

Originally Posted by falko (Post 213071)
Is that a typo? Do you mean 192.168.1.2 and 192.168.1.4?


oh yes, i fixed my problems ,
Because i removed /usr/local/mysql/var/mysql-cluster/backup folder,so when Node Server load config from Cluster management server which check does not exist this folder, therefore show error Illegal file system path(Configuration error).

System show good
Code:

Cluster Configuration
---------------------
[ndbd(NDB)] 3 node(s)
id=2 @192.168.1.3 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0, Master)
id=3 @192.168.1.10 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0)
id=4 @192.168.1.2 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.1.5 (mysql-5.1.39 ndb-7.0.9)

[mysqld(API)] 5 node(s)
id=5 @192.168.1.3 (mysql-5.1.39 ndb-7.0.9)
id=6 @192.168.1.2 (mysql-5.1.39 ndb-7.0.9)
id=7 @192.168.1.10 (mysql-5.1.39 ndb-7.0.9)

Thanks for helping me .


All times are GMT +2. The time now is 11:46.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.