[摘要]+-----------------+----------+--------------+------------------+-------------------+row in set (0.0...
+-----------------+----------+--------------+------------------+-------------------+
row in set (0.00 sec)
在slave上,
[zejin] 3302>show slave status\G
*************************** 1. row ***************************
……
Relay_Master_Log_File: binlog57.000005
Exec_Master_Log_Pos: 154
……
检查这两项Relay_Master_Log_File的值大于binlog57.000005,
或者等于Relay_Master_Log_File等于binlog57.000005并且Exec_Master_Log_Pos的值大于等于154即可
或者slave直接用函数:
[zejin] 3302>SELECT MASTER_POS_WAIT('binlog57.000005', 154);
+-----------------------------------------+
关键词:详细说明MySQL5.7不停业务将传统复制变更为GTID复制的示例代码