MySQL Cluster架設 on CentOS

共同部分:
service iptables stop;service ip6tables stop;selinux disabled
刪除postfix, mysql-lib
yum update後reboot
reboot完關iptables,ip6tables

3台架法:
1號:Management Node:安裝management,tools
2號:Data Node+SQL Node:安裝storage,server,client
3號:Data Node+SQL Node:安裝storage,server,client


1號機設定
mkdir -p /var/lib/mysql-cluster
vim /var/lib/mysql-cluster/config.ini
[ndbd default]
NoOfReplicas=2
DataMemory=80M
IndexMemory=18M
[tcp default]
#portnumber=2202
[ndb_mgmd]
hostname=1號機IP
datadir=/var/lib/mysql-cluster
[ndbd]
hostname=2號機IP
datadir=/var/lib/mysql-cluster
MaxNoOfOrderedIndexes=100000
MaxNoOfUniqueHashIndexes=100000
MaxNoOfAttributes=100000
[ndbd]
hostname=3號機IP
datadir=/var/lib/mysql-cluster
MaxNoOfOrderedIndexes=100000
MaxNoOfUniqueHashIndexes=100000
MaxNoOfAttributes=100000
[mysqld]
hostname=2號機IP
[mysqld]
hostname=3號機IP

2,3號機設定
vim /etc/my.cnf
[mysqld]
ndbcluster
ndb-connectstring=1號機IP

[ndbd]
connect-string=1號機IP

[ndb_mgm]
connect-string=1號機IP

[ndb_mgmd]
config-file=/var/lib/mysql-cluster/config.ini


啟動順序(Management Node->Data Node->SQL Node)
1號機:ndb_mgmd -f /var/lib/mysql-cluster/config.ini --initial
2,3號機:ndbd
2,3號機(擇一開啟,另一個會自動開啟):service mysql start
回1號機檢查:ndb_mgm -e show
2,3號機可開始下指令

關閉順序(SQL Node->Data Node->Management Node)
2,3號機:service mysql stop
1號機:ndb_mgm -e shutdown (自動關閉所有ndbd)


匯入DB
mysql -u root 資料庫名稱 < backup.sql(匯入的sql語法在create table最後都要加上ENGINE=ndbcluster)

忽略大小寫設定(data node設定)
/etc/my.cnf
[mysqld]
lower_case_table_names=1