galera for mysql 安装

• Posted on zydyh
• in galera, mysql
• on 10月 12, 2016
• No Comments.

galera 安装(简化版)
#/bin/bash
cd /root
wget http://nas.zydyh.net/tar/galera-wsrep-rpms.tar.gz
tar -xzf galera-wsrep-rpms.tar.gz
cd galera-wsrep-rpms
yum erase mysql-libs-5.1.71-1.el6.x86_64 -y
yum localinstall -y *

mysqld_safe –user=mysql –skip-grant-tables –skip-networking &
mysql>
use mysql
UPDATE user SET Password=PASSWORD(‘xxxxxx’) where USER=’root’;
flush privileges;

/etc/init.d/mysql restart

再进入命令行
SET PASSWORD = PASSWORD(‘xxxxxx’);

cd /root/galera-wsrep-rpms
cp -p my.cnf /etc/my.cnf
echo “mount –bind /var/lib/mysql /data/mysql” > /etc/rc.local
mount –bind /var/lib/mysql /data/mysql
/etc/init.d/mysql restart
在my.cnf里添加 wsrep_cluster_address=”gcomm://” 地址