【无标题】

read_only=1

############多线程复制##############

slave_parallel_type=LOGICAL_CLOCK

slave_parallel_workers=4

########semi sync replication settings########

plugin-load="rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so"

rpl_semi_sync_master_enabled=1

rpl_semi_sync_slave_enabled=1

rpl_semi_sync_master_timeout=1000

#rpl_semi_sync_master_wait_point=AFTER_COMMIT;

create user repl@'%' identified with mysql_native_password by 'replERThb$.9mdIc';

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

flush privileges;

stop slave;

reset slave;

reset master;

root/PrdRootpwd&123

repl/replERThb$.9mdIc

222结点：

change master to master_host='10.213.13.221', master_user='repl', master_password='replERThb$.9mdIc', master_port=63306, master_auto_position=1;

start slave;

show slave status\G