MYSQL 8.0- MySQL 5.7 热备有坑

最新推荐文章于 2025-07-02 14:01:33 发布

原创最新推荐文章于 2025-07-02 14:01:33 发布 · 620 阅读

0 ·

CC 4.0 BY-SA版权

本文深入探讨了MySQL 8.0中复制配置的具体操作，包括使用SHOWSLAVESTATUS检查复制状态，通过STARTSLAVE和STOPSLAVE控制复制进程，以及利用CHANGEMASTERTO调整主从配置。提供了详细的SQL命令示例，如更改主机地址、端口、用户名、密码、日志文件和位置等关键参数。

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: