win下maridb 10.1.8下主从复制配置

主库配置

server_id=1
read-only=0
replicate-do-db=mydata
log-bin=mysql-bin

主库权限设置

grant replication slave on *.* to'backup'@'%' identified by 'password';

flush privileges;

grant execute, select, show view, alter, alter routine, create, create routine, create temporary tables, create view, delete, drop, event, index, insert, references, trigger, update, lock tables on `mydata`.* to 'backup'@'%' with grant option
flush privileges;

show master status

从库配置：

server_id=2
read-only=1
replicate-do-db=mydata
log-bin=mysql-bin

change master to master_host='172.20.42.224', master_user='backup',master_password='password', master_log_file='mysql-bin.000085',master_log_pos=839, master_connect_retry=60,master_port=3307

注意点：mysql-bin.000085 和 839 这2个参数来自主库show master status的查询。

stop slave

start slave

show slave status

这三个状态 slave_io_state、slave_io_running、slave_sql_running 是yes，配置成功。