MySQL5.7集群搭建步驟

這篇文章主要講解了“5.7集群搭建步驟”，文中的講解內容簡(jiǎn)單清晰，易于學(xué)習與理解，下面請大家跟著(zhù)小編的思路慢慢深入，一起來(lái)研究和學(xué)習“MySQL5.7集群搭建步驟”吧！

今天抽出時(shí)間做一個(gè)測試，搭建一個(gè)最簡(jiǎn)單的MySQL Cluster。
準備5個(gè)虛擬機，操作系統版本Redhat6.5，MySQL版本mysql-cluster-gpl-7.5.5-linux-glibc2.5-x86_64.tar（5.7）

一、準備工作
關(guān)閉防火墻：
service iptables stop
chkconfig iptables off
關(guān)閉selinux：
vi /etc/selinux/config
將SELINUX=enforce改為disabled
解壓mysql-cluster-gpl-7.5.5-linux-glibc2.5-x86_64.tar至/usr/local/mysql(5個(gè)節點(diǎn))
二、配置管理節點(diǎn)
cp /usr/local/mysql/bin/ndb_mgm* /usr/local/bin
cd /usr/local/bin
chmod +x ndb_mgm*

cd /usr/local/mysql
vi config.ini
[ndbd default]
NoOfReplicas=2
DataMemory=80M
IndexMemory=18M
[ndb_mgmd]
NodeId=1
hostname=192.168.8.220
datadir=/mysql/data
[ndbd]
NodeId=2
hostname=192.168.8.231
datadir=/mysql/data
[ndbd]
NodeId=3
hostname=192.168.8.232
datadir=/mysql/data
[mysqld]
NodeId=4
hostname=192.168.8.221
[mysqld]
NodeId=5
hostname=192.168.8.222

啟動(dòng)mgm
ndb_mgmd -f /usr/local/mysql/config.ini 
進(jìn)入mgm查看狀態(tài)：
[root@mgm usr]# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
三、配置數據節點(diǎn)（兩個(gè)節點(diǎn)）
修改配置文件
vi /etc/my.cnf
添加如下配置：
user=mysql
basedir=/usr/local/mysql
datadir=/mysql/data
default-storage-engine=InnoDB
#skip-grant-tables
socket=/tmp/mysqld.sock
[client]
default-character-set=utf8
socket=/tmp/mysqld.sock
[mysql]
socket=/tmp/mysqld.sock
default-character-set=utf8
[mysql_cluster]
ndb-connectstring=192.168.8.220

cd /usr/local/mysql/bin
./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/mysql/data
2017-11-02 08:06:03 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
2017-11-02 08:06:20 [WARNING] The bootstrap log isn't empty:
2017-11-02 08:06:20 [WARNING] 2017-11-02T00:06:04.435385Z 0 [Warning] --bootstrap is deprecated. Please consider using --initialize instead
2017-11-02T00:06:04.457329Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2017-11-02T00:06:04.457350Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
提示新版本--initialize取代了mysql_install_db，這個(gè)不影響。

/usr/local/mysql/bin/ndbd --initial
2017-11-02 08:10:11 [ndbd] INFO     -- Angel connected to '192.168.8.220:1186'
2017-11-02 08:10:11 [ndbd] INFO     -- Angel allocated nodeid: 3

四、配置SQL節點(diǎn)
修改配置文件
vi /etc/my.cnf
添加如下配置：
user=mysql
basedir=/usr/local/mysql
datadir=/mysql/data
default-storage-engine=InnoDB
#skip-grant-tables
socket=/tmp/mysql.sock
ndbcluster
ndb-connectstring=192.168.8.220
[client]
default-character-set=utf8
socket=/tmp/mysql.sock
[mysql]
socket=/tmp/mysql.sock
default-character-set=utf8
[mysql_cluster]
#ndb-connectstring=192.168.8.220

cd /usr/local/mysql/bin
./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/mysql/data
2017-11-02 08:06:03 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize
2017-11-02 08:06:20 [WARNING] The bootstrap log isn't empty:
2017-11-02 08:06:20 [WARNING] 2017-11-02T00:06:04.435385Z 0 [Warning] --bootstrap is deprecated. Please consider using --initialize instead
2017-11-02T00:06:04.457329Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2017-11-02T00:06:04.457350Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
提示新版本--initialize取代了mysql_install_db，這個(gè)不影響。

在SQL節點(diǎn)啟動(dòng)數據庫，并改root口令

五、集群測試
在SQL節點(diǎn)一添加database test，SQL節點(diǎn)2可以查詢(xún)到，并進(jìn)行增刪改查操作。

六、啟動(dòng)集群
1）啟動(dòng)管理結點(diǎn)
在shell中運行以下命令：
ndb_mgmd -f /usr/local/mysql/config.ini
還可以使用ndb_mgm來(lái)監聽(tīng)客戶(hù)端，如下：
ndb_mgm
2）啟動(dòng)數據結點(diǎn)
首次啟動(dòng)，則需要添加--initial參數，以便進(jìn)行NDB節點(diǎn)的初始化工作。在以后的啟動(dòng)過(guò)程中，則是不能添加該參數的，否則ndbd程序會(huì )清除在之前建立的所有用于恢復的數據文件和日志文件。
/usr/local/mysql/bin/ndbd --initial
如果不是首次啟動(dòng)，則執行下面的命令。
/usr/local/mysql/bin/ndbd
3）啟動(dòng)SQL結點(diǎn)
若MySQL服務(wù)沒(méi)有運行，則在shell中運行以下命令：
/usr/local/mysql/bin/mysqld_safe --user=mysql &

七、關(guān)閉集群
1）關(guān)閉管理節點(diǎn)和數據節點(diǎn)，只需要在管理節點(diǎn)（ClusterMgm--134）里執行：
shell> /usr/local/mysql/bin/ndb_mgm -e shutdown
顯示
Connected to Management Server at: localhost:1186
NDB Cluster node(s) have shutdown.
Disconnecting to allow management server to shutdown.
2）然后關(guān)閉Sql節點(diǎn)（135,136），分別在2個(gè)節點(diǎn)里運行：
shell> /etc/init.d/mysql stop
Shutting down MySQL... SUCCESS!