cannot start in AUTO_POSITION mode: this server uses @@GLOBAL.GTID_MODE = OFF.

从库的启动时候遇到了问题

mysql> start slave;
ERROR 3112 (HY000): The replication receiver thread for channel '' cannot start in AUTO_POSITION mode: this server uses @@GLOBAL.GTID_MODE = OFF.

解决的办法

mysql> change master to master_auto_position=0;
Query OK, 0 rows affected (0.01 sec)

mysql> change master to master_host='ip',master_user='replication',master_port=3306,master_password='password',master_log_file='binlog.000006',master_log_pos=0; 

mysql> start slave;

mysql> show slave status\G