Advertisement
Guest User

Untitled

a guest
Apr 20th, 2016
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.82 KB | None | 0 0
  1. $ mytop
  2.  
  3. Id User Host/IP DB Time Cmd Query or State
  4. -- ---- ------- -- ---- --- ----------
  5. 322 system us 20715 Connec Reading event from the relay log
  6. 321 system us 7841 Connec Waiting for master to send event
  7.  
  8. $ mysql -e "SHOW SLAVE STATUSG"
  9. ************************** 1. row ***************************
  10. Slave_IO_State: Queueing master event to the relay log
  11. Master_Host: 192.168.1.2
  12. Master_User: repl
  13. Master_Port: 3306
  14. Connect_Retry: 60
  15. Master_Log_File: mysql-bin.000012
  16. Read_Master_Log_Pos: 576756032
  17. Relay_Log_File: mysql-relay-bin.000009
  18. Relay_Log_Pos: 22727176
  19. Relay_Master_Log_File: mysql-bin.000004
  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: 495891486
  32. Relay_Log_Space: 9166709033
  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: 20860
  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: 200
  50. Master_UUID: 11e5-fd4f-c54f4421-821c-f23c91b04219
  51. Master_Info_File: /var/lib/mysql/master.info
  52. SQL_Delay: 0
  53. SQL_Remaining_Delay: NULL
  54. Slave_SQL_Running_State: Reading event from the relay log
  55. Master_Retry_Count: 86400
  56. Master_Bind:
  57. Last_IO_Error_Timestamp:
  58. Last_SQL_Error_Timestamp:
  59. Master_SSL_Crl:
  60. Master_SSL_Crlpath:
  61. Retrieved_Gtid_Set:
  62. Executed_Gtid_Set:
  63. Auto_Position: 0
  64. Replicate_Rewrite_DB:
  65. Channel_Name:
  66. Master_TLS_Version:
  67.  
  68. Master_Log_File: mysql-bin.000012
  69. Read_Master_Log_Pos: 987405670
  70. Relay_Log_File: mysql-relay-bin.000009
  71. Relay_Log_Pos: 42272891
  72. Relay_Master_Log_File: mysql-bin.000004
  73. Slave_IO_Running: Yes
  74. Slave_SQL_Running: Yes
  75. Exec_Master_Log_Pos: 515437201
  76. Relay_Log_Space: 9577359044
  77. Until_Condition: None
  78. Until_Log_Pos: 0
  79. Master_SSL_Allowed: No
  80. Seconds_Behind_Master: 21000
  81. Slave_SQL_Running_State: Reading event from the relay log
  82. Master_Retry_Count: 86400
  83.  
  84. TheSlave$ mysql --host=TheMaster --user=repl --password=$slavepass
  85. mysql > SHOW GRANTS; /* successfully showing replication privileges */
  86.  
  87. master:my.cnf slave:my.cnf
  88. server_id 200 300
  89. innodb_buffer_pool_size 48G 32G
  90. binlog-do-db my_db1 [not set]
  91. binlog-do-db my_db2 [not set]
  92. binlog-do-db my_db3 [not set]
  93. relay-log [not set] /var/log/mysql/mysql-relay-bin.log
  94. binlog_format mixed [not set]
  95. log_bin /var/log/mysql/mysql-bin.log [not set]
  96. sync_binlog 1 [not set]
  97. log_slave_updates [not set] 1
  98. read_only [not set] 1
  99. slave_skip_errors [not set] 1062
  100.  
  101. mysql -e "SHOW SLAVE STATUSG"
  102. *************************** 1. row ***************************
  103. Slave_IO_State: Waiting for master to send event
  104. Master_Log_File: mysql-bin.000013
  105. Read_Master_Log_Pos: 924285271
  106. Relay_Log_File: mysql-relay-bin.000009
  107. Relay_Log_Pos: 252434322
  108. Relay_Master_Log_File: mysql-bin.000004
  109. Slave_IO_Running: Yes
  110. Slave_SQL_Running: Yes
  111. Last_Errno: 0
  112. Skip_Counter: 0
  113. Exec_Master_Log_Pos: 725598632
  114. Relay_Log_Space: 10587985446
  115. Until_Condition: None
  116. Until_Log_File:
  117. Until_Log_Pos: 0
  118. Seconds_Behind_Master: 21741
  119. Master_Server_Id: 200
  120. Master_Info_File: /var/lib/mysql/master.info
  121. SQL_Delay: 0
  122. SQL_Remaining_Delay: NULL
  123. Slave_SQL_Running_State: Reading event from the relay log
  124. Master_Retry_Count: 86400
  125. Auto_Position: 0
  126.  
  127. Id User Host/IP DB Time Cmd Query or State
  128. -- ---- ------- -- ---- --- ----------
  129. 322 system us my_db1 21817 Connec INSERT INTO my_db1.my_table1 ( id, name ) VALUES ( 500810952, 'foo'
  130. 321 system us 9634 Connec Waiting for master to send event
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement