Mysql数据热迁移

假设要从A库迁移到B

在A库导出数据

在A建立主从同步用户

CREATE USER 'repl'@'%' IDENTIFIED WITH 'mysql_native_password' BY 'xxxxxx';
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%';
flush privileges;

A库

rsync -avzP -e "ssh -p 22" /data/xxx3337/docker-compose.yaml root@ip:/data/xxx3337/

B库运行数据库

docker-compose up -d

A库

rsync -avzP -e "ssh -p 22" /data/xxx3337/conf/conf.d/my.cnf root@ip:/data/xxx3337/conf/conf.d/

B库修改配置后

docker restart xxxx

B库查看同步位置

 head -50 /data/xxx3337/data/xxx.sql

CHANGE REPLICATION SOURCE TO 
    SOURCE_HOST='A库ip',
    SOURCE_USER='repl',
    SOURCE_PASSWORD='xxx',
    SOURCE_PORT=3306,
    SOURCE_LOG_FILE='mysql-bin.000013',
    SOURCE_LOG_POS=518553315;