Advertisement
Guest User

Untitled

a guest
Jul 6th, 2016
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.65 KB | None | 0 0
  1. 3 Query SHOW SLAVE STATUS
  2. 3 Query SELECT COUNT(*) AS n FROM INFORMATION_SCHEMA.PROCESSLIST WHERE command='binlog dump'
  3. 3 Prepare SELECT Select_priv, Process_priv, Super_priv, Repl_slave_priv, Repl_client_priv, Reload_priv FROM mysql.user WHERE user = ? AND host = ?
  4. 3 Execute SELECT Select_priv, Process_priv, Super_priv, Repl_slave_priv, Repl_client_priv, Reload_priv FROM mysql.user WHERE user = 'root' AND host = '172.21.0.3'
  5. 3 Close stmt
  6. 3 Prepare SELECT Select_priv, Process_priv, Super_priv, Repl_slave_priv, Repl_client_priv, Reload_priv FROM mysql.user WHERE user = ? AND host = ?
  7. 3 Execute SELECT Select_priv, Process_priv, Super_priv, Repl_slave_priv, Repl_client_priv, Reload_priv FROM mysql.user WHERE user = 'root' AND host = '%'
  8. 3 Close stmt
  9. 3 Query SELECT Variable_name AS variable_name, Variable_Value AS value FROM information_schema.global_variables
  10. 3 Query SET default_master_connection=''
  11. 3 Query SELECT Variable_name AS variable_name, Variable_Value AS value FROM information_schema.global_status
  12. 3 Query SHOW SLAVE STATUS
  13. 4 Connect root@172.21.0.1 as anonymous on
  14. 4 Query SELECT @@max_allowed_packet
  15. 4 Query SET default_master_connection=''
  16. 4 Query RESET MASTER
  17. 4 Query STOP ALL SLAVES
  18. 4 Query SHOW ALL SLAVES STATUS
  19. 4 Query SET GLOBAL gtid_slave_pos=''
  20. 160706 12:21:57 4 Query CHANGE MASTER '' TO master_host='172.21.0.2', master_port=3306, master_user='root', master_password='admin', master_use_gtid=current_pos, master_connect_retry=10
  21. 4 Query START SLAVE ''
  22. 4 Query SET GLOBAL read_only=1
  23. 5 Connect Out root@172.21.0.2:3306
  24. 6 Query FLUSH TABLES
  25. 160706 12:21:58 3 Query SELECT Variable_name AS variable_name, Variable_Value AS value FROM information_schema.global_variables
  26. 3 Query SET default_master_connection=''
  27. 3 Query SELECT Variable_name AS variable_name, Variable_Value AS value FROM information_schema.global_status
  28. 3 Query SHOW SLAVE STATUS
  29. 3 Prepare SELECT Select_priv, Process_priv, Super_priv, Repl_slave_priv, Repl_client_priv, Reload_priv FROM mysql.user WHERE user = ? AND host = ?
  30. 3 Execute SELECT Select_priv, Process_priv, Super_priv, Repl_slave_priv, Repl_client_priv, Reload_priv FROM mysql.user WHERE user = 'root' AND host = '172.21.0.3'
  31. 3 Close stmt
  32. 3 Prepare SELECT Select_priv, Process_priv, Super_priv, Repl_slave_priv, Repl_client_priv, Reload_priv FROM mysql.user WHERE user = ? AND host = ?
  33. 3 Execute SELECT Select_priv, Process_priv, Super_priv, Repl_slave_priv, Repl_client_priv, Reload_priv FROM mysql.user WHERE user = 'root' AND host = '%'
  34. 3 Close stmt
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement