Re: I don't see MySQLd on NDB_MGM

From: Anatoly Pidruchny <apidruchny(at)newxt.com>
Date: Fri Jul 27 2007 - 21:29:51 EDT

What is your /etc/my.cnf file?
Hint: there should be at least the following lines in the [MYSQLD] section:

ndbcluster                      # run NDB engine

ndb-connectstring=192.168.0.6 # location of MGM node

Also this line in the [MYSQL_CLUSTER] section: ndb-connectstring=192.168.0.6 # location of MGM node

Anatoly.
> I don't see mysqld as connected on ndb_mgm. But mysqld is running on machine.
> Any suggestions what could be the problem may be? I have shutdown the
> firewall and disabled the SELinux on my local network. I am running
> MySQL 5.1.20 on FC 6.
>
> thnx.
>
> [root@localhost me]# mysqld_safe --user=mysql&
> [1] 3223
> [root@localhost me]# touch: missing file operand
> Try `touch --help' for more information.
> chown: missing operand after `mysql'
> Try `chown --help' for more information.
> 070727 11:26:38 mysqld_safe Starting mysqld daemon with databases from
> /var/lib/mysql
>
>
> [root@localhost me]# netstat -l -p -t
> Active Internet connections (only servers)
> Proto Recv-Q Send-Q Local Address Foreign Address
> State PID/Program name
> tcp 0 0 localhost:2208 *:*
> LISTEN 2169/hpiod
> tcp 0 0 *:mysql *:*
> LISTEN 3274/mysqld
> tcp 0 0 192.168.0.5:46445 *:*
> LISTEN 3377/ndbd
> tcp 0 0 *:877 *:*
> LISTEN 1967/rpc.statd
> tcp 0 0 *:sunrpc *:*
> LISTEN 1946/portmap
> tcp 0 0 192.168.0.5:55351 *:*
> LISTEN 3377/ndbd
> tcp 0 0 localhost:ipp *:*
> LISTEN 2186/cupsd
> tcp 0 0 localhost:smtp *:*
> LISTEN 2305/sendmail: acce
> tcp 0 0 192.168.0.5:59354 *:*
> LISTEN 3377/ndbd
> tcp 0 0 localhost:2207 *:*
> LISTEN 2174/python
> tcp 0 0 *:ssh *:*
> LISTEN 2200/sshd
> [root@localhost me]#
>
>
>
> [root@localhost me]# ps -ef| grep mysql
> root 3223 3031 0 11:26 pts/1 00:00:00 /bin/sh
> /usr/bin/mysqld_safe --user=mysql
> mysql 3274 3223 0 11:26 pts/1 00:00:00 /usr/sbin/mysqld
> --basedir=/ --datadir=/var/lib/mysql --user=mysql
> --pid-file=/var/lib/mysql/localhost.localdomain.pid
> root 3277 3223 0 11:26 pts/1 00:00:00 logger -i -t mysqld -p
> daemon.error
> root 3436 3031 0 11:33 pts/1 00:00:00 grep mysql
> [root@localhost me]#
>
>
> [root@localhost mysql-cluster]# ls
> [root@localhost mysql-cluster]#
>
> [root@localhost mysql]# ls -lrt
> total 20552
> drwxrwxr-x 2 mysql mysql 4096 Jul 9 21:33 test
> drwx--x--x 2 mysql mysql 4096 Jul 9 21:33 mysql
> -rw-rw---- 1 mysql mysql 5242880 Jul 27 11:22 ib_logfile1
> -rw-rw---- 1 mysql mysql 10485760 Jul 27 11:26 ibdata1
> -rw-r--r-- 1 root root 5 Jul 27 11:30 ndb_2.pid
> drwxr-x--- 2 root root 4096 Jul 27 11:30 ndb_2_fs
> -rw-r--r-- 1 root root 2049 Jul 27 11:30 ndb_2_out.log
> -rw-rw---- 1 mysql mysql 5242880 Jul 27 11:48 ib_logfile0
> srwxrwxrwx 1 mysql mysql 0 Jul 27 11:48 mysql.sock
> -rw-rw---- 1 mysql mysql 5 Jul 27 11:48 localhost.localdomain.pid
> [root@localhost mysql]#
>
>
> [root@localhost mysql-cluster]# ndb_mgm -c 192.168.0.6
> -- NDB Cluster -- Management Client --
> ndb_mgm> show
> Connected to Management Server at: 192.168.0.6:1186
> Cluster Configuration
> ---------------------
> [ndbd(NDB)] 2 node(s)
> id=2 @192.168.0.5 (Version: 5.1.20, starting, Nodegroup: 0)
> id=3 (not connected, accepting connect from 192.168.0.2)
>
> [ndb_mgmd(MGM)] 1 node(s)
> id=1 @192.168.0.6 (Version: 5.1.20)
>
> [mysqld(API)] 2 node(s)
> id=4 (not connected, accepting connect from any host)
> id=5 (not connected, accepting connect from any host)
>
> ndb_mgm>
>
>

-- 
MySQL Cluster Mailing List
For list archives: 
http://lists.mysql.com/cluster
To unsubscribe:    
http://lists.mysql.com/cluster?unsub=lists@pantek.com

Received on Fri Jul 27 21:30:17 2007