MySQL-percona安装

 

1. percona-toolkit工具部署

1.1 下载文件

https://www.percona.com/downloads/percona-toolkit/LATEST/

1.2 安装

# 安装依赖系统包
yum -y install perl-ExtUtils-MakeMaker perl-DBI perl-DBD-MySQL perl-Digest-MD5 perl-Time-HiRes

tar -xf percona-toolkit-3.1.0_x86_64.tar.gz -C /usr/local/src/

cd /usr/local/src/percona-toolkit* 

perl Makefile.PL PREFIX=/usr/local/percona-toolkit

make && make test && make install

1.3 配置环境使用

export PERCONA_TOOLKIT_HOME=/usr/local/percona-toolkit
export PATH=${PATH}:${PERCONA_TOOLKIT_HOME}/bin

 

2. xtrabackup工具部署

2.1 版本选择

mysql 5.7 以下版本，选择 percona xtrabackup 2.4 版本
mysql 8.0 以上版本，选择 percona xtrabackup 8.0版本

 

2.2 软件安装

1) yum 安装方式

1.1) 在线安装

-- 配置yum源

-- RHEL/Centos 5
wget https://repo.percona.com/yum/percona-release-latest.noarch.rpm
rpm -ivH percona-release-latest.noarch.rpm

-- RHEL/Centos 6 later
yum -y install https://repo.percona.com/yum/percona-release-latest.noarch.rpm

-- 安装Percona XtraBackup：

yum install -y percona-xtrabackup-80 #安装8.0版本
yum install -y percona-xtrabackup-24 #安装2.4版本

 

1.2）离线安装

-- rpm 
wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.4/\
binary/redhat/7/x86_64/percona-xtrabackup-24-2.4.4-1.el7.x86_64.rpm

yum -y localinstall percona-xtrabackup-24-2.4.4-1.el7.x86_64.rpm

-- 源代码包
wget https://www.percona.com/downloads/Percona-XtraBackup-2.4/LATEST/

2）源码编译安装

2.1) 安装系统依赖包

# 检查依赖包
rpm -q --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" cmake gcc gcc-c++ libaio libaio-devel automake autoconf \
bison libtool ncurses-devel libgcrypt-devel libev-devel libcurl-devel vim-common

# 安装
yum -y install cmake gcc gcc-c++ libaio libaio-devel automake autoconf \
  bison libtool ncurses-devel libgcrypt-devel libev-devel libcurl-devel \
  vim-common

wget http://www.sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz

tar -xf boost_1_59_0.tar.gz -C /usr/local/

2.2) 编译安装

tar -xf percona-xtrabackup-2.4.18.tar.gz -C /usr/local/src

mkdir -p /usr/local/src/percona-xtrabackup-2.4.18/debug

cd /usr/local/src/percona-xtrabackup-2.4.18/debug

cmake .. -DCMAKE_INSTALL_PREFIX=/usr/local/percona-xtrabackup -DBUILD_CONFIG=xtrabackup_release -DWITH_MAN_PAGES=OFF -DWITH_BOOST=/usr/local/boost_1_59_0 && \
make --jobs $(grep -ci processor /proc/cpuinfo)  && \
make --jobs $(grep -ci processor /proc/cpuinfo)  install

 

3. 配置环境变量

cat >/etc/profile.d/mysql.sh<<-EOF
export MYSQL_HOME=/usr/local/mysql
export MYSQL_DATA=\${MYSQL_HOME}/data
export PXCHOME=/usr/local/percona-xtrabackup
export PATH=\${MYSQL_HOME}/bin:\${PXCHOME}/bin:\${PATH}
export LD_LIBRARY_PATH=\${MYSQL_HOME}/lib
EOF