Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 3 Query SHOW SLAVE STATUS
- 3 Query SELECT COUNT(*) AS n FROM INFORMATION_SCHEMA.PROCESSLIST WHERE command='binlog dump'
- 3 Prepare SELECT Select_priv, Process_priv, Super_priv, Repl_slave_priv, Repl_client_priv, Reload_priv FROM mysql.user WHERE user = ? AND host = ?
- 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'
- 3 Close stmt
- 3 Prepare SELECT Select_priv, Process_priv, Super_priv, Repl_slave_priv, Repl_client_priv, Reload_priv FROM mysql.user WHERE user = ? AND host = ?
- 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 = '%'
- 3 Close stmt
- 3 Query SELECT Variable_name AS variable_name, Variable_Value AS value FROM information_schema.global_variables
- 3 Query SET default_master_connection=''
- 3 Query SELECT Variable_name AS variable_name, Variable_Value AS value FROM information_schema.global_status
- 3 Query SHOW SLAVE STATUS
- 4 Connect root@172.21.0.1 as anonymous on
- 4 Query SELECT @@max_allowed_packet
- 4 Query SET default_master_connection=''
- 4 Query RESET MASTER
- 4 Query STOP ALL SLAVES
- 4 Query SHOW ALL SLAVES STATUS
- 4 Query SET GLOBAL gtid_slave_pos=''
- 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
- 4 Query START SLAVE ''
- 4 Query SET GLOBAL read_only=1
- 5 Connect Out root@172.21.0.2:3306
- 6 Query FLUSH TABLES
- 160706 12:21:58 3 Query SELECT Variable_name AS variable_name, Variable_Value AS value FROM information_schema.global_variables
- 3 Query SET default_master_connection=''
- 3 Query SELECT Variable_name AS variable_name, Variable_Value AS value FROM information_schema.global_status
- 3 Query SHOW SLAVE STATUS
- 3 Prepare SELECT Select_priv, Process_priv, Super_priv, Repl_slave_priv, Repl_client_priv, Reload_priv FROM mysql.user WHERE user = ? AND host = ?
- 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'
- 3 Close stmt
- 3 Prepare SELECT Select_priv, Process_priv, Super_priv, Repl_slave_priv, Repl_client_priv, Reload_priv FROM mysql.user WHERE user = ? AND host = ?
- 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 = '%'
- 3 Close stmt
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement