1.修改参数 master: gtid_mode = ON                        --开启gtid这个必须打开 enforce-gtid-consistency = ON    --开启gtid这个必须打开 slave_parallel_workers=4           --开启基于库的多线程复制默认0不开启  5.6只能支持一个数据库开启一个线程,5.7可以一个数据库开启多个线程 binlog_cache_size = 8M  max_binlog_size = 50M  max_binlog_cache_size = 100M  sync_binlog = 1  expire_logs_days = 1  log-slave-updates=true              --开启gtid这个必须打开   slave: binlog_format = row gtid_mode = ON enforce-gtid-consistency = ON binlog_cache_size = 8M max_binlog_size = 50M max_binlog_cache_size = 100M sync_binlog = 1 expire_logs_days = 1 slave_parallel_workers=4 max_relay_log_size = 50M relay_log_purge = 1 relay_log_recovery = 1   master_verify_checksum = 1        --主事件校验 slave_sql_verify_checksum = 1     --从事件校验 slave_allow_batching = 1 log-slave-updates=true   2.重启数据库 mysqladmin -uroot -hloalhost -p shutdown /usr/local/mysql/bin/mysqld_safe&   3.在slave端change change master to master_host='192.168.10.100', master_port=3306, master_user='repl', master_password='123456', master_auto_position=1; 4.查看 show slave status \G              Retrieved_Gtid_Set: 43ea2a1b-5fcc-11e8-8e35-000c29d02a8e:4             Executed_Gtid_Set: 43ea2a1b-5fcc-11e8-8e35-000c29d02a8e:1-4
扫码关注我们
微信号:SRE实战
拒绝背锅 运筹帷幄