更新时间:2022-08-13 21:11:37
第1步 登录数据库,查看所要恢复目标实例主从关系情况;
确认需要恢复实例有怎样的主从关系,查看目标实例的所有主实例,可参考如下命令:
>show slave status\G;
![](https://new-official-website-1256829807.cos.ap-shanghai.myqcloud.com/images/%E6%9F%A5%E7%9C%8B%E7%9B%AE%E6%A0%87%E5%AE%9E%E4%BE%8B%E7%9A%84%E6%89%80%E6%9C%89%E4%B8%BB%E5%AE%9E%E4%BE%8B.png)
查看目标实例的所有从实例:
> show slave status\G;
![](https://new-official-website-1256829807.cos.ap-shanghai.myqcloud.com/images/%E6%9F%A5%E7%9C%8B%E7%9B%AE%E6%A0%87%E5%AE%9E%E4%BE%8B%E7%9A%84%E6%89%80%E6%9C%89%E4%BB%8E%E5%AE%9E%E4%BE%8B.png)
第2步 断开恢复目标实例的主从关系,可参考操作命令如下(用户也可以使用其他方式断开主从关系):
>stop slave;
![](https://new-official-website-1256829807.cos.ap-shanghai.myqcloud.com/images/%E6%96%AD%E5%BC%80%E7%9B%AE%E6%A0%87%E8%8A%82%E7%82%B9%E4%B8%8A%E5%AE%9E%E4%BE%8B%E9%9B%86%E7%BE%A4%E6%9C%8D%E5%8A%A1.png)
查看当前实例主从关系情况,确认主动关系已断开,操作命令与执行结果如下:
>show slave status\G;
![](https://new-official-website-1256829807.cos.ap-shanghai.myqcloud.com/images/%E6%9F%A5%E7%9C%8B%E5%BD%93%E5%89%8D%E4%B8%BB%E4%BB%8E%E5%85%B3%E7%B3%BB%E6%83%85%E5%86%B5.png)
确认需要恢复实例有怎样的主从关系,查看目标实例的所有主实例,可参考如下命令:
>show slave status\G;
![](https://new-official-website-1256829807.cos.ap-shanghai.myqcloud.com/images/%E6%9F%A5%E7%9C%8B%E7%9B%AE%E6%A0%87%E5%AE%9E%E4%BE%8B%E7%9A%84%E6%89%80%E6%9C%89%E4%B8%BB%E5%AE%9E%E4%BE%8B.png)
查看目标实例的所有从实例:
> show slave status\G;
![](https://new-official-website-1256829807.cos.ap-shanghai.myqcloud.com/images/%E6%9F%A5%E7%9C%8B%E7%9B%AE%E6%A0%87%E5%AE%9E%E4%BE%8B%E7%9A%84%E6%89%80%E6%9C%89%E4%BB%8E%E5%AE%9E%E4%BE%8B.png)
第2步 断开恢复目标实例的主从关系,可参考操作命令如下(用户也可以使用其他方式断开主从关系):
>stop slave;
![](https://new-official-website-1256829807.cos.ap-shanghai.myqcloud.com/images/%E6%96%AD%E5%BC%80%E7%9B%AE%E6%A0%87%E8%8A%82%E7%82%B9%E4%B8%8A%E5%AE%9E%E4%BE%8B%E9%9B%86%E7%BE%A4%E6%9C%8D%E5%8A%A1.png)
查看当前实例主从关系情况,确认主动关系已断开,操作命令与执行结果如下:
>show slave status\G;
![](https://new-official-website-1256829807.cos.ap-shanghai.myqcloud.com/images/%E6%9F%A5%E7%9C%8B%E5%BD%93%E5%89%8D%E4%B8%BB%E4%BB%8E%E5%85%B3%E7%B3%BB%E6%83%85%E5%86%B5.png)
< 上一篇:
下一篇: >