Slave_IO_Running: Yes Slave_SQL_Running: No 解决方案

柔光的暖阳◎ 2023-10-09 12:37 36阅读 0赞

**问题：**  
Slave\_IO\_Running: Yes  
Slave\_SQL\_Running: No

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDI5NzMwMw_size_16_color_FFFFFF_t_70]  
salve 连接 master 成功，但是 slave 自己的 SQL 功能关闭了，这样是没办法完成主从复制的！

**解决：**

在 master 端：

记下 file 和 position

show master status;

![在这里插入图片描述][20190925201329894.png]

到slave服务器上执行手动同步

change master to 
    master_host='172.25.5.1',
    master_user='gtid',
    master_password='gtid123',
    master_port=3306,
    master_log_file='on.000002',
    master_log_pos=1340;

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDI5NzMwMw_size_16_color_FFFFFF_t_70 1]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDI5NzMwMw_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190925201657809.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDI5NzMwMw==,size_16,color_FFFFFF,t_70
[20190925201329894.png]: https://img-blog.csdnimg.cn/20190925201329894.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDI5NzMwMw_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/201909252017516.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDI5NzMwMw==,size_16,color_FFFFFF,t_70