错误 | 解决 |
ERROR 1776 (HY000): Parameters MASTER_LOG_FILE, MASTER_LOG_POS, RELAY_LOG_FILE |
开启GTID后,5.6后,不需要手工确定主服务器的MASTER_LOG_FILE及MASTER_LOG_POS
mysql> change master to master_host='127.0.0.1',master_user='rep',master_password='rep',master_port=3306,master_auto_position=1; |
ERROR 1858 (HY000): sql_slave_skip_counter can not be set when the server is running |
https://www.cnblogs.com/zhoujinyi/p/4717951.html 解决方式,跳过一步: show slave statusG;找到主库binglog位置 mysqlbinlog 主库binlog.00008 stop slave; |