I have setup a mysql cluster on my network. The problem I am having is this, when I use ndb_mgm to show my nodes, I get this error. [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) When I try to start mysql.server it always says. Starting MySQL................................... [FAILED] I have searched everywhere I could think of to find a log as to why it has failed, and I havent found anything. ndbd connects fine to the manager, but for some reason I just cant get mysql to start. Can someone give me a hand with it, it is getting frustrating. Here is my my.cnf and my config.ini files. my.cnf -- # enable ndbcluster storage engine, and provide connectstring for # management server host (default port is 1186) [mysqld] ndbcluster ndb-connectstring=192.168.10.2 # provide connectstring for management server host (default port: 1186) [ndbd] connect-string=192.168.10.2 # provide connectstring for management server host (default port: 1186) [ndb_mgm] connect-string=192.168.10.2 # provide location of cluster configuration file [ndb_mgmd] config-file=/var/lib/mysql-cluster config.ini [NDBD DEFAULT] NoOfReplicas=3 [MYSQLD DEFAULT] [NDB_MGMD DEFAULT] [TCP DEFAULT] # Section for the cluster management node [NDB_MGMD] # IP address of the management node (this system) HostName=192.168.10.2 # Section for the storage nodes [NDBD] # IP address of the first storage node HostName=192.168.10.3 DataDir= /var/lib/mysql-cluster # Section for the storage nodes [NDBD] # IP address of the second storage node HostName=192.168.10.4 DataDir= /var/lib/mysql-cluster # Section for the storage nodes [NDBD] # IP address of the third storage node HostName=192.168.10.5 DataDir= /var/lib/mysql-cluster # one [MYSQLD] per storage node [MYSQLD] [MYSQLD] [MYSQLD]
