e 39: [tcp] PortNumber is depricated, use Port used for this transporter instead
2013-11-04 23:46:13 [MgmtSrvr] INFO -- Reading cluster configuration from '/etc/ndb-config.ini'
2013-11-04 23:46:13 [MgmtSrvr] WARNING -- at line 39: [tcp] PortNumber is depricated, use Port used for this transporter instead
--确定进程和端口号
[root@mgmd local]# ps -ef | grep mgm | grep -v grep
root 1070 1 0 23:46 00:00:00 /usr/local/mysql/bin/ndb_mgmd -f /etc/ndb-config.ini
[root@mgmd local]# netstat -langput | grep mgm
tcp 0 0 0.0.0.0:1186 0.0.0.0:* LISTEN 1070/ndb_mgmd
tcp 0 0 127.0.0.1:1186 127.0.0.1:55252 ESTABLISHED 1070/ndb_mgmd
tcp 0 0 127.0.0.1:55252 127.0.0.1:1186 ESTABLISHED 1070/ndb_mgmd
[root@mgmd local]# /usr/local/mysql/bin/ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 (not connected, accepting connect from 192.168.1.14)
id=3 (not connected, accepting connect from 192.168.1.15)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.1.11 (mysql-5.1.44 ndb-7.1.4)
[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from 192.168.1.12)
id=5 (not connected, accepting connect from 192.168.1.13)
4.6 存储节点搭建
第一步，ndb01添加mysql组和用户
[root@ndb01 ~]# groupadd -g 27 mysql
[root@ndb01 ~]# useradd -u 27 -g 27 -r -M -s /sbin/nologin mysql
[root@ndb01 ~]# id mysql
uid=27(mysql) gid=27(mysql) groups=27(mysql)
[root@ndb01 ~]# cd /opt/
第二步，ndb01解压二进制包
[root@ndb01 opt]# tar -xvf mysql-cluster-gpl-7.1.4b-linux-x86_64-glibc23.tar.gz -C /usr/local/
[root@ndb01 opt]# cd /usr/local/
第三步，ndb01重命名安装目录，修改所有者和所属组
[root@ndb01 local]# mv mysql-cluster-gpl-7.1.4b-linux-x86_64-glibc23/ mysql
[root@ndb01 local]# chown mysql. mysql/ -R
[root@ndb01 local]# ll -d mysql/
drwxr-xr-x 13 mysql mysql 4096 Jun 11 2010 mysql/
[root@ndb01 local]# ll mysql/
total 244
drwxr-xr-x 2 mysql mysql 4096 Jun 11 2010 bin
-rw-r--r-- 1 mysql mysql 19071 Jun 11 2010 COPYING
drwxr-x--- 4 mysql mysql 4096 Jun 11 2010 data
drwxr-xr-x 2 mysql mysql 4096 Jun 11 2010 docs
-rw-r--r-- 1 mysql mysql 5139 Jun 11 2010 EXCEPTIONS-CLIENT
drwxr-xr-x 3 mysql mysql 4096 Jun 11 2010 include
-rw-r--r-- 1 mysql mysql 9748 Jun 11 2010 INSTALL-BINARY
drwxr-xr-x 3 mysql mysql 4096 Jun 11 2010 lib
drwxr-xr-x 4 mysql mysql 4096 Jun 11 2010 man
drwxr-xr-x 10 mysql mysql 4096 Jun 11 2010 mysql-test
-rw-r--r-- 1 mysql mysql 161295 Jun 11 2010 README
drwxr-xr-x 2 mysql mysql 4096 Jun 11 2010 scripts
drwxr-xr-x 28 mysql mysql 4096 Jun 11 2010 share
drwxr-xr-x 5 mysql mysql 4096 Jun 11 2010 sql-bench
drwxr-xr-x 2 mysql mysql 4096 Jun 11 2010 support-files
第四步，ndb01进入mysql目录，拷贝模板文件，修改该文件，内容如下
[root@ndb01 local]# cd mysql/
[root@ndb01 mysql]# cp support-files/my-medium.cnf /etc/my.cnf
cp: overwrite `/etc/my.cnf' y
[root@ndb01 mysql]# vim /etc/my.cnf
[root@ndb01 mysql]# grep "^#\|^$" /etc/my.cnf -v
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log-bin=mysql-bin
binlog_format=mixed
server-id = 1
[mysqldump]
quick
ma