mysql slave to master

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;

posted @ 2016-03-08 18:49  voh99800  阅读(178)  评论(0编辑  收藏  举报