Mysql 叢集 mysql-cluster 安裝,mysqlmysql-cluster

來源:互聯網
上載者:User

Mysql 叢集 mysql-cluster 安裝,mysqlmysql-cluster


環境說明

系統內容:CentOS 6.5 mini(64bit)
軟體版本:mysql-cluster-advanced-7.3.7-linux-glibc2.5-x86_64.tar.gz

IP地址:
MGM:192.168.100.211

NDBD1:192.168.100.212

NDBD2:192.168.100.213


SQL1:192.168.100.214
SQL2:192.168.100.215


一、Cluster安裝(五個節點)
安裝相關依賴包
# yum -y install perl libaio ntpdate

關閉防火牆
# service iptables stop

刪除系統內建mysql:
# rpm -qa | grep mysql
# rpm -e --allmatches --nodeps mysql-libs-5.1.71-1.el6.x86_64

解壓縮軟體
上傳軟體到/main目錄
# cd /main
# tar zxvf mysql-cluster-advanced-7.3.7-linux-glibc2.5-x86_64.tar.gz
# mv mysql-cluster-advanced-7.3.7-linux-glibc2.5-x86_64 mysql

建立mysql使用者及使用者組
# groupadd mysql
# useradd -g mysql -s /usr/sbin/nologin mysql
# chown -R mysql:mysql /main/mysql

安裝Cluster
# /main/mysql/scripts/mysql_install_db --user=mysql --basedir=/main/mysql --datadir=/main/mysql/data


二、節點配置
1.配置 MGM (MGM 節點)
刪除內建的my.cnf檔案
必須要刪除內建的/etc/my.cnf,如果沒有就不用刪除
# rm -rf /etc/my.cnf

建立設定檔存放目錄
# mkdir /main/mysql/etc
# chown mysql:mysql /main/mysql/etc

建立設定檔config.ini
# vi /main/mysql/etc/config.ini
[ndb_mgmd default]
datadir = /main/mysql/data

[ndbd default]
NoOfReplicas = 2
DataMemory = 80M
IndexMemory = 18M
datadir = /main/mysql/data

[ndb_mgmd]
NodeId = 1
HostName = 192.168.100.211

[ndbd]
NodeId = 11  
HostName = 192.168.100.212
[ndbd]
NodeId = 12
HostName = 192.168.100.213

[mysqld]
NodeId = 81
HostName = 192.168.100.214
[mysqld] 
NodeId = 82
HostName = 192.168.100.215


2.配置資料節點(NDBD1和NDBD2節點)
建立設定檔my.cnf
# vi /etc/my.cnf
[mysqld]
ndbcluster
ndb-connectstring = 192.168.100.211
[mysql_cluster]
ndb-connectstring = 192.168.100.211



3.配置SQL節點(SQL1和SQL2節點)
拷貝檔案
# cp -p /main/mysql/support-files/mysql.server /etc/init.d/mysqld

建立設定檔my.cnf
# vi /etc/my.cnf
[mysqld]
basedir = /main/mysql
datadir = /main/mysql/data
ndbcluster
ndb-connectstring = 192.168.100.211
[mysql_cluster]
ndb-connectstring = 192.168.100.211


三、啟動節點
啟動需按如下順序進行:MGM > NDBD > SQL

如下的啟動方式只適合初次開機,或者備份、恢複或配置變化後重啟時,否則將清空所有資料
1:啟動 MGM (MGM 節點)
# mkdir -p /usr/local/mysql/mysql-cluster
# ndb_mgmd -f /main/mysql/etc/config.ini --initial

查看叢集狀態
# ndb_mgm -e show
Connected to Management Server at: localhost:1186Cluster Configuration---------------------[ndbd(NDB)]     2 node(s)id=11 (not connected, accepting connect from 192.168.100.212)id=12 (not connected, accepting connect from 192.168.100.213)[ndb_mgmd(MGM)] 1 node(s)id=1    @192.168.100.211  (mysql-5.6.21 ndb-7.3.7)[mysqld(API)]   2 node(s)id=81 (not connected, accepting connect from 192.168.100.214)id=82 (not connected, accepting connect from 192.168.100.215)

2:啟動NDBD(NDBD1和NDBD2節點)
# ndbd --initial

3:啟動SQL (SQL1和SQL2節點)

# service mysqld start


到此mysql-cluster安裝完畢,用戶端可以通過sql節點去串連mysql資料庫。這裡僅僅介紹了簡單的安裝配置過程,詳細的配置說明敬請期待。


相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.