托管MySQL：5.6 自建MySQL版本：5.7.31
1.下载备份
wget "xxxxxxxxxxxxxxxxx"
2.恢复全备
xbstream -x -C /data/mysql/data < full_backup.xbstream
3.解压缩
innobackupex --decompress --parallel=6 --compress-threads=6 /data/mysql/data
4.应用日志
innobackupex --defaults-file=/data/mysql/data/backup-my.cnf --use-memory=256M --apply-log /data/mysql/data
5.改属组属主
chown -R mysql:mysql /data/mysql/data/
6.启动
service mysqld start
7.升级数据
mysql_upgrade -uxxx -p
8.重启
service mysqld restart
9.1找change master log_file&pos
less xtrabackup_slave_info
9.2 确认rds上的binlog存在
SHOW BINARY LOGS;
10.授权复制用户
GRANT REPLICATION SLAVE, REPLICATION CLIENT ON . TO 'xxxxx'@'xx.xx.xx.xx' IDENTIFIED BY '*******';
11. change master
CHANGE MASTER TO
MASTER_HOST='xx.xx.xx.xx',
MASTER_USER='replication',
MASTER_PASSWORD='*******',
MASTER_PORT=3306,
MASTER_LOG_FILE='xxxxxx',
MASTER_LOG_POS=xxxxx,
MASTER_CONNECT_RETRY=10;
12.启从库复制
start slave;
13.查看主从复制状态
show slave status\G
Slave_IO_Running，Slave_SQL_Running 都为YES
另外以下值也需要关注：
Master_Log_File，Relay_Master_Log_File，Read_Master_Log_Pos，Exec_Master_Log_Pos。
至此，自建MySQL到rds主从复制搭建完成！
