网络配置:
管理节点:10.10.54.81
数据节点:10.10.54.83/88
SQL节点:10.10.54.83/88
安装包:
mysql-cluster-gpl-7.2.15.tar.gz
cmake-2.8.12.2.tar.gz
配置步骤:
(1)解压缩文件
在三台主机上同时做如下步骤:
# tar xvf mysql-cluster-gpl-7.2.15.tar.gz
# mv mysql-cluster-gpl-7.2.15/ /usr/local/mysql/
# chown mysql.mysql /usr/local/mysql/ -R
(2)安装
在三台主机上
安装cmake-2.8
tar xvf cmake-2.8.12.2.tar.gz
cd cmake-2.8.12.2
./configure
make
make install
编译安装 mysql-cluster
cd /usr/local/mysql
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/data/ndb \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_NDBCLUSTER_STORAGE_ENGINE=1 \
-DWITH_NDB_JAVA=OFF \
-DMYSQL_UNIX_ADDR=/usr/local/mysql/tmp/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_EXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_SSL=yes
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
出现错误:
CMake Error at storage/ndb/cmake/ndb_require_variable.cmake:24 (MESSAGE):
The variable JAVA_RUNTIME is required to build NDB
Call Stack (most recent call first):
storage/ndb/CMakeLists.txt:255 (NDB_REQUIRE_VARIABLE)
-- Configuring incomplete, errors occurred!
解决方法:
(1)把-DWITH_NDBCLUSTER_STORAGE_ENGINE=ON改为OFF
(2)安装java环境
yum lsist|grep java
出现错误:
CMake Error at cmake/bison.cmake:60 (FILE):
file does not recognize sub-command RENAME
Call Stack (most recent call first):
sql/CMakeLists.txt:184 (RUN_BISON
解决方法:
移除cmake安装cmake-2.8.12.2
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
make
make install
[root@nan81 data]# mkdir -p /data/ndb
[root@nan81 data]# chown mysql.mysql /usr/local/mysql -R
[root@nan81 data]# chown mysql.mysql /data/ndb/ -R
[root@nan81 ~]# cp /usr/local/mysql/support-files/my-large.cnf /etc/my.cnf
[root@nan81 ~]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@nan81 ~]# chmod +x /etc/init.d/mysqld
[root@nan81 ~]# vim /etc/my.cnf
[mysqld]
datadir=/data/ndb
初始化数据:
[root@nan81 local]# chmod 755 /usr/local/mysql/scripts/*
[root@nan81 local]# /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
出现错误:
[root@nan81 local]# /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/
-bash: /usr/local/mysql/scripts/mysql_install_db: Permission denied
解决方法:
权限不够
[root@nan81 local]# chmod 755 /usr/local/mysql/scripts/*
出现错误:
[root@nan81 local]# /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/
WARNING: The host 'nan81' could not be looked up with resolveip.
解决方法:
添加如下
[root@nan81 local]# vim /etc/hosts
10.10.54.81 nan81
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
(3)配置管理节点
即在主机:10.10.54.81上
[root@nan81 data]# cp /usr/local/mysql/bin/ndb_mgm* /usr/local/bin/
[root@nan81 ~]# mkdir /etc/ndb
[root@nan81 ~]# vim /etc/ndb/config.ini
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=512M
IndexMemory=256M
[NDB_MGMD]
nodeid=1
hostname=10.10.54.81
datadir=/data/ndb
[NDBD]
nodeid=2
hostname=10.10.54.83
datadir=/data/ndb
BackupDataDir=/data/backup
[NDBD]
nodeid=3
hostname=10.10.54.88
datadir=/data/ndb
BackupDataDir=/data/backup
[MYSQLD]
nodeid=10
hostname=10.10.54.83
[MYSQLD]
nodeid=11
hostname=10.10.54.88
(4)配置SQL节点
在10.10.54.88/82上
# vim /etc/my.cnf
[mysql_cluster]
ndb-connectstring=10.10.54.81
[mysqld]
ndbcluster
ndb-connectstring=10.10.54.81
datadir=/data/ndb
# vim /etc/init.d/mysqld
datadir=/data/ndb
(5)启动管理节点
[root@nan81 data]# ndb_mgmd -f --initial /etc/ndb/config.ini
MySQL Cluster Management Server mysql-5.5.35 ndb-7.2.15
[root@nan81 data]# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
(6)启动数据节点
[root@nan88 data]# ndbd --initial connectstring=10.10.54.81
2014-02-27 18:54:33 [ndbd] INFO -- Angel connected to '10.10.54.81:1186'
2014-02-27 18:54:33 [ndbd] INFO -- Angel allocated nodeid: 3
[root@nan82 data]# ndbd --initial connectstring=10.10.54.81
2014-02-27 19:15:06 [ndbd] INFO -- Angel connected to '10.10.54.81:1186'
2014-02-27 19:15:06 [ndbd] INFO -- Angel allocated nodeid: 2
(7)启动SQL节点
[root@nan88 data]# /etc/init.d/mysqld start
Starting MySQL SUCCESS!
[root@nan82 data]# /etc/init.d/mysqld start
Starting MySQL....... SUCCESS!
(8)在管理节点上显示如下
则成功
ndb_mgm> show
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @10.10.54.82 (mysql-5.5.35 ndb-7.2.15, Nodegroup: 0, *)
id=3 @10.10.54.88 (mysql-5.5.35 ndb-7.2.15, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.10.54.81 (mysql-5.5.35 ndb-7.2.15)
[mysqld(API)] 2 node(s)
id=10 @10.10.54.82 (mysql-5.5.35 ndb-7.2.15)
id=11 @10.10.54.88 (mysql-5.5.35 ndb-7.2.15)
转载于:https://my.oschina.net/u/1454868/blog/203732