Previous Next

MySQL Replication

Setup 3 of 6

Record the binlog file and position! 
mysql> FLUSH TABLES WITH READ LOCK;

mysql> SHOW MASTER STATUS;

+---------------+-----------+--------------+------------------+
| File          | Position  | Binlog_Do_DB | Binlog_Ignore_DB |
+---------------+-----------+--------------+------------------+
| binlog.000017 | 550714602 |              |                  | 
+---------------+-----------+--------------+------------------+