centos6.7 mini 安装 Galera Cluster

来源：互联网发布：智能音箱知乎编辑：程序博客网时间：2024/05/16 12:15

系统环境，请查看《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”

0 0