Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # mysql commands to restart a slave
- On master:
- FLUSH TABLES WITH READ LOCK;
- SHOW MASTER STATUS;
- +------------------+----------+--------------+------------------+
- | File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
- +------------------+----------+--------------+------------------+
- | mysql-bin.000003 | 1380 | dbname | mysql |
- +------------------+----------+--------------+------------------+
- On slave:
- STOP SLAVE;
- CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000003', MASTER_LOG_POS=1380;
- START SLAVE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement