Advertisement
Guest User

Untitled

a guest
May 11th, 2016
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. # for get log file and log pos
  2. SHOW MASTER STATUS;
  3.  
  4. # run on each server
  5. SLAVE STOP;
  6. CHANGE
  7. MASTER TO MASTER_HOST = '%IP%',
  8. MASTER_USER = '%USER%',
  9. MASTER_PASSWORD = '%PASSWORD%',
  10. MASTER_LOG_FILE = 'mysql-bin.%NUM%',
  11. MASTER_LOG_POS = %NUM%;
  12. SLAVE START;
  13.  
  14. # check status
  15. SHOW GLOBAL STATUS like 'slave_running';
  16. SHOW SLAVE STATUS;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement