Guest User

Untitled

a guest
Apr 13th, 2018
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.36 KB | None | 0 0
  1. # Run this on db-02 only
  2. sudo /etc/init.d/mysql restart
  3. mysql -u root -p
  4. Enter password: [enter the MySQL root password you chose earlier]
  5. mysql> show slave status \G
  6. *************************** 1. row ***************************
  7. Slave_IO_State: Waiting for master to send event
  8. Master_Host: 193.219.108.241
  9. Master_User: replication
  10. Master_Port: 3306
  11. Connect_Retry: 60
  12. Master_Log_File: mysql-bin.000005
  13. Read_Master_Log_Pos: 98
  14. Relay_Log_File: mysqld-relay-bin.000004
  15. Relay_Log_Pos: 235
  16. Relay_Master_Log_File: mysql-bin.000005
  17. Slave_IO_Running: Yes
  18. Slave_SQL_Running: Yes
  19. Replicate_Do_DB:
  20. Replicate_Ignore_DB:
  21. Replicate_Do_Table:
  22. Replicate_Ignore_Table:
  23. Replicate_Wild_Do_Table:
  24. Replicate_Wild_Ignore_Table:
  25. Last_Errno: 0
  26. Last_Error:
  27. Skip_Counter: 0
  28. Exec_Master_Log_Pos: 98
  29. Relay_Log_Space: 235
  30. Until_Condition: None
  31. Until_Log_File:
  32. Until_Log_Pos: 0
  33. Master_SSL_Allowed: No
  34. Master_SSL_CA_File:
  35. Master_SSL_CA_Path:
  36. Master_SSL_Cert:
  37. Master_SSL_Cipher:
  38. Master_SSL_Key:
  39. Seconds_Behind_Master: 0
  40. 1 row in set (0.00 sec)
Add Comment
Please, Sign In to add comment