主库配置:
master的标示
server-id=203
slave会基于此log-bin来做replication
log-bin=mysql-bin
用于master-slave的具体数据库
binlog-do-db=test
不用于master-slave的具体数据库
binlog_ignore_db=mysql
和binlog-do-db一样,可以设置多个
binlog_ignore_db=information_schema
主库命令行
CREATE USER ‘copy’@‘192.168.116.43.%’ IDENTIFIED BY ‘copy123456’;
GRANT REPLICATION SLAVE ON . TO ‘copy’@’%’;
grant replication slave on . to repl@‘192.168.116.43.%’ identified by ‘strong’
flush privileges;
show master status;
从数据库命令行:
change master to master_host=‘10.0.0.239’,master_port=7999,master_user=‘copy’,master_password=‘copy123456’,master_log_file=‘mysql-bin.000003’,master_log_pos=1762;
show slave status
start slave
stop slave
参考https://blog.csdn.net/sinat_33909283/article/details/89220140