Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. SHOW MASTER STATUS;
  2. Copied the values of MASTER_LOG_FILE and MASTER_LOG_POS.
  3.  
  4. STOP SLAVE;
  5. RESET SLAVE;
  6. CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=98; (<- example values)
  7. START SLAVE;
  8. SHOW SLAVE STATUS G;
  9.  
  10. Slave_IO_State Waiting for master to send event
  11. Master_Host xxx.xxx.xxx.xxx
  12. Master_User repl
  13. Master_Port 3306
  14. Connect_Retry 60
  15. Master_Log_File mysql-bin.000006
  16. Read_Master_Log_Pos 787956776
  17. Relay_Log_File mysql-relay-bin.000004
  18. Relay_Log_Pos 624412
  19. Relay_Master_Log_File mysql-bin.000006
  20. Slave_IO_Running Yes
  21. Slave_SQL_Running Yes
  22. Replicate_Do_DB
  23. Replicate_Ignore_DB
  24. Replicate_Do_Table
  25. Replicate_Ignore_Table
  26. Replicate_Wild_Do_Table
  27. Replicate_Wild_Ignore_Table
  28. Last_Errno 0
  29. Last_Error
  30. Skip_Counter 0
  31. Exec_Master_Log_Pos 787956776
  32. Relay_Log_Space 788197
  33. Until_Condition None
  34. Until_Log_File
  35. Until_Log_Pos 0
  36. Master_SSL_Allowed No
  37. Master_SSL_CA_File
  38. Master_SSL_CA_Path
  39. Master_SSL_Cert
  40. Master_SSL_Cipher
  41. Master_SSL_Key
  42. Seconds_Behind_Master 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement