MySQL Cluster 安装(二)

2014-11-24 17:31:35 · 作者: · 浏览: 4

CLASSPATH=.:$JAVA_HOME/lib/tools.jar
PATH=$JAVA_HOME/bin:$PATH
export JAVA_HOME CLASSPATH PATH


[root@mysql1 profile.d]# source java.sh


[root@mysql1 profile.d]# java -version
java version "1.6.0_13"
Java(TM) SE Runtime Environment (build 1.6.0_13-b03)
Java HotSpot(TM) Server VM (build 11.3-b02, mixed mode)
[root@mysql1 profile.d]#


成功:


– Using gcc atomic builtins
– Looking for mach/mach_time.h
– Looking for mach/mach_time.h – not found
– Looking for srandomdev
– Looking for srandomdev – not found
– Looking for gethrvtime
– Looking for gethrvtime – not found
– Looking for memset
– Looking for memset – found
– Performing Test HAVE_FUNC_IN_CXX
– Performing Test HAVE_FUNC_IN_CXX – Success
– Performing Test HAVE_PEERCRED
– Performing Test HAVE_PEERCRED – Success
– Configuring done
– Generating done
– Build files have been written to: /home/paul/mysql-cluster-gpl-7.2.10
[root@mysql1 mysql-cluster-gpl-7.2.10]#


[root@mysql1 mysql-cluster-gpl-7.2.10]# make


[root@mysql1 mysql-cluster-gpl-7.2.10]# make install


———————————————————————————————————————–


NDB数据节点安装:


NDB数据节点1: 172.1.2.9 节点ID: id=2 Data Node
NDB数据节点2: 172.1.2.8 节点ID: id=3 Data Node


安装步骤和管理节点一样,也需要JAVA环境,


[root@mysql3 mysql-cluster-gpl-7.2.10]# yum install cmake gcc bison gcc-c++ ncurses-devel


[root@mysql02 mysql-cluster-gpl-7.2.10]# cmake -DCMAKE_INSTALL_PREFIX=/Data/apps/mysql-5.5.12 -DWITH_INNOBASE_STORAGE_ENGINE=ON -DWITH_MYISAM_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci


———————————————————————————————————————–


SQL Node的安装:


[root@mysql4 mysql-cluster-gpl-7.2.10]# yum install cmake gcc bison gcc-c++ ncurses-devel


[root@mysql4 mysql-cluster-gpl-7.2.10]# cmake -DCMAKE_INSTALL_PREFIX=/Data/apps/mysql-5.5.12 -DWITH_INNOBASE_STORAGE_ENGINE=ON -DWITH_MYISAM_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci


———————————————————————————————————————–


配置管理节点:


安装位于:


[root@mysql1 mysql-5.5.12]# pwd
/Data/apps/mysql-5.5.12
[root@mysql1 mysql-5.5.12]# ll
total 76
drwxr-xr-x 2 root root 4096 Feb 26 08:51 bin
-rw-r–r– 1 root root 17987 Dec 20 00:12 COPYING
drwxr-xr-x 4 root root 4096 Feb 26 08:51 data
drwxr-xr-x 2 root root 4096 Feb 26 08:51 docs
drwxr-xr-x 4 root root 4096 Feb 26 08:51 include
-rw-r–r– 1 root root 7605 Dec 20 00:12 INSTALL-BINARY
drwxr-xr-x 3 root root 4096 Feb 26 08:51 lib
drwxr-xr-x 4 root root 4096 Feb 26 08:51 man
drwxr-xr-x 10 root root 4096 Feb 26 08:51 mysql-test
-rw-r–r– 1 root root 2552 Dec 20 00:12 README
drwxr-xr-x 2 root root 4096 Feb 26 08:51 scripts
drwxr-xr-x 29 root root 4096 Feb 26 08:51 share
drwxr-xr-x 4 root root 4096 Feb 26 08:51 sql-bench
drwxr-xr-x 2 root root 4096 Feb 26 08:52 support-files
[root@mysql1 mysql-5.5.12]#


建立配置文件:


[root@mysql1 mysql-5.5.12]# mkdir cluster-conf
[root@mysql1 mysql-5.5.12]# cp /Data/apps/mysql-5.5.12/support-files/ndb-config-2-node.ini /Data/apps/mysql-5.5.12/cluster-conf/
You have new mail in /var/spool/mail/root
[root@mysql1 mysql-5.5.12]#


设置权限:


[root@mysql1 /]# chown mysql:mysql /Data/apps/mysql-5.5.12 –R


进入配置文件目录:


[root@mysql1 mysql-5.5.12]# cd /Data/apps/mysql-5.5.12/cluster-conf/


打开配置文件:


[ndb_mgmd]
Id=1
HostName= 172.1.2.10
Datadir=/Data/apps/mysql-5.5.12/data


[ndbd]
Id= 2
HostName= 172.1.2.9
Datadir=/Data/apps/mysql-5.5.12/ndbdata


[ndbd]
Id= 3
HostName= 172.1.2.8
Datadir=/Data/apps/mysql-5.5.12/ndbda