主数据库上showmasterstatus\G;***************************1.row***************************File:mysql-bin.000166Position:38515Binlog_Do_DB:epgdb,mamdb,crcdbBinlog_Ignore_DB:...
主数据库上
show master status\G;
*************************** 1. row ***************************
File: mysql-bin.000166
Position: 38515
Binlog_Do_DB: epgdb,mamdb,crcdb
Binlog_Ignore_DB: mysql,test,information_schema
1 row in set (0.00 sec)
再查看从数据库
show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.2.210
Master_User: root
Master_Port: 3306
Connect_Retry: 120
Master_Log_File: mysql-bin.000166
Read_Master_Log_Pos: 204827
.........
发现 Master_Log_File 和 Read_Master_Log_Pos和主的不一样了,是不是重启主备数据库后,从备就不能够同步了???
展开