centos6.7 mini 安裝 Galera Cluster

系統環境，請檢視《virtualbox5.0.8 centos6.7 mini 安裝》

一、.規劃

3台主機，記憶體3G，IP： 192.168.56.101 192.168.56.102 192.168.56.103

二、軟體(在~目錄)

galera-3-25.3.17.tar.gz

galera-25.3.5-src.tar.gz

mysql-wsrep-5.6.31-25.16-linux-x86_64.tar.gz

scons-2.4.1-1.noarch.rpm

三、安裝

yum -y install rsync

yum -y install lsof

rpm -Uvh scons-2.4.1-1.noarch.rpm

tar -zxvf galera-25.3.5-src.tar.gz

tar -zxvf mysql-wsrep-5.6.31-25.16-linux-x86_64.tar.gz

mv mysql-wsrep-5.6.31-25.16-linux-x86_64 /usr/local/mysql

useradd -s /sbin/nologin -M mysql

mkdir -p /data/mydata

cd /usr/local/mysql/

./scripts/mysql_install_db –no-defaults –datadir=/data/mydata –user=mysql

chown -R mysql.mysql /data/mydata/

chown root.mysql /usr/local/mysql

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

cd ~/galera-25.3.5-src

scons

cp garb/garbd /usr/local/mysql/bin

cp libgalera_smm.so /usr/local/mysql/lib/plugin/

vi /etc/my.cnf

service mysqld start –wsrep_cluster_address=gcomm://

cd /usr/local/mysql/bin

./mysqladmin -u root password 111111

./mysql -h 192.168.56.101 -u root -p

service mysqld start –wsrep_cluster_address=”gcomm://192.168.56.102:4567,192.168.56.103:4567”