1、数据不一致
2、日志不同步show master logs, slave 比master少,大小也不同
3、master写入的数据,slave并未同步
slave上 show processlist,
State
:
Has read all relay
log
; waiting
for
the slave I
/
O thread to update it
show slave status
Connect_Retry
:
60
Master_Log_File : mysql - binlog . 000024
Read_Master_Log_Pos : 273
Relay_Log_File : 00cdde7c5b1d400 - relay - bin . 000007
Relay_Log_Pos : 254
Relay_Master_Log_File : mysql - binlog . 000024
Slave_IO_Running : Yes
Slave_SQL_Running : Yes
Replicate_Do_DB : testms
Seconds_Behind_Master : 0
Master_Log_File : mysql - binlog . 000024
Read_Master_Log_Pos : 273
Relay_Log_File : 00cdde7c5b1d400 - relay - bin . 000007
Relay_Log_Pos : 254
Relay_Master_Log_File : mysql - binlog . 000024
Slave_IO_Running : Yes
Slave_SQL_Running : Yes
Replicate_Do_DB : testms
Seconds_Behind_Master : 0
4、master上 show slave hosts 为空