Percona XtraDB Cluster 安装

一、安装依赖包

需要redhat6.5的yum源，6.4的会出问题。
yum install cmake gcc gcc-c++ libaio libaio-devel automake autoconf bzr bison libtool ncurses-devel
yum install *readline* 
yum install http://dl.fedoraproject.org/pub/epel/6/x86_64/socat-1.7.2.3-1.el6.x86_64.rpm

二、安装xtrabackup

percona-xtra-backup只是个备份工具，类似客户端连接到目标数据库 进行备份。同时，它是安装xtradb-cluster的依赖包。
（
[root@gq-kf-04 soft]# rpm -ivh Percona-XtraDB-Cluster-server-56-5.6.24-25.11.1.el6.x86_64.rpm 
error: Failed dependencies:
        percona-xtrabackup >= 2.2.5 is needed by Percona-XtraDB-Cluster-server-56-1:5.6.24-25.11.1.el6.x86_64
）

方法一、二进制包------推荐（好升级、简单）

tar xvf Percona-XtraBackup-2.2.12-r8726828-el6-x86_64-bundle.tar
rpm -ivh percona-xtrabackup-2.2.12-1.el6.x86_64.rpm 
rpm -ivh  percona-xtrabackup-test-2.2.12-1.el6.x86_64.rpm
rpm -ivh percona-xtrabackup-debuginfo-2.2.12-1.el6.x86_64.rpm

[root@node1 Desktop]# rpm -qa | grep percona
percona-xtrabackup-test-2.2.12-1.el6.x86_64
percona-xtrabackup-2.2.12-1.el6.x86_64
percona-xtrabackup-debuginfo-2.2.12-1.el6.x86_64

方法二、编译安装

#tar -zxvf percona-xtrabackup-2.2.8.tar.gz
#cd percona-xtrabackup-2.2.8
#cmake -DBUILD_CONFIG=xtrabackup_release && make -j4
#make install

配置相关服务目录的软连接
#ln -s /usr/local/xtrabackup/bin/innobackupex /usr/sbin/innobackupex
#ln -s /usr/local/xtrabackup/bin/xbcrypt /usr/sbin/xbcrypt
#ln -s /usr/local/xtrabackup/bin/xbstream /usr/sbin/xbstream
#ln -s /usr/local/xtrabackup/bin/xtrabackup /usr/sbin/xtrabackup

三、安装Percona-XtraDB-Cluster

1、安装PXC工具包 6个
#tar -xvf Percona-XtraDB-Cluster-5.6.22-25.8-r978-el6-x86_64-bundle.tar
rpm -ivh Percona-XtraDB-Cluster-shared-56-5.6.24-25.11.1.el6.x86_64.rpm
rpm -ivh Percona-XtraDB-Cluster-56-debuginfo-5.6.24-25.11.1.el6.x86_64.rpm
rpm -ivh Percona-XtraDB-Cluster-client-56-5.6.24-25.11.1.el6.x86_64.rpm
rpm -ivh Percona-XtraDB-Cluster-test-56-5.6.24-25.11.1.el6.x86_64.rpm
rpm -ivh Percona-XtraDB-Cluster-galera-3-3.11-1.rhel6.x86_64.rpm
rpm -ivh Percona-XtraDB-Cluster-devel-56-5.6.24-25.11.2.el6.x86_64.rpm

root@node1 pxc]# rpm -qa | grep Percona
Percona-XtraDB-Cluster-shared-56-5.6.24-25.11.1.el6.x86_64
Percona-XtraDB-Cluster-56-debuginfo-5.6.24-25.11.1.el6.x86_64
Percona-XtraDB-Cluster-client-56-5.6.24-25.11.1.el6.x86_64
Percona-XtraDB-Cluster-test-56-5.6.24-25.11.1.el6.x86_64
Percona-XtraDB-Cluster-devel-56-5.6.24-25.11.2.el6.x86_64
Percona-XtraDB-Cluster-galera-3-3.11-1.rhel6.x86_64


2、 安装Percona 版本的Mysql 

a. 二进制包安装 ---推荐
[root@node1 pxc]# rpm -ivh Percona-XtraDB-Cluster-server-56-5.6.24-25.11.1.el6.x86_64.rpm  

b.编译安装PXC源码包----自定义
#tar -zxvf Percona-XtraDB-Cluster-5.6.22-72.0.tar.gz
#cd Percona-XtraDB-Cluster-5.6.22-72.0

#cmake -DCMAKE_INSTALL_PREFIX=/app_mysql/mysql-5.6.24  -DMYSQL_UNIX_ADDR=/app_mysql/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1  -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/app_mysql/data/ -DMYSQL_USER=mysql    -DENABLE_DOWNLOADS=1  -DWITH_WSREP=1 -DWITH_EDITLINE=0

#make 
#make install

初始化数据库— 初始化安装
cd /app_mysql/mysql-5.6.24
./scripts/mysql_install_db --user=mysql  --basedir=/app_mysql/mysql-5.6.24 --datadir=/app_mysql/data/

注：不能用源码的mysql进行编译安装，因为mysql GPL 不识别 pxc的相关参数。

四、配置my.cnf

五、启动

启动第一个节点

[root@node1 Desktop]# /etc/init.d/mysqld 
Usage: mysqld {start|stop|restart|restart-bootstrap|reload|force-reload|status|bootstrap-pxc}  [ MySQL (Percona XtraDB Cluster) options ]

[root@node1 Desktop]# /etc/init.d/mysqld  bootstrap-pxc

show status like 'wsrep%';
| wsrep_cluster_status         | Primary                              |
| wsrep_connected              | ON 
| wsrep_ready                  | ON       
-------------------------------------

In order to perform successful State Snapshot Transfer using XtraBackup new user needs to be set up with proper  privileges:
mysql@percona1> CREATE USER 'sst'@'localhost' IDENTIFIED BY 'sst';
mysql@percona1> GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'sst'@'localhost';
mysql@percona1> FLUSH PRIVILEGES;


启动第二个及以后节点节点
/etc/init.d/mysql start

show status like 'wsrep%';

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29974949/viewspace-1813813/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29974949/viewspace-1813813/