Hello All,

We are trying to install the MYSQL Cluster. During the installation, at the initial startup step, we encountered an issue that the MySQL Server is not getting connected to the management node. We have this 4 server setup as per the minimum requirement specified in the MySQL cluster setup ( 2 data nodes, 1 MGM and 1 Server). We have installed the binary files and rpm's in the data nodes and server and MGM. Now at the startup stage, when we issue the command ndb_mgm command pver the management node, we got the following output

ndb_mgm> SHOW

Cluster Configuration

---------------------

[ndbd(NDB)] 2 node(s)

id=2 @172.31.22.80 (Version: 5.1.15, starting, Nodegroup: 0)

id=3 @172.31.22.81 (Version: 5.1.15, starting, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)

id=1 (Version: 5.1.15)

[mysqld(API)] 1 node(s)

id=4 (not connected, accepting connect from 172.31.22.79)

Here id=4 which is the server is not getting connected. So, please help us through with this startup process. Below is the process for the starting up the MySQL process which we did

[root@mysqlserver ~]# cd /usr/local/mysql

[root@mysqlserver mysql]# bin/mysqld &

[1] 2951

[root@mysqlserver mysql]# 070223 12:44:09 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

070223 12:44:09 [ERROR] Aborting

070223 12:44:09 [Note] bin/mysqld: Shutdown complete

[1]+ Exit 1 bin/mysqld

[root@mysqlserver mysql]# ps -ef | grep mysql

root 2956 2919 0 12:44 pts/1 00:00:00 grep mysql

Please provide your input.Thanks!

Best,

Sri