percona mysql 安装_MySQL-percona安装

1. percona-toolkit工具部署

1.1 下载文件

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:

-- 安装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<

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