MySQL - MySQL Cluster 클러스터 구성에 대한 자세한 설명(RPM 설치 패키지 기준)

# yum -y remove mysql  
# rpm -qa | grep mysql*  
# rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64

存储节点：# mkdir /var/lib/mysql/data   
管理节点：# mkdir /var/lib/mysql-cluster    SQL节点：可不用  文件夹授权  
进程DIR：# mkdir /var/run/mysqld

使用如下的命令来变更权限保证可写入：  
# chmod -R 1777 /var/lib/mysql  
# chmod -R 1777 /var/run/mysqld  
# chmod -R 1777 /var/lib/mysql-cluster

# tar xvf MySQL-Cluster-gpl-7.4.2-1.el6.x86_64.rpm-bundle.tar

# rpm -ivh MySQL-Cluster-server-gpl-7.3.4-1.el6.x86_64.rpm  
# rpm -ivh MySQL-Cluster-client-gpl-7.3.4-1.el6.x86_64.rpm

---------------------------------------------------------------------------------------------------------------------  
A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !  
 You will find that password in '/root/.mysql_secret'.  
 You must change that password on your first connect,  
 no other statement but 'SET PASSWORD' will be accepted.  
 See the manual for the semantics of the 'password expired' flag.  
 Also, the account for the anonymous user has been removed.  
 In addition, you can run:  
  /usr/bin/mysql_secure_installation  
 which will also give you the option of removing the test database.  
 This is strongly recommended for production servers.  
 -----------------------------------------------------------

# cd /var/lib/mysql-cluster  
# vi config.ini

[computer]  
 Id=mgr-server-01  
 HostName=192.168.100.218  
 [mgm default]  
 datadir=/var/lib/mysql-cluster  
 [mgm]  
 HostName=192.168.100.218  
 NodeId=60  
 ExecuteOnComputer=mgr-server-01  
 PortNumber=1186  
 ArbitrationRank=2  
 [ndbd default]  
 NoOfReplicas=2  
 DataMemory=500M  
 IndexMemory=500M  
 [ndbd]  
 HostName=192.168.100.217  
 DataDir=/var/lib/mysql  
 NodeId=1  
 [ndbd]  
 HostName=192.168.100.218  
 DataDir=/var/lib/mysql  
 NodeId=2  
 [mysqld]  
 HostName=192.168.100.217  
 NodeId=81  
 [mysqld]  
 HostName=192.168.100.218  
 NodeId=82

[client]  
 socket=/var/lib/mysql/mysql.sock  
 [mysqld]  
 max_connections=100  
 datadir=/var/lib/mysql  
 socket=/var/lib/mysql/mysql.sock  
 ndbcluster  
 ndb-connectstring=192.168.100.218  
 [mysqld_safe]  
 log-error=/var/log/mysqld.log  
 #pid-file=/var/run/mysqld/mysqld.pid  
 pid-file=/var/lib/mysql/mysqld.pid  
 [mysql_cluster]  
 ndb-connectstring=192.168.100.218

ndb_mgm> show  
Connected to Management Server at: 192.168.100.218:1186  
Cluster Configuration  
---------------------  
[ndbd(NDB)] 2 node(s)  
id=1 @192.168.100.217 (mysql-5.6.21 ndb-7.4.2, Nodegroup: 0)  
id=2 @192.168.100.218 (mysql-5.6.21 ndb-7.4.2, Nodegroup: 0, *)  
[ndb_mgmd(MGM)] 1 node(s)  
id=60 @192.168.100.218 (mysql-5.6.21 ndb-7.4.2)  
[mysqld(API)] 2 node(s)  
id=81 @192.168.100.217 (mysql-5.6.21 ndb-7.4.2)  
id=82 @192.168.100.218 (mysql-5.6.21 ndb-7.4.2)

ndb_mgm> show  
Cluster Configuration  
--------------------  
[ndbd(NDB)] 2 node(s)  
id=1 @192.168.100.217 (mysql-5.6.21 ndb-7.4.2, Nodegroup: 0)  
id=2 @192.168.100.218 (mysql-5.6.21 ndb-7.4.2, Nodegroup: 0, *)  
[ndb_mgmd(MGM)] 1 node(s)  
id=60 @192.168.100.218 (mysql-5.6.21 ndb-7.4.2)  
[mysqld(API)] 2 node(s)  
id=81 (not connected, accepting connect from 192.168.100.217)  
id=82 @192.168.100.218 (mysql-5.6.21 ndb-7.4.2)

mysql -u root -p;

SET PASSWORD = PASSWORD('新密码');

select password('111111')；

use mysql;  
delete from user;  
grant all on *.* to root@'%' identified by "111111" with grant option;  
flush privileges;  
quit;

create database clustertest;  
use clustertest;   
CREATE TABLE testtable(Count INT) ENGINE=NDBCLUSTER;

insert into testtable values (1);

select * from testtable;

# pgrep mysqld  
# ps aux | grep nbdb

ndb_mgmd -f /var/lib/mysql-cluster/config.ini  
ndbd  
mysqld_safe --defaults-file=/etc/my.cnf --explicit_defaults_for_timestamp &