Advertisement
Guest User

Untitled

a guest
Jul 24th, 2017
449
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.64 KB | None | 0 0
  1. _thread is connecting.
  2.  
  3. Master version:5.6.23
  4. Slave Version:5.6.19
  5.  
  6. mysql> show slave status G
  7. *************************** 1. row ***************************
  8. Slave_IO_State: Connecting to master
  9. Master_Host: XXXXXXXXXXX
  10. Master_User: XXXXXX
  11. Master_Port: 3306
  12. Connect_Retry: 60
  13. Master_Log_File: cli-bin.000032
  14. Read_Master_Log_Pos: 713
  15. Relay_Log_File: relaylog.000001
  16. Relay_Log_Pos: 4
  17. Relay_Master_Log_File: cli-bin.000032
  18. Slave_IO_Running: Connecting
  19. Slave_SQL_Running: Yes
  20. Replicate_Do_DB:
  21. Replicate_Ignore_DB:
  22. Replicate_Do_Table:
  23. Replicate_Ignore_Table: mysql.plugin,innodb_memcache.cache_policies,mysql.rds_sysinfo,mysql.rds_replication_status,mysql.rds_history,innodb_memcache.config_options
  24. Replicate_Wild_Do_Table:
  25. Replicate_Wild_Ignore_Table:
  26. Last_Errno: 0
  27. Last_Error:
  28. Skip_Counter: 0
  29. Exec_Master_Log_Pos: 713
  30. Relay_Log_Space: 618
  31. Until_Condition: None
  32. Until_Log_File:
  33. Until_Log_Pos: 0
  34. Master_SSL_Allowed: No
  35. Master_SSL_CA_File:
  36. Master_SSL_CA_Path:
  37. Master_SSL_Cert:
  38. Master_SSL_Cipher:
  39. Master_SSL_Key:
  40. Seconds_Behind_Master: NULL
  41. Master_SSL_Verify_Server_Cert: No
  42. Last_IO_Errno: 0
  43. Last_IO_Error:
  44. Last_SQL_Errno: 0
  45. Last_SQL_Error:
  46. Replicate_Ignore_Server_Ids:
  47. Master_Server_Id: 0
  48. Master_UUID:
  49. Master_Info_File: mysql.slave_master_info
  50. SQL_Delay: 0
  51. SQL_Remaining_Delay: NULL
  52. Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
  53. Master_Retry_Count: 86400
  54. Master_Bind:
  55. Last_IO_Error_Timestamp:
  56. Last_SQL_Error_Timestamp:
  57. Master_SSL_Crl:
  58. Master_SSL_Crlpath:
  59. Retrieved_Gtid_Set:
  60. Executed_Gtid_Set:
  61. Auto_Position: 0
  62. 1 row in set (0.00 sec)
  63.  
  64. mysql> show global variables like '%old_passwords%';
  65. +---------------+-------+
  66. | Variable_name | Value |
  67. +---------------+-------+
  68. | old_passwords | 0 |
  69. +---------------+-------+
  70. 1 row in set (0.01 sec)
  71.  
  72. mysql> show global variables like '%secure_auth%';
  73. +---------------+-------+
  74. | Variable_name | Value |
  75. +---------------+-------+
  76. | secure_auth | OFF |
  77. +---------------+-------+
  78. 1 row in set (0.00 sec)
  79. ====================
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement