mysql+wsrep源码安装_Percona-XtraDB-Cluster的编译安装

Percona-XtraDB-Cluster的编译安装

发布时间：2020-07-14 20:14:30

来源：51CTO

阅读：6040

作者：sun_68

环境：

操作系统centos7.4，mysql 安装在/data/mysql下，mysql属于mysql用户，pxc-5.7.19

一、下载源码包：

1.1 下载pxc-5.7.19

mkdir -p /home/sunx/tools

wget -P /home/sunx/tools

https://www.percona.com/downloads/Percona-XtraDB-Cluster-57/Percona-XtraDB-Cluster-5.7.19-29.22/source/tarball/Percona-XtraDB-Cluster-5.7.19-29.22.tar.gz

1. 2 下载boost

mkdir -p /usr/local/boost

wget -P /usr/local/boost https://sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz/download

1.3 下载percona-xtrabackup-2.4.5

wget -P /home/sunx/tools https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.5/source/tarball/percona-xtrabackup-2.4.5.tar.gz

二、安装依赖：

yum -y install libtool ncurses-devel libgcrypt-devel libev-devel \

git scons gcc gcc-c++ openssl check cmake bison boost-devel \

asio-devel libaio-devel ncurses-devel readline-devel pam-devel socat \

libaio automake autoconf vim redhat-lsb check-devel

yum -y install libnl-devel openssl-devel libnfnetlink-devel ipvsadm \

popt-devel libnfnetlink kernel-devel popt-static iptraf

yum -y install numactl libev perl-DBD-mysql perl-Time-HiRes

配置epel库

wget -O /etc/yum.repos.d/epel.repo http://mirrors.aliyun.com/repo/epel-7.repo

三、编译安装：

3.1 编译安装percona-xtrabackup

cd /usr/local/src/percona-xtrabackup-2.4.5/

cmake ./ -DBUILD_CONFIG=xtrabackup_release \

-DWITH_MAN_PAGES=OFF \

-DDOWNLOAD_BOOST=1 \

-DWITH_BOOST="/usr/local/boost"

make -j 4 && make install

3.2 编译安装Percona-XtraDB-Cluster-5.7.19-29.22

编译安装前最好要卸载掉本地的mysql数据库

rpm-qa | grep mysql (注意大小写，如果mysql不行就换MySQL)

yum -y remove mysql的包名

卸载后/var/lib/mysql中的数据及/etc/my.cnf不会删除，如果确定没用后就手工删除

rm -f /etc/my.cnf

rm -rf /var/lib/mysql

创建mysql用户名及文件夹

mkdir /data/mysql

ln -s /data/mysql /usr/local/mysql

mkdir /usr/local/mysql/{binlog