Galera For Mysql
一软件包安装
#集群配置规划
192.168.1.11 node1 CentOS6
192.168.1.12 node2 Redhat6
192.158.1.13 node3 Redhat6
#清理Mysql环境
for i in `rpm -qa |grep -i mysql`; do
rpm -e --allmatches --nodeps ${i}
done
#安装依赖包
yum -y install libaio1 libdbi-perl libdbd-mysql-perl rsync openssl
#安装psmisc
yum -y install psmisc
#安装mysql client
rpm -ivh MySQL-client-5.6.15-1.linux_glibc2.5.x86_64.rpm
#安装MySQL-shared-compat及除过server以外的包安装上
#devel:开发mysql客户端所需要的库;
#share:开发mysql客户端所需要的链接库
#shared-compat:兼容版本的开发mysql客户端所需要的链接库
#test:测试库
rpm -ivh MySQL-shared-compat-5.6.15-1.linux_glibc2.5.x86_64.rpm \
MySQL-devel-5.6.15-1.linux_glibc2.5.x86_64.rpm \
MySQL-shared-5.6.15-1.linux_glibc2.5.x86_64.rpm \
MySQL-test-5.6.15-1.linux_glibc2.5.x86_64.rpm
#安装包含wsrep-API的Mysql Server包
rpm -ivh MySQL-server-5.6.16_wsrep_25.5-1.rhel6.x86_64.rpm
#安装Galera Replicator包
rpm -ivh galera-25.3.5-1.rhel6.x86_64.rpm
二集群环境配置
#服务器配置##iptables
##SElinux
#省略
#数据库配置
#创建数据库
mkdir -p /opt/dbdata/mysql_3307
chown -R mysql:mysql /opt/dbdata/mysql_3307
chmod -R 755 /opt/dbdata/mysql_3307
mysql_install_db --user=mysql --datadir=/opt/dbdata/mysql_3307
##node1 配置my.cnf
###############################################################################
[client]
port = 3307
socket = /opt/dbdata/mysql_3307/mysql.sock
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
log = /var/log/mysqld_multi.err
[mysqldump]
quick
max_allowed_packet = 16M