情況說明: CentOs6.5 + MySQL-Cluster 7.3.4 (最新GA版本),籌劃2臺呆板,一臺做節制處事器 + 負載平衡處事器 + 數據節點處事器, 另一臺做 負載平衡處事器 + 數據節點處事器;
一、下載,這里為了利便安裝進程,這里直接利用了RPM包來安裝,避開了編譯安裝的疾苦:
首先先到www.msyql.com下載如下的RPM安裝包
(http://dev.mysql.com/downloads/cluster/),日本游戲代理
歐洲服務器,記得選擇 Red Hat Enterprise
Linux/Oracle Linux 下面的
MySQL-Cluster-gpl-7.3.4-1.el6.x86_64.rpm-bundle.tar
這個安裝包,制止一個接一個下載的疾苦;
二、情況清理以及安裝:
1. mysql舊版本排除:
首先利用如下呼吁來清理之前操縱系統自帶的mysql安裝:yum -y remove mysql
然后利用如下呼吁:
rpm -qa | grep mysql*
對付找到的2個剩余mysql包,請憑據如下的呼吁名目予以刪除:
rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64
2. mysql
cluster版本安裝籌備:將MySQL-Cluster-gpl-7.3.4-1.el6.x86_64.rpm-bundle.tar放到某個目次下(譬如/package)
下面,而且執行如下呼吁解壓:
tar -xvf MySQL-Cluster-gpl-7.3.4-1.el6.x86_64.rpm-bundle.tar
獲得如下文件清單:
MySQL-Cluster-client-gpl-7.3.4-1.el6.x86_64.rpm
MySQL-Cluster-devel-gpl-7.3.4-1.el6.x86_64.rpm
MySQL-Cluster-embedded-gpl-7.3.4-1.el6.x86_64.rpm
MySQL-Cluster-server-gpl-7.3.4-1.el6.x86_64.rpm
MySQL-Cluster-shared-compat-gpl-7.3.4-1.el6.x86_64.rpm
MySQL-Cluster-shared-gpl-7.3.4-1.el6.x86_64.rpm
MySQL-Cluster-test-gpl-7.3.4-1.el6.x86_64.rpm
3. mysql cluster版本安裝:
建設文件夾(分如下3個類來建設對應的文件夾)
存儲節點:mkdir /var/lib/mysql/data
打點節點:mkdir /var/lib/mysql-cluster
SQL節點:可不消 文件夾授權
歷程DIR: mkdir
/var/run/mysqld
利用如下的呼吁來改觀權限擔??蓪懭耄?br />
chmod -R 1777 /var/lib/mysql
chmod -R 1777 /var/run/mysqld
chmod -R 1777 /var/lib/mysql-cluster
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
出格留意,當安裝完畢server
gpl包后,將呈現如下提示信息,提醒我們整個cluster安裝后的初次超等賬戶暗碼存在/root/.mysql_secret這個文件傍邊。
---------------------------------------------------------------------------------------------------------------------
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.
---------------------------------------------------------------------------------------------------------------------
4. 設置文件撰寫與調解:
cd /var/lib/mysql-cluster
vi config.ini
---------------------------------------------------------------------------------------------------------------------------
[computer]
Id=mgr-server-01
HostName=10.10.0.1
[mgm default]
datadir=/var/lib/mysql-cluster
[mgm]
HostName=10.10.0.1
NodeId=60
ExecuteOnComputer=mgr-server-01
PortNumber=1186
ArbitrationRank=2
[ndbd default]
NoOfReplicas=2
DataMemory=8G
IndexMemory=2G
[ndbd]
HostName=10.10.0.1
DataDir=/var/lib/mysql
NodeId=1
[ndbd]
HostName=10.10.0.2
DataDir=/var/lib/mysql
NodeId=2
[mysqld]
HostName=10.10.0.1
NodeId=81
[mysqld]
HostName=10.10.0.2
NodeId=82
---------------------------------------------------------------------------------------------------------------------------
5. 設置Mysql文件:
vi /etc/my.cnf
[client]
socket=/var/lib/mysql/mysql.sock
[mysqld]
max_connections=100
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
ndbcluster
ndb-connectstring=10.10.0.1
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysql_cluster]
ndb-connectstring=10.10.0.1
---------------------------------------------------------------------------------------------------------------------------