Advertisement
Guest User

Untitled

a guest
Nov 27th, 2014
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.10 KB | None | 0 0
  1. mysql> show master status; show slave status \G
  2. +------------------+----------+--------------+---------------------------------------------+
  3. | File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
  4. +------------------+----------+--------------+---------------------------------------------+
  5. | mysql-bin.001214 | 65099377 | | information_schema,performance_schema,mysql |
  6. +------------------+----------+--------------+---------------------------------------------+
  7. 1 row in set (0.00 sec)
  8.  
  9. *************************** 1. row ***************************
  10. Slave_IO_State: Waiting for master to send event
  11. Master_Host: 197.189.236.234
  12. Master_User: replication
  13. Master_Port: 3306
  14. Connect_Retry: 60
  15. Master_Log_File: mysql-bin.000008
  16. Read_Master_Log_Pos: 19271860
  17. Relay_Log_File: slave-relay.000020
  18. Relay_Log_Pos: 40433911
  19. Relay_Master_Log_File: mysql-bin.000007
  20. Slave_IO_Running: Yes
  21. Slave_SQL_Running: Yes
  22. Replicate_Do_DB: dealguide_new
  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: 40433765
  32. Relay_Log_Space: 124130845
  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: 3834
  43. Master_SSL_Verify_Server_Cert: No
  44. Last_IO_Errno: 0
  45. Last_IO_Error:
  46. Last_SQL_Errno: 0
  47. Last_SQL_Error:
  48. Replicate_Ignore_Server_Ids:
  49. Master_Server_Id: 1
  50. 1 row in set (0.00 sec)
  51.  
  52. mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement