问题大概是这样的:mysql主从复制,配置好之后,查看从表状态正常:
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
然后在主表插入数据,从表未同步,状态异常:
Slave_IO_Running: Yes
Slave_SQL_Running: No
具体情况如下:
主库在windows上,从库在虚拟机上;
主库配置 my.ini
[mysqld]
# 主从配置
# 日志文件名以“mysql-bin”作为前缀
log-bin=mysql-bin
server-id=1
binlog-do-db=blog
从库配置 my.cfg
[mysqld]
server-id = 2
port = 3306
log-bin=mysql-bin
binlog_format=mixed
windows执行show master status;显示如下
+------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------