To view the master status in Mysql replication ,use the following command in the master Mysql server as shown below

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

mysql> show master status \G
*************************** 1. row ***************************
            File: mysql-bin.000175
        Position: 4778491
    Binlog_Do_DB:
Binlog_Ignore_DB:
1 row in set (0.00 sec)

Post By Editor (2,827 Posts)

Website: →

Connect