mysql clusterインストールNDBソースコードインストール
4902 ワード
：
：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)