Re: SHOW MASTER result seems wrong

[Warwick Chapman]

Peter Brawley Wrote:
-------------------------------------------------------
> No error report there, I'd spot check arrival of
> slave updates.

pt-table-checksum has confirmed that the replica is exact.

But, I still don't know why SHOW MASTER STATUS on the slave produces incorrect information.

This is on the MASTER:

mysql> show master status;
+------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000061 | 46509835 | | | |
+------------------+----------+--------------+------------------+-------------------+
1 row in set (0,00 sec)

This is on the SLAVE:

mysql> show master status;
+------------------+----------+--------------+------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000005 | 154 | | | |
+------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)

Am I perhaps misunderstanding what SHOW MASTER STATUS does?