1，
在maste A上面创建专门用于备份的用户B
show master status
get log_file and log_pos
2,
CHANGE MASTER TO
MASTER_HOST=‘192.***.***.***‘,
MASTER_USER=‘repl_user‘,
MASTER_PASSWORD=‘hj3****‘,
MASTER_LOG_FILE=‘mysql-bin.000004‘,
MASTER_LOG_POS=7145;
mysql slave to master
标签：