mysql主从 主库Position不增加
请教各位大佬,搭建了一套mysql主从,主库中建表,插入数据,主库中Position不增长,导致从库也同步不过去,这是什么情况?忘各位大佬不吝赐教!
mysql> show master status\G
*************************** 1. row ***************************
File: mysql-bin.000005
Position: 590
Binlog_Do_DB: btbzb_zmhk,test
Binlog_Ignore_DB: mysql,information_schema,performance_schema
Executed_Gtid_Set:
1 row in set (0.00 sec)
mysql>
mysql> insert into test.employee (name,phone) values ('zm',18888888888);
Query OK, 1 row affected (0.06 sec)
mysql> insert into test.employee (name,phone) values ('zm',18888888888);
Query OK, 1 row affected (0.04 sec)
mysql> insert into test.employee (name,phone) values ('zm',18888888888);
Query OK, 1 row affected (0.09 sec)
mysql> insert into test.employee (name,phone) values ('zm',18888888888);
Query OK, 1 row affected (0.02 sec)
mysql> insert into test.employee (name,phone) values ('zm',18888888888);
Query OK, 1 row affected (0.03 sec)
mysql> show master status\G
*************************** 1. row ***************************
File: mysql-bin.000005
Position: 590
Binlog_Do_DB: btbzb_zmhk,test
Binlog_Ignore_DB: mysql,information_schema,performance_schema
Executed_Gtid_Set:
1 row in set (0.00 sec)
mysql>