MySQL——主从复制

进入mysql3306【主库】

mysql -S /data/3306/mysql.sock

log_bin为1

server_id 一致

创建用户

create user 'repl'@'%' identiied by '123456';

授权

grant replication slave on *.* to repl@'%';

进入3307【从库】

mysql -S /data/3307/mysql.sock

3307同样创建用户，授权

CHANGE MASTER TO

  MASTER_HOST='本地',

  MASTER_USER='repl',

  MASTER_PASSWORD='123',

  MASTER_PORT=3306,【主库的server_id】

  MASTER_LOG_FILE='mysql-bin.000001',

  MASTER_LOG_POS=653,

  MASTER_CONNECT_RETRY=10;

【MASTER_LOG_FILE='mysql-bin.000001',

  MASTER_LOG_POS=653,

通过show master status

show slave status\G  查看是否成功