00:0C:29:0F:1A:09
inet addr:192.168.1.14 Bcast:192.168.1.255 Mask:255.255.255.0
[root@ndb02 ~]# ifconfig | grep eth -A1
eth0 Link encap:Ethernet HWaddr 00:0C:29:77:CB:2F
inet addr:192.168.1.15 Bcast:192.168.1.255 Mask:255.255.255.0
4.5 管理节点搭建
第一步，添加mysql组和用户
[root@mgmd opt]# groupadd -g 27 mysql
[root@mgmd opt]# useradd -u 27 -g 27 -r -M -s /sbin/nologin mysql
[root@mgmd opt]# id mysql
uid=27(mysql) gid=27(mysql) groups=27(mysql)
第二步，解压二进制包
[root@mgmd opt]# tar -xvf mysql-cluster-gpl-7.1.4b-linux-x86_64-glibc23.tar.gz -C /usr/local/
[root@mgmd opt]# cd /usr/local/
第三步，重命名安装目录，修改所有者和所属组
[root@mgmd local]# mv mysql-cluster-gpl-7.1.4b-linux-x86_64-glibc23/ mysql
[root@mgmd local]# chown mysql. mysql/ -R
[root@mgmd local]# ll mysql/ -d
drwxr-xr-x 13 mysql mysql 4096 Jun 11 2010 mysql/
[root@mgmd 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
第四步，拷贝配置文件，编辑该文件，内容如下
[root@mgmd local]# cp /usr/local/mysql/support-files/ndb-config-2-node.ini /etc/ndb-config.ini
[root@mgmd local]# vim /etc/ndb-config.ini
[root@mgmd local]# cat /etc/ndb-config.ini
# Example Ndbcluster storage engine config file.
#
[ndbd default]
NoOfReplicas= 2
MaxNoOfConcurrentOperations= 10000
DataMemory= 80M
IndexMemory= 24M
TimeBetweenWatchDogCheck= 30000
DataDir= /var/lib/mysql-cluster
MaxNoOfOrderedIndexes= 512
[ndb_mgmd default]
#确定该目录存在
DataDir= /var/lib/mysql-cluster
[ndb_mgmd]
Id=1
HostName= 192.168.1.11
[ndbd]
Id= 2
HostName= 192.168.1.14
[ndbd]
Id= 3
HostName= 192.168.1.15
[mysqld]
Id= 4
HostName= 192.168.1.12
[mysqld]
Id= 5
HostName= 192.168.1.13
# choose an unused port number
# in this configuration 63132, 63133, and 63134
# will be used
[tcp default]
PortNumber= 63132
第五步，创建数据目录，修改所有者和所属组
[root@mgmd local]# mkdir /var/lib/mysql-cluster
[root@mgmd local]# chown mysql. /var/lib/mysql-cluster/ -R
[root@mgmd local]# ll -d /var/lib/mysql-cluster/
drwxr-xr-x 2 mysql mysql 4096 Nov 4 23:39 /var/lib/mysql-cluster/
第六步，启动ndb_mgmd
[root@mgmd local]# /usr/local/mysql/bin/ndb_mgmd -f /etc/ndb-config.ini
2013-11-04 23:46:12 [MgmtSrvr] INFO -- NDB Cluster Management Server. mysql-5.1.44 ndb-7.1.4b
2013-11-04 23:46:12 [MgmtSrvr] INFO -- The default config directory '/usr/local/mysql/mysql-cluster' does not exist. Trying to create it...
2013-11-04 23:46:12 [MgmtSrvr] INFO -- Sucessfully created config directory
2013-11-04 23:46:12 [MgmtSrvr] INFO -- Reading cluster configuration from '/etc/ndb-config.ini'
2013-11-04 23:46:12 [MgmtSrvr] WARNING -- at lin