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.
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 .