Guest User

Untitled

a guest
Feb 10th, 2019
166
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.84 KB | None | 0 0
  1. STOP SLAVE;
  2. SET GLOBAL sql_slave_skip_counter=1;
  3. START SLAVE;
  4.  
  5. Slave_IO_State: Waiting for master to send event
  6. Master_Host: 10.4.16.245
  7. Master_User: replicant
  8. Master_Port: 3306
  9. Connect_Retry: 60
  10. Master_Log_File: mysql-bin.001527
  11. Read_Master_Log_Pos: 554619670
  12. Relay_Log_File: relay-bin.004561
  13. Relay_Log_Pos: 554619815
  14. Relay_Master_Log_File: mysql-bin.001527
  15. Slave_IO_Running: Yes
  16. Slave_SQL_Running: Yes
  17. Replicate_Do_DB:
  18. Replicate_Ignore_DB: phpmyadmin
  19. Replicate_Do_Table:
  20. Replicate_Ignore_Table:
  21. Replicate_Wild_Do_Table:
  22. Replicate_Wild_Ignore_Table:
  23. Last_Errno: 0
  24. Last_Error:
  25. Skip_Counter: 0
  26. Exec_Master_Log_Pos: 554619670
  27. Relay_Log_Space: 554620007
  28. Until_Condition: None
  29. Until_Log_File:
  30. Until_Log_Pos: 0
  31. Master_SSL_Allowed: No
  32. Master_SSL_CA_File:
  33. Master_SSL_CA_Path:
  34. Master_SSL_Cert:
  35. Master_SSL_Cipher:
  36. Master_SSL_Key:
  37. Seconds_Behind_Master: 0
  38. Master_SSL_Verify_Server_Cert: No
  39. Last_IO_Errno: 0
  40. Last_IO_Error:
  41. Last_SQL_Errno: 0
  42. Last_SQL_Error:
  43.  
  44. CHANGE MASTER TO master_log_file='mysql-bin.001527',master_log_pos=554619670;
  45.  
  46. $ service mysql restart --skip-slave-start
  47.  
  48. mysql> SHOW SLAVE STATUSG
  49.  
  50. CHANGE MASTER TO master_log_file='mysql1-bin.000362'. master_log_pos=3384732;
  51.  
  52. CHANGE MASTER TO
  53. MASTER_HOST='IP Address of Master',
  54. MASTER_PORT=3306,
  55. MASTER_USER='Replication Username',
  56. MASTER_PASSWORD='Replication Password',
  57. MASTER_LOG_FILE='mysql1-bin.000362',
  58. MASTER_LOG_POS=3384732;
Add Comment
Please, Sign In to add comment