Created
July 6, 2016 12:24
-
-
Save tanji/f6ef0e261f73a59fd2935259a0821d3d to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 [email protected] 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 [email protected]: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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment