博客摘录「 MySQL主从同步利用原有从库添加新从库」2023年4月3日

**飞星**

于 2023-04-03 16:55:31 发布

阅读量115

点赞数

文章标签：笔记

本文链接：https://blog.csdn.net/qq_38774360/article/details/129933886

版权

该文展示了如何检查两个MySQL从库的同步状态，通过`SHOWSLAVESTATUS`命令查看Slave_IO_Running和Slave_SQL_Running的状态以及日志位置，确认它们是否与主库保持一致。

摘要由CSDN通过智能技术生成

验证重库是否同步:老从库1 复制代码代码示例:mysql> slave start; mysql> show slave status\G; *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.6.53 Master_User: dongnan Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000097 Read_Master_Log_Pos: 21194359 Relay_Log_File: db1-relay-bin.000002 Relay_Log_Pos: 2037215 Relay_Master_Log_File: mysql-bin.000097 Slave_IO_Running: Yes Slave_SQL_Running: Yes新从库2 复制代码代码示例:mysql> show slave status\G; *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 192.168.6.53 Master_User: dongnan Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000097 Read_Master_Log_Pos: 21194359 Relay_Log_File: db1-relay-bin.000002 Relay_Log_Pos: 2037215 Relay_Master_Log_File: mysql-bin.000097 Slave_IO_Running: Yes Slave_SQL_Running: Yes