Step 3: read binlog position of MySQL primary server

  1. mysql> SHOW MASTER STATUS\G
  2. *************************** 1. row ***************************
  3.              File: master-bin.000002
  4.          Position: 1307
  5.      Binlog_Do_DB: test
  6.  Binlog_Ignore_DB: manual, mysql
  7. Executed_Gtid_Set: 3E11FA47-71CA-11E1-9E33-C80AA9429562:1-5
  8. 1 row in set (0.00 sec)