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