Skip to content

Instantly share code, notes, and snippets.

@tanji
Created July 6, 2016 12:24
Show Gist options
  • Save tanji/f6ef0e261f73a59fd2935259a0821d3d to your computer and use it in GitHub Desktop.
Save tanji/f6ef0e261f73a59fd2935259a0821d3d to your computer and use it in GitHub Desktop.
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment