先清空slave data目录
master:
mkdir /tmp/data;
sshfs -p 22 -o allow_other,exec [email protected]:/home/mysql5.7.39/data /tmp/data/;
xtrabackup –defaults-file=/home/mysql5.7.39/my.cnf –user=root -p –socket=/home/mysql5.7.39/data/mysql.sock –kill-long-queries-timeout=600 –kill-long-query-type=all –parallel=10 –tmpdir=./ –target-dir=./ –backup 2>all.log;
umount -f /tmp/data;
slave:
xtrabackup –defaults-file=/home/mysql5.7.39/my.cnf –user=root –prepare –target-dir=/home/mysql5.7.39/data
mysqld_safe –defaults-file=/home/mysql5.7.39/my.cnf –user=mysql –skip-slave-start &
重建复制关系即可
标签:39,mysql5.7,file,mysql,home,sshfs,data,重做 From: https://www.cnblogs.com/dba-oilz/p/17129363.html