1)安装包
yum install -y cmake gcc gcc-c++ libaio libaio-devel automake autoconf bzr ncurses ncurses-devel boost bison libtool [ Debian/Ubuntu: ncurses5-devel libncurses5-dev]
yum install -y perl-DBD-MySQL perl-DBI perl-Time-HiRes
yum install -y scons boost* check* openssl #for GaleraCluster
yum install -y rsync lsof
yum install -y crypt socat
socat 需要手工下载安装
yum install percona-xtrabackup-2.2.6-5042.el6.x86_64.rpm
yum install socat-1.7.2.4-1.el6.rf.x86_64.rpm
2)解压 Percona-XtraDB-Cluster-5.6.22-rel72.0-25.8.978.Linux.x86_64.tar.gz 文件【无需编译】
#cd /soft
#tar -zxvf Percona-XtraDB-Cluster-5.6.22-rel72.0-25.8.978.Linux.x86_64.tar.gz -C /usr/local/ 【解压】
#cd /usr/local/
#mv Percona-XtraDB-Cluster-5.6.22-rel72.0-25.8.978.Linux.x86_64 mysql 【修改路径名】
3)将下载后的mysql安装程序拷贝到其它节点
tar -zcvf PXC_MySQL_5.6.tar.gz mysql
scp 其它节点,解压即可
4) galera组件
该组件已经在binary程序包中已经存在
/usr/local/mysql/bin/garbd
/usr/local/mysql/lib/libgalera_smm.so
#cp /usr/local/mysql/lib/libgalera_smm.so /usr/lib64/
记得设置以下参数
wsrep_provider=/usr/lib64/libgalera_smm.so
5)配置参数文件my.cnf
6)创建数据库
X86_64真实环境 链接以下库文件
ln -sf /usr/lib64/libssl.so.10 /usr/lib64/libssl.so.6
ln -sf /usr/lib64/libcrypto.so.10 /usr/lib64/libcrypto.so.6
7)只在第一个主节点做以下操作
/usr/local/mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf --user=mysql --basedir=/usr/local/mysql --datadir=/home/mysql_data/
8)设置配置文件
#cp support-files/mysql.server /etc/init.d/mysql
#chkconfig --add mysqld
#chkconfig --level 2345 mysqld off
9) 启动
第一个节点启动:
service mysqld bootstrap-pxc
第二个节点启动:
service mysqld start
第三个节点启动:
service mysqld start
GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'sstuser'@'localhost'identified by 'sstuser789';
GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'sstuser'@'192.168.123.%'identified by 'sstuser789';
-------------------------
wsrep_restart_slave=1
wsrep_slave_threads=8
innodb_flush_method=O_DIRECT
OS参数设置:
vm.swappiness=0
yum install -y cmake gcc gcc-c++ libaio libaio-devel automake autoconf bzr ncurses ncurses-devel boost bison libtool [ Debian/Ubuntu: ncurses5-devel libncurses5-dev]
yum install -y perl-DBD-MySQL perl-DBI perl-Time-HiRes
yum install -y scons boost* check* openssl #for GaleraCluster
yum install -y rsync lsof
yum install -y crypt socat
socat 需要手工下载安装
yum install percona-xtrabackup-2.2.6-5042.el6.x86_64.rpm
yum install socat-1.7.2.4-1.el6.rf.x86_64.rpm
2)解压 Percona-XtraDB-Cluster-5.6.22-rel72.0-25.8.978.Linux.x86_64.tar.gz 文件【无需编译】
#cd /soft
#tar -zxvf Percona-XtraDB-Cluster-5.6.22-rel72.0-25.8.978.Linux.x86_64.tar.gz -C /usr/local/ 【解压】
#cd /usr/local/
#mv Percona-XtraDB-Cluster-5.6.22-rel72.0-25.8.978.Linux.x86_64 mysql 【修改路径名】
3)将下载后的mysql安装程序拷贝到其它节点
tar -zcvf PXC_MySQL_5.6.tar.gz mysql
scp 其它节点,解压即可
4) galera组件
该组件已经在binary程序包中已经存在
/usr/local/mysql/bin/garbd
/usr/local/mysql/lib/libgalera_smm.so
#cp /usr/local/mysql/lib/libgalera_smm.so /usr/lib64/
记得设置以下参数
wsrep_provider=/usr/lib64/libgalera_smm.so
5)配置参数文件my.cnf
6)创建数据库
X86_64真实环境 链接以下库文件
ln -sf /usr/lib64/libssl.so.10 /usr/lib64/libssl.so.6
ln -sf /usr/lib64/libcrypto.so.10 /usr/lib64/libcrypto.so.6
7)只在第一个主节点做以下操作
/usr/local/mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf --user=mysql --basedir=/usr/local/mysql --datadir=/home/mysql_data/
8)设置配置文件
#cp support-files/mysql.server /etc/init.d/mysql
#chkconfig --add mysqld
#chkconfig --level 2345 mysqld off
9) 启动
第一个节点启动:
service mysqld bootstrap-pxc
第二个节点启动:
service mysqld start
第三个节点启动:
service mysqld start
GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'sstuser'@'localhost'identified by 'sstuser789';
GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'sstuser'@'192.168.123.%'identified by 'sstuser789';
-------------------------
wsrep_restart_slave=1
wsrep_slave_threads=8
innodb_flush_method=O_DIRECT
OS参数设置:
vm.swappiness=0
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9606353/viewspace-1824283/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9606353/viewspace-1824283/