阿里云RDS数据库数据恢复到自建数据库（MySQL5.7）

阿里云RDS数据库数据恢复到自建数据库（MySQL5.7）

系统安装

新装虚拟机CentOS Linux release 7.7.1908 (Core)

关闭防火墙与selinux

安装基础软件包与编译安装mysql所需依赖包

yum install -y bash-completion ntp vim net-tools wget
yum install -y cmake gcc-c++ gcc ncurses-devel perl-Data-Dumper boost boost-doc boost-devel

软件包准备

MySQL 5.7版本（与RDS数据库版本一致）

MySQL官网下载软件包，此处下载5.7.16

https://downloads.mysql.com/archives/get/p/23/file/mysql-boost-5.7.16.tar.gz

MySQL 5.7版本需要安装 Percona XtraBackup 2.4

参考文档：

https://www.percona.com/doc/percona-xtrabackup/2.4/installation.html?spm=a2c4g.11186623.2.16.70e92d2fX6pYCu

yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
yum install qpress
yum list | grep percona
yum install -y percona-xtrabackup-24.x86_64

安装mysql5.7

• 安装前卸载mariadb相关软件

rpm -qa | grep mariadb
rpm -e mariadb-libs-5.5.64-1.el7.x86_64 --nodeps

• 创建mysql用户

useradd mysql -s /sbin/nologin

• 解压下载好的MySQL安装包

 cd /usr/local
 wget -c https://downloads.mysql.com/archives/get/p/23/file/mysql-boost-5.7.16.tar.gz
 tar xf mysql-boost-5.7.16.tar.gz

• 编写cmake.sh，并编译安装

cd mysql-5.7.16
vim cmake.sh

cmake . \
-DCMAKE_INSTALL_PREFIX=/home/mysqld \
-DMYSQL_DATADIR=/home/mysqld/data \
-DSYSCONFDIR=/etc \
-DMYSQL_USER=mysql \
-DMYSQL_TCP_PORT=3306 \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DEXTRA_CHARSETS=all \
-DWITH_BOOST=/usr/local/mysql-5.7.16/boost \
-DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_general_ci

保存退出
chmod +x cmake.sh
./cmake.sh
 make && make install

• 配置文件生成

cp support-files/my-default.cnf /etc/my.cnf
vim /etc/my.cnf
[mysqld]
basedir = /home/mysqld
datadir = /home/mysqld/data
port = 3306
server_id = 1
socket = /tmp/mysql.sock
log-error=/home/mysqld/data/error.log
log_bin=mysql-bin
pid-file=/home/mysqld/data/mysql.pid

• 设置添加到系统服务并设置开机启动

cp support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on

chown mysql. -R mysqld/

• 添加环境变量

vim /etc/profile
添加  export PATH=/home/mysqld/bin/:$PATH