MYSQL 8.0- MySQL 5.7 热备有坑

SHOW SLAVE STATUS;

START SLAVE;

SHOW SLAVE STATUS\G;
SHOW MASTER STATUS;

CHANGE MASTER TO
MASTER_HOST='192.168.50.27',
MASTER_HOST=3306,
MASTER_USER='root',
MASTER_PASSWORD='Pay12345!',
master_log_fiel='mysql-master.000002',
MASTER_LOG_POS='155';

CHANGE MASTER TO
MASTER_HOST='192.168.50.27',
MASTER_PORT=3306,
MASTER_USER='root',
MASTER_PASSWORD='Pay12345!',
MASTER_LOG_FILE='mysql-master.000003',
MASTER_LOG_POS=155;

STOP SLAVE;
CHANGE MASTER TO MASTER_LOG_FILE='mysql-master.000004',MASTER_LOG_POS=155;
START SLAVE;

 

 

 

Last_SQL_Error: Error 'Character set '#255' is not a compiled cha
racter set and is not specified in the 'C:\Program Files\MySQL\MySQL Server 5.7\
share\charsets\Index.xml' file' on query. Default database: ''. Query: 'BEGIN'
  Replicate_Ignore_Server_Ids:

相关链接 https://www.linkedin.com/pulse/playing-mysql-80-midnight-does-replication-work-from-57-grippa