stop slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; reset master; reset slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; start slave; SET AUTOCOMMIT = 1; DROP DATABASE IF EXISTS mysqltest1; DROP DATABASE IF EXISTS mysqltest2; DROP DATABASE IF EXISTS mysqltest3; CREATE DATABASE mysqltest1; CREATE DATABASE mysqltest2; CREATE TABLE mysqltest1.t1 (f1 BIGINT) ENGINE= "InnoDB"; INSERT INTO mysqltest1.t1 SET f1= 0; CREATE TABLE mysqltest1.t2 (f1 BIGINT) ENGINE= "InnoDB"; CREATE TABLE mysqltest1.t3 (f1 BIGINT) ENGINE= "InnoDB"; CREATE TABLE mysqltest1.t4 (f1 BIGINT) ENGINE= "InnoDB"; CREATE TABLE mysqltest1.t5 (f1 BIGINT) ENGINE= "InnoDB"; CREATE TABLE mysqltest1.t6 (f1 BIGINT) ENGINE= "InnoDB"; CREATE INDEX my_idx6 ON mysqltest1.t6(f1); CREATE TABLE mysqltest1.t7 (f1 BIGINT) ENGINE= "InnoDB"; INSERT INTO mysqltest1.t7 SET f1= 0; CREATE TABLE mysqltest1.t8 (f1 BIGINT) ENGINE= "InnoDB"; CREATE TABLE mysqltest1.t9 (f1 BIGINT) ENGINE= "InnoDB"; CREATE TABLE mysqltest1.t10 (f1 BIGINT) ENGINE= "InnoDB"; CREATE TABLE mysqltest1.t11 (f1 BIGINT) ENGINE= "InnoDB"; CREATE TABLE mysqltest1.t12 (f1 BIGINT) ENGINE= "InnoDB"; CREATE TABLE mysqltest1.t13 (f1 BIGINT) ENGINE= "InnoDB"; CREATE TABLE mysqltest1.t14 (f1 BIGINT) ENGINE= "InnoDB"; CREATE TABLE mysqltest1.t15 (f1 BIGINT) ENGINE= "InnoDB"; CREATE TABLE mysqltest1.t16 (f1 BIGINT) ENGINE= "InnoDB"; CREATE TABLE mysqltest1.t17 (f1 BIGINT) ENGINE= "InnoDB"; CREATE TABLE mysqltest1.t18 (f1 BIGINT) ENGINE= "InnoDB"; CREATE TABLE mysqltest1.t19 (f1 BIGINT) ENGINE= "InnoDB"; CREATE TEMPORARY TABLE mysqltest1.t23 (f1 BIGINT); SET AUTOCOMMIT = 0; use mysqltest1; -------- switch to slave -------- SET AUTOCOMMIT = 0; use mysqltest1; -------- switch to master ------- ######## COMMIT ######## -------- switch to master ------- INSERT INTO t1 SET f1= 0 + 1; SELECT MAX(f1) FROM t1; MAX(f1) 1 SHOW BINLOG EVENTS IN 'master-bin.000001'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000001 # Query 1 # DROP DATABASE IF EXISTS mysqltest1 master-bin.000001 # Query 1 # DROP DATABASE IF EXISTS mysqltest2 master-bin.000001 # Query 1 # DROP DATABASE IF EXISTS mysqltest3 master-bin.000001 # Query 1 # CREATE DATABASE mysqltest1 master-bin.000001 # Query 1 # CREATE DATABASE mysqltest2 master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t1 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; INSERT INTO mysqltest1.t1 SET f1= 0 master-bin.000001 # Xid 1 # COMMIT /* xid=14 */ master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t2 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t3 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t4 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t5 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t6 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE INDEX my_idx6 ON mysqltest1.t6(f1) master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t7 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; INSERT INTO mysqltest1.t7 SET f1= 0 master-bin.000001 # Xid 1 # COMMIT /* xid=24 */ master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t8 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t9 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t10 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t11 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t12 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t13 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t14 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t15 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t16 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t17 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t18 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t19 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TEMPORARY TABLE mysqltest1.t23 (f1 BIGINT) -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 0 SHOW BINLOG EVENTS IN 'slave-bin.000001'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000001 # Query 2 # use `test`; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9 slave-bin.000001 # Query 1 # DROP DATABASE IF EXISTS mysqltest1 slave-bin.000001 # Query 1 # DROP DATABASE IF EXISTS mysqltest2 slave-bin.000001 # Query 1 # DROP DATABASE IF EXISTS mysqltest3 slave-bin.000001 # Query 1 # CREATE DATABASE mysqltest1 slave-bin.000001 # Query 1 # CREATE DATABASE mysqltest2 slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t1 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; INSERT INTO mysqltest1.t1 SET f1= 0 slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t2 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t3 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t4 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t5 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t6 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE INDEX my_idx6 ON mysqltest1.t6(f1) slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t7 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; INSERT INTO mysqltest1.t7 SET f1= 0 slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t8 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t9 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t10 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t11 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t12 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t13 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t14 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t15 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t16 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t17 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t18 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t19 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TEMPORARY TABLE mysqltest1.t23 (f1 BIGINT) -------- switch to master ------- COMMIT; SELECT MAX(f1) FROM t1; MAX(f1) 1 SHOW BINLOG EVENTS IN 'master-bin.000001'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000001 # Query 1 # DROP DATABASE IF EXISTS mysqltest1 master-bin.000001 # Query 1 # DROP DATABASE IF EXISTS mysqltest2 master-bin.000001 # Query 1 # DROP DATABASE IF EXISTS mysqltest3 master-bin.000001 # Query 1 # CREATE DATABASE mysqltest1 master-bin.000001 # Query 1 # CREATE DATABASE mysqltest2 master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t1 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; INSERT INTO mysqltest1.t1 SET f1= 0 master-bin.000001 # Xid 1 # COMMIT /* xid=14 */ master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t2 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t3 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t4 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t5 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t6 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE INDEX my_idx6 ON mysqltest1.t6(f1) master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t7 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; INSERT INTO mysqltest1.t7 SET f1= 0 master-bin.000001 # Xid 1 # COMMIT /* xid=24 */ master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t8 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t9 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t10 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t11 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t12 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t13 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t14 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t15 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t16 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t17 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t18 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t19 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TEMPORARY TABLE mysqltest1.t23 (f1 BIGINT) master-bin.000001 # Query 1 # use `mysqltest1`; BEGIN master-bin.000001 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 0 + 1 master-bin.000001 # Xid 1 # COMMIT /* xid=49 */ -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 1 SHOW BINLOG EVENTS IN 'slave-bin.000001'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000001 # Query 2 # use `test`; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9 slave-bin.000001 # Query 1 # DROP DATABASE IF EXISTS mysqltest1 slave-bin.000001 # Query 1 # DROP DATABASE IF EXISTS mysqltest2 slave-bin.000001 # Query 1 # DROP DATABASE IF EXISTS mysqltest3 slave-bin.000001 # Query 1 # CREATE DATABASE mysqltest1 slave-bin.000001 # Query 1 # CREATE DATABASE mysqltest2 slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t1 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; INSERT INTO mysqltest1.t1 SET f1= 0 slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t2 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t3 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t4 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t5 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t6 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE INDEX my_idx6 ON mysqltest1.t6(f1) slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t7 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; INSERT INTO mysqltest1.t7 SET f1= 0 slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t8 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t9 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t10 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t11 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t12 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t13 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t14 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t15 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t16 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t17 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t18 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t19 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TEMPORARY TABLE mysqltest1.t23 (f1 BIGINT) slave-bin.000001 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 0 + 1 -------- switch to master ------- ROLLBACK; SELECT MAX(f1) FROM t1; MAX(f1) 1 TEST-INFO: MASTER: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000001'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000001 # Query 1 # DROP DATABASE IF EXISTS mysqltest1 master-bin.000001 # Query 1 # DROP DATABASE IF EXISTS mysqltest2 master-bin.000001 # Query 1 # DROP DATABASE IF EXISTS mysqltest3 master-bin.000001 # Query 1 # CREATE DATABASE mysqltest1 master-bin.000001 # Query 1 # CREATE DATABASE mysqltest2 master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t1 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; INSERT INTO mysqltest1.t1 SET f1= 0 master-bin.000001 # Xid 1 # COMMIT /* xid=14 */ master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t2 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t3 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t4 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t5 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t6 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE INDEX my_idx6 ON mysqltest1.t6(f1) master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t7 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; INSERT INTO mysqltest1.t7 SET f1= 0 master-bin.000001 # Xid 1 # COMMIT /* xid=24 */ master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t8 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t9 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t10 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t11 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t12 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t13 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t14 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t15 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t16 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t17 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t18 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t19 (f1 BIGINT) ENGINE= "InnoDB" master-bin.000001 # Query 1 # use `test`; CREATE TEMPORARY TABLE mysqltest1.t23 (f1 BIGINT) master-bin.000001 # Query 1 # use `mysqltest1`; BEGIN master-bin.000001 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 0 + 1 master-bin.000001 # Xid 1 # COMMIT /* xid=49 */ -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 1 TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000001'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000001 # Query 2 # use `test`; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9 slave-bin.000001 # Query 1 # DROP DATABASE IF EXISTS mysqltest1 slave-bin.000001 # Query 1 # DROP DATABASE IF EXISTS mysqltest2 slave-bin.000001 # Query 1 # DROP DATABASE IF EXISTS mysqltest3 slave-bin.000001 # Query 1 # CREATE DATABASE mysqltest1 slave-bin.000001 # Query 1 # CREATE DATABASE mysqltest2 slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t1 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; INSERT INTO mysqltest1.t1 SET f1= 0 slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t2 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t3 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t4 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t5 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t6 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE INDEX my_idx6 ON mysqltest1.t6(f1) slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t7 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; INSERT INTO mysqltest1.t7 SET f1= 0 slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t8 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t9 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t10 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t11 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t12 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t13 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t14 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t15 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t16 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t17 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t18 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TABLE mysqltest1.t19 (f1 BIGINT) ENGINE= "InnoDB" slave-bin.000001 # Query 1 # use `test`; CREATE TEMPORARY TABLE mysqltest1.t23 (f1 BIGINT) slave-bin.000001 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 0 + 1 -------- switch to master ------- flush logs; -------- switch to slave -------- flush logs; -------- switch to master ------- ######## ROLLBACK ######## -------- switch to master ------- INSERT INTO t1 SET f1= 1 + 1; SELECT MAX(f1) FROM t1; MAX(f1) 2 SHOW BINLOG EVENTS IN 'master-bin.000002'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000002 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 1 SHOW BINLOG EVENTS IN 'slave-bin.000002'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000002 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- ROLLBACK; SELECT MAX(f1) FROM t1; MAX(f1) 1 SHOW BINLOG EVENTS IN 'master-bin.000002'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000002 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 1 SHOW BINLOG EVENTS IN 'slave-bin.000002'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000002 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- ROLLBACK; SELECT MAX(f1) FROM t1; MAX(f1) 1 TEST-INFO: MASTER: The INSERT is not committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000002'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000002 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 1 TEST-INFO: SLAVE: The INSERT is not committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000002'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000002 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- flush logs; -------- switch to slave -------- flush logs; -------- switch to master ------- ######## SET AUTOCOMMIT=1 ######## -------- switch to master ------- INSERT INTO t1 SET f1= 1 + 1; SELECT MAX(f1) FROM t1; MAX(f1) 2 SHOW BINLOG EVENTS IN 'master-bin.000003'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000003 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 1 SHOW BINLOG EVENTS IN 'slave-bin.000003'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000003 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- SET AUTOCOMMIT=1; SELECT MAX(f1) FROM t1; MAX(f1) 2 SHOW BINLOG EVENTS IN 'master-bin.000003'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000003 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000003 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 1 + 1 master-bin.000003 # Xid 1 # COMMIT /* xid=88 */ -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 2 SHOW BINLOG EVENTS IN 'slave-bin.000003'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000003 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000003 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 1 + 1 -------- switch to master ------- ROLLBACK; SELECT MAX(f1) FROM t1; MAX(f1) 2 TEST-INFO: MASTER: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000003'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000003 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000003 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 1 + 1 master-bin.000003 # Xid 1 # COMMIT /* xid=88 */ -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 2 TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000003'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000003 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000003 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 1 + 1 -------- switch to master ------- flush logs; -------- switch to slave -------- flush logs; -------- switch to master ------- SET AUTOCOMMIT=0; ######## START TRANSACTION ######## -------- switch to master ------- INSERT INTO t1 SET f1= 2 + 1; SELECT MAX(f1) FROM t1; MAX(f1) 3 SHOW BINLOG EVENTS IN 'master-bin.000004'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000004 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 2 SHOW BINLOG EVENTS IN 'slave-bin.000004'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000004 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- START TRANSACTION; SELECT MAX(f1) FROM t1; MAX(f1) 3 SHOW BINLOG EVENTS IN 'master-bin.000004'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000004 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000004 # Query 1 # use `mysqltest1`; BEGIN master-bin.000004 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 2 + 1 master-bin.000004 # Xid 1 # COMMIT /* xid=131 */ -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 3 SHOW BINLOG EVENTS IN 'slave-bin.000004'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000004 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000004 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 2 + 1 -------- switch to master ------- ROLLBACK; SELECT MAX(f1) FROM t1; MAX(f1) 3 TEST-INFO: MASTER: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000004'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000004 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000004 # Query 1 # use `mysqltest1`; BEGIN master-bin.000004 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 2 + 1 master-bin.000004 # Xid 1 # COMMIT /* xid=131 */ -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 3 TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000004'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000004 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000004 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 2 + 1 -------- switch to master ------- flush logs; -------- switch to slave -------- flush logs; -------- switch to master ------- ######## BEGIN ######## -------- switch to master ------- INSERT INTO t1 SET f1= 3 + 1; SELECT MAX(f1) FROM t1; MAX(f1) 4 SHOW BINLOG EVENTS IN 'master-bin.000005'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000005 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 3 SHOW BINLOG EVENTS IN 'slave-bin.000005'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000005 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- BEGIN; SELECT MAX(f1) FROM t1; MAX(f1) 4 SHOW BINLOG EVENTS IN 'master-bin.000005'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000005 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000005 # Query 1 # use `mysqltest1`; BEGIN master-bin.000005 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 3 + 1 master-bin.000005 # Xid 1 # COMMIT /* xid=143 */ -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 4 SHOW BINLOG EVENTS IN 'slave-bin.000005'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000005 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000005 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 3 + 1 -------- switch to master ------- ROLLBACK; SELECT MAX(f1) FROM t1; MAX(f1) 4 TEST-INFO: MASTER: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000005'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000005 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000005 # Query 1 # use `mysqltest1`; BEGIN master-bin.000005 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 3 + 1 master-bin.000005 # Xid 1 # COMMIT /* xid=143 */ -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 4 TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000005'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000005 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000005 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 3 + 1 -------- switch to master ------- flush logs; -------- switch to slave -------- flush logs; -------- switch to master ------- ######## DROP TABLE mysqltest1.t2 ######## -------- switch to master ------- INSERT INTO t1 SET f1= 4 + 1; SELECT MAX(f1) FROM t1; MAX(f1) 5 SHOW BINLOG EVENTS IN 'master-bin.000006'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000006 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 4 SHOW BINLOG EVENTS IN 'slave-bin.000006'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000006 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- DROP TABLE mysqltest1.t2; SELECT MAX(f1) FROM t1; MAX(f1) 5 SHOW BINLOG EVENTS IN 'master-bin.000006'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000006 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000006 # Query 1 # use `mysqltest1`; BEGIN master-bin.000006 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 4 + 1 master-bin.000006 # Xid 1 # COMMIT /* xid=170 */ master-bin.000006 # Query 1 # use `mysqltest1`; DROP TABLE mysqltest1.t2 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 5 SHOW BINLOG EVENTS IN 'slave-bin.000006'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000006 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000006 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 4 + 1 slave-bin.000006 # Query 1 # use `mysqltest1`; DROP TABLE mysqltest1.t2 -------- switch to master ------- ROLLBACK; SELECT MAX(f1) FROM t1; MAX(f1) 5 TEST-INFO: MASTER: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000006'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000006 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000006 # Query 1 # use `mysqltest1`; BEGIN master-bin.000006 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 4 + 1 master-bin.000006 # Xid 1 # COMMIT /* xid=170 */ master-bin.000006 # Query 1 # use `mysqltest1`; DROP TABLE mysqltest1.t2 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 5 TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000006'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000006 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000006 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 4 + 1 slave-bin.000006 # Query 1 # use `mysqltest1`; DROP TABLE mysqltest1.t2 -------- switch to master ------- flush logs; -------- switch to slave -------- flush logs; -------- switch to master ------- SHOW TABLES LIKE 't2'; Tables_in_mysqltest1 (t2) -------- switch to slave -------- SHOW TABLES LIKE 't2'; Tables_in_mysqltest1 (t2) -------- switch to master ------- ######## DROP TEMPORARY TABLE mysqltest1.t23 ######## -------- switch to master ------- INSERT INTO t1 SET f1= 5 + 1; SELECT MAX(f1) FROM t1; MAX(f1) 6 SHOW BINLOG EVENTS IN 'master-bin.000007'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000007 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 5 SHOW BINLOG EVENTS IN 'slave-bin.000007'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000007 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- DROP TEMPORARY TABLE mysqltest1.t23; SELECT MAX(f1) FROM t1; MAX(f1) 6 SHOW BINLOG EVENTS IN 'master-bin.000007'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000007 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 5 SHOW BINLOG EVENTS IN 'slave-bin.000007'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000007 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- ROLLBACK; Warnings: Warning 1196 Some non-transactional changed tables couldn't be rolled back SELECT MAX(f1) FROM t1; MAX(f1) 5 TEST-INFO: MASTER: The INSERT is not committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000007'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000007 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000007 # Query 1 # use `mysqltest1`; BEGIN master-bin.000007 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 5 + 1 master-bin.000007 # Query 1 # use `mysqltest1`; DROP TEMPORARY TABLE mysqltest1.t23 master-bin.000007 # Query 1 # use `mysqltest1`; ROLLBACK -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 6 TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000007'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000007 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000007 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 5 + 1 slave-bin.000007 # Query 1 # use `mysqltest1`; DROP TEMPORARY TABLE mysqltest1.t23 -------- switch to master ------- flush logs; -------- switch to slave -------- flush logs; -------- switch to master ------- SHOW TABLES LIKE 't23'; Tables_in_mysqltest1 (t23) -------- switch to slave -------- SHOW TABLES LIKE 't23'; Tables_in_mysqltest1 (t23) -------- switch to master ------- ######## RENAME TABLE mysqltest1.t3 to mysqltest1.t20 ######## -------- switch to master ------- INSERT INTO t1 SET f1= 5 + 1; SELECT MAX(f1) FROM t1; MAX(f1) 6 SHOW BINLOG EVENTS IN 'master-bin.000008'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000008 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 6 SHOW BINLOG EVENTS IN 'slave-bin.000008'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000008 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- RENAME TABLE mysqltest1.t3 to mysqltest1.t20; SELECT MAX(f1) FROM t1; MAX(f1) 6 SHOW BINLOG EVENTS IN 'master-bin.000008'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000008 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000008 # Query 1 # use `mysqltest1`; BEGIN master-bin.000008 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 5 + 1 master-bin.000008 # Xid 1 # COMMIT /* xid=227 */ master-bin.000008 # Query 1 # use `mysqltest1`; RENAME TABLE mysqltest1.t3 to mysqltest1.t20 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 6 SHOW BINLOG EVENTS IN 'slave-bin.000008'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000008 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000008 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 5 + 1 slave-bin.000008 # Query 1 # use `mysqltest1`; RENAME TABLE mysqltest1.t3 to mysqltest1.t20 -------- switch to master ------- ROLLBACK; SELECT MAX(f1) FROM t1; MAX(f1) 6 TEST-INFO: MASTER: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000008'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000008 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000008 # Query 1 # use `mysqltest1`; BEGIN master-bin.000008 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 5 + 1 master-bin.000008 # Xid 1 # COMMIT /* xid=227 */ master-bin.000008 # Query 1 # use `mysqltest1`; RENAME TABLE mysqltest1.t3 to mysqltest1.t20 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 6 TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000008'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000008 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000008 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 5 + 1 slave-bin.000008 # Query 1 # use `mysqltest1`; RENAME TABLE mysqltest1.t3 to mysqltest1.t20 -------- switch to master ------- flush logs; -------- switch to slave -------- flush logs; -------- switch to master ------- SHOW TABLES LIKE 't20'; Tables_in_mysqltest1 (t20) t20 -------- switch to slave -------- SHOW TABLES LIKE 't20'; Tables_in_mysqltest1 (t20) t20 -------- switch to master ------- ######## ALTER TABLE mysqltest1.t4 ADD column f2 BIGINT ######## -------- switch to master ------- INSERT INTO t1 SET f1= 6 + 1; SELECT MAX(f1) FROM t1; MAX(f1) 7 SHOW BINLOG EVENTS IN 'master-bin.000009'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000009 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 6 SHOW BINLOG EVENTS IN 'slave-bin.000009'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000009 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- ALTER TABLE mysqltest1.t4 ADD column f2 BIGINT; SELECT MAX(f1) FROM t1; MAX(f1) 7 SHOW BINLOG EVENTS IN 'master-bin.000009'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000009 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000009 # Query 1 # use `mysqltest1`; BEGIN master-bin.000009 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 6 + 1 master-bin.000009 # Xid 1 # COMMIT /* xid=256 */ master-bin.000009 # Query 1 # use `mysqltest1`; ALTER TABLE mysqltest1.t4 ADD column f2 BIGINT -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 7 SHOW BINLOG EVENTS IN 'slave-bin.000009'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000009 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000009 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 6 + 1 slave-bin.000009 # Query 1 # use `mysqltest1`; ALTER TABLE mysqltest1.t4 ADD column f2 BIGINT -------- switch to master ------- ROLLBACK; SELECT MAX(f1) FROM t1; MAX(f1) 7 TEST-INFO: MASTER: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000009'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000009 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000009 # Query 1 # use `mysqltest1`; BEGIN master-bin.000009 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 6 + 1 master-bin.000009 # Xid 1 # COMMIT /* xid=256 */ master-bin.000009 # Query 1 # use `mysqltest1`; ALTER TABLE mysqltest1.t4 ADD column f2 BIGINT -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 7 TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000009'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000009 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000009 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 6 + 1 slave-bin.000009 # Query 1 # use `mysqltest1`; ALTER TABLE mysqltest1.t4 ADD column f2 BIGINT -------- switch to master ------- flush logs; -------- switch to slave -------- flush logs; -------- switch to master ------- describe mysqltest1.t4; Field Type Null Key Default Extra f1 bigint(20) YES NULL f2 bigint(20) YES NULL -------- switch to slave -------- describe mysqltest1.t4; Field Type Null Key Default Extra f1 bigint(20) YES NULL f2 bigint(20) YES NULL -------- switch to master ------- ######## CREATE TABLE mysqltest1.t21 (f1 BIGINT) ENGINE= "InnoDB" ######## -------- switch to master ------- INSERT INTO t1 SET f1= 7 + 1; SELECT MAX(f1) FROM t1; MAX(f1) 8 SHOW BINLOG EVENTS IN 'master-bin.000010'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000010 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 7 SHOW BINLOG EVENTS IN 'slave-bin.000010'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000010 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- CREATE TABLE mysqltest1.t21 (f1 BIGINT) ENGINE= "InnoDB"; SELECT MAX(f1) FROM t1; MAX(f1) 8 SHOW BINLOG EVENTS IN 'master-bin.000010'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000010 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000010 # Query 1 # use `mysqltest1`; BEGIN master-bin.000010 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 7 + 1 master-bin.000010 # Xid 1 # COMMIT /* xid=285 */ master-bin.000010 # Query 1 # use `mysqltest1`; CREATE TABLE mysqltest1.t21 (f1 BIGINT) ENGINE= "InnoDB" -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 8 SHOW BINLOG EVENTS IN 'slave-bin.000010'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000010 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000010 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 7 + 1 slave-bin.000010 # Query 1 # use `mysqltest1`; CREATE TABLE mysqltest1.t21 (f1 BIGINT) ENGINE= "InnoDB" -------- switch to master ------- ROLLBACK; SELECT MAX(f1) FROM t1; MAX(f1) 8 TEST-INFO: MASTER: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000010'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000010 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000010 # Query 1 # use `mysqltest1`; BEGIN master-bin.000010 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 7 + 1 master-bin.000010 # Xid 1 # COMMIT /* xid=285 */ master-bin.000010 # Query 1 # use `mysqltest1`; CREATE TABLE mysqltest1.t21 (f1 BIGINT) ENGINE= "InnoDB" -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 8 TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000010'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000010 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000010 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 7 + 1 slave-bin.000010 # Query 1 # use `mysqltest1`; CREATE TABLE mysqltest1.t21 (f1 BIGINT) ENGINE= "InnoDB" -------- switch to master ------- flush logs; -------- switch to slave -------- flush logs; -------- switch to master ------- ######## CREATE TEMPORARY TABLE mysqltest1.t22 (f1 BIGINT) ######## -------- switch to master ------- INSERT INTO t1 SET f1= 8 + 1; SELECT MAX(f1) FROM t1; MAX(f1) 9 SHOW BINLOG EVENTS IN 'master-bin.000011'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000011 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 8 SHOW BINLOG EVENTS IN 'slave-bin.000011'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000011 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- CREATE TEMPORARY TABLE mysqltest1.t22 (f1 BIGINT); SELECT MAX(f1) FROM t1; MAX(f1) 9 SHOW BINLOG EVENTS IN 'master-bin.000011'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000011 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 8 SHOW BINLOG EVENTS IN 'slave-bin.000011'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000011 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- ROLLBACK; Warnings: Warning 1196 Some non-transactional changed tables couldn't be rolled back SELECT MAX(f1) FROM t1; MAX(f1) 8 TEST-INFO: MASTER: The INSERT is not committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000011'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000011 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000011 # Query 1 # use `mysqltest1`; BEGIN master-bin.000011 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 8 + 1 master-bin.000011 # Query 1 # use `mysqltest1`; CREATE TEMPORARY TABLE mysqltest1.t22 (f1 BIGINT) master-bin.000011 # Query 1 # use `mysqltest1`; ROLLBACK -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 9 TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000011'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000011 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000011 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 8 + 1 slave-bin.000011 # Query 1 # use `mysqltest1`; CREATE TEMPORARY TABLE mysqltest1.t22 (f1 BIGINT) -------- switch to master ------- flush logs; -------- switch to slave -------- flush logs; -------- switch to master ------- ######## TRUNCATE TABLE mysqltest1.t7 ######## -------- switch to master ------- INSERT INTO t1 SET f1= 8 + 1; SELECT MAX(f1) FROM t1; MAX(f1) 9 SHOW BINLOG EVENTS IN 'master-bin.000012'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000012 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 9 SHOW BINLOG EVENTS IN 'slave-bin.000012'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000012 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- TRUNCATE TABLE mysqltest1.t7; SELECT MAX(f1) FROM t1; MAX(f1) 9 SHOW BINLOG EVENTS IN 'master-bin.000012'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000012 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000012 # Query 1 # use `mysqltest1`; BEGIN master-bin.000012 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 8 + 1 master-bin.000012 # Xid 1 # COMMIT /* xid=342 */ master-bin.000012 # Query 1 # use `mysqltest1`; TRUNCATE TABLE mysqltest1.t7 master-bin.000012 # Xid 1 # COMMIT /* xid=363 */ -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 9 SHOW BINLOG EVENTS IN 'slave-bin.000012'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000012 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000012 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 8 + 1 slave-bin.000012 # Query 1 # use `mysqltest1`; TRUNCATE TABLE mysqltest1.t7 -------- switch to master ------- ROLLBACK; SELECT MAX(f1) FROM t1; MAX(f1) 9 TEST-INFO: MASTER: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000012'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000012 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000012 # Query 1 # use `mysqltest1`; BEGIN master-bin.000012 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 8 + 1 master-bin.000012 # Xid 1 # COMMIT /* xid=342 */ master-bin.000012 # Query 1 # use `mysqltest1`; TRUNCATE TABLE mysqltest1.t7 master-bin.000012 # Xid 1 # COMMIT /* xid=363 */ -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 9 TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000012'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000012 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000012 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 8 + 1 slave-bin.000012 # Query 1 # use `mysqltest1`; TRUNCATE TABLE mysqltest1.t7 -------- switch to master ------- flush logs; -------- switch to slave -------- flush logs; -------- switch to master ------- SELECT * FROM mysqltest1.t7; f1 -------- switch to slave -------- SELECT * FROM mysqltest1.t7; f1 -------- switch to master ------- ######## LOCK TABLES mysqltest1.t1 WRITE, mysqltest1.t8 READ ######## -------- switch to master ------- INSERT INTO t1 SET f1= 9 + 1; SELECT MAX(f1) FROM t1; MAX(f1) 10 SHOW BINLOG EVENTS IN 'master-bin.000013'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000013 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 9 SHOW BINLOG EVENTS IN 'slave-bin.000013'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000013 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- LOCK TABLES mysqltest1.t1 WRITE, mysqltest1.t8 READ; SELECT MAX(f1) FROM t1; MAX(f1) 10 SHOW BINLOG EVENTS IN 'master-bin.000013'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000013 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000013 # Query 1 # use `mysqltest1`; BEGIN master-bin.000013 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 9 + 1 master-bin.000013 # Xid 1 # COMMIT /* xid=369 */ -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 10 SHOW BINLOG EVENTS IN 'slave-bin.000013'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000013 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000013 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 9 + 1 -------- switch to master ------- ROLLBACK; SELECT MAX(f1) FROM t1; MAX(f1) 10 TEST-INFO: MASTER: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000013'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000013 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000013 # Query 1 # use `mysqltest1`; BEGIN master-bin.000013 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 9 + 1 master-bin.000013 # Xid 1 # COMMIT /* xid=369 */ -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 10 TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000013'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000013 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000013 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 9 + 1 -------- switch to master ------- flush logs; -------- switch to slave -------- flush logs; -------- switch to master ------- UNLOCK TABLES; ######## UNLOCK TABLES ######## -------- switch to master ------- INSERT INTO t1 SET f1= 10 + 1; SELECT MAX(f1) FROM t1; MAX(f1) 11 SHOW BINLOG EVENTS IN 'master-bin.000014'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000014 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 10 SHOW BINLOG EVENTS IN 'slave-bin.000014'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000014 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- UNLOCK TABLES; SELECT MAX(f1) FROM t1; MAX(f1) 11 SHOW BINLOG EVENTS IN 'master-bin.000014'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000014 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 10 SHOW BINLOG EVENTS IN 'slave-bin.000014'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000014 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- ROLLBACK; SELECT MAX(f1) FROM t1; MAX(f1) 10 TEST-INFO: MASTER: The INSERT is not committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000014'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000014 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 10 TEST-INFO: SLAVE: The INSERT is not committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000014'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000014 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- flush logs; -------- switch to slave -------- flush logs; -------- switch to master ------- LOCK TABLES mysqltest1.t1 READ; ######## UNLOCK TABLES ######## -------- switch to master ------- INSERT INTO t1 SET f1= 10 + 1; ERROR HY000: Table 't1' was locked with a READ lock and can't be updated SELECT MAX(f1) FROM t1; MAX(f1) 10 SHOW BINLOG EVENTS IN 'master-bin.000015'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000015 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 10 SHOW BINLOG EVENTS IN 'slave-bin.000015'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000015 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- UNLOCK TABLES; SELECT MAX(f1) FROM t1; MAX(f1) 10 SHOW BINLOG EVENTS IN 'master-bin.000015'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000015 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 10 SHOW BINLOG EVENTS IN 'slave-bin.000015'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000015 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- ROLLBACK; SELECT MAX(f1) FROM t1; MAX(f1) 10 TEST-INFO: MASTER: The INSERT is not committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000015'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000015 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 10 TEST-INFO: SLAVE: The INSERT is not committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000015'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000015 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- flush logs; -------- switch to slave -------- flush logs; -------- switch to master ------- LOCK TABLES mysqltest1.t1 WRITE, mysqltest1.t8 READ; ######## UNLOCK TABLES ######## -------- switch to master ------- INSERT INTO t1 SET f1= 10 + 1; SELECT MAX(f1) FROM t1; MAX(f1) 11 SHOW BINLOG EVENTS IN 'master-bin.000016'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000016 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 10 SHOW BINLOG EVENTS IN 'slave-bin.000016'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000016 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- UNLOCK TABLES; SELECT MAX(f1) FROM t1; MAX(f1) 11 SHOW BINLOG EVENTS IN 'master-bin.000016'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000016 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000016 # Query 1 # use `mysqltest1`; BEGIN master-bin.000016 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 10 + 1 master-bin.000016 # Xid 1 # COMMIT /* xid=462 */ -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 11 SHOW BINLOG EVENTS IN 'slave-bin.000016'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000016 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000016 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 10 + 1 -------- switch to master ------- ROLLBACK; SELECT MAX(f1) FROM t1; MAX(f1) 11 TEST-INFO: MASTER: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000016'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000016 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000016 # Query 1 # use `mysqltest1`; BEGIN master-bin.000016 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 10 + 1 master-bin.000016 # Xid 1 # COMMIT /* xid=462 */ -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 11 TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000016'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000016 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000016 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 10 + 1 -------- switch to master ------- flush logs; -------- switch to slave -------- flush logs; -------- switch to master ------- ######## DROP INDEX my_idx6 ON mysqltest1.t6 ######## -------- switch to master ------- INSERT INTO t1 SET f1= 11 + 1; SELECT MAX(f1) FROM t1; MAX(f1) 12 SHOW BINLOG EVENTS IN 'master-bin.000017'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000017 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 11 SHOW BINLOG EVENTS IN 'slave-bin.000017'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000017 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- DROP INDEX my_idx6 ON mysqltest1.t6; SELECT MAX(f1) FROM t1; MAX(f1) 12 SHOW BINLOG EVENTS IN 'master-bin.000017'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000017 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000017 # Query 1 # use `mysqltest1`; BEGIN master-bin.000017 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 11 + 1 master-bin.000017 # Xid 1 # COMMIT /* xid=482 */ master-bin.000017 # Query 1 # use `mysqltest1`; DROP INDEX my_idx6 ON mysqltest1.t6 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 12 SHOW BINLOG EVENTS IN 'slave-bin.000017'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000017 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000017 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 11 + 1 slave-bin.000017 # Query 1 # use `mysqltest1`; DROP INDEX my_idx6 ON mysqltest1.t6 -------- switch to master ------- ROLLBACK; SELECT MAX(f1) FROM t1; MAX(f1) 12 TEST-INFO: MASTER: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000017'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000017 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000017 # Query 1 # use `mysqltest1`; BEGIN master-bin.000017 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 11 + 1 master-bin.000017 # Xid 1 # COMMIT /* xid=482 */ master-bin.000017 # Query 1 # use `mysqltest1`; DROP INDEX my_idx6 ON mysqltest1.t6 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 12 TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000017'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000017 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000017 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 11 + 1 slave-bin.000017 # Query 1 # use `mysqltest1`; DROP INDEX my_idx6 ON mysqltest1.t6 -------- switch to master ------- flush logs; -------- switch to slave -------- flush logs; -------- switch to master ------- SHOW INDEX FROM mysqltest1.t6; Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment -------- switch to slave -------- SHOW INDEX FROM mysqltest1.t6; Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment -------- switch to master ------- ######## CREATE INDEX my_idx5 ON mysqltest1.t5(f1) ######## -------- switch to master ------- INSERT INTO t1 SET f1= 12 + 1; SELECT MAX(f1) FROM t1; MAX(f1) 13 SHOW BINLOG EVENTS IN 'master-bin.000018'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000018 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 12 SHOW BINLOG EVENTS IN 'slave-bin.000018'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000018 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- CREATE INDEX my_idx5 ON mysqltest1.t5(f1); SELECT MAX(f1) FROM t1; MAX(f1) 13 SHOW BINLOG EVENTS IN 'master-bin.000018'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000018 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000018 # Query 1 # use `mysqltest1`; BEGIN master-bin.000018 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 12 + 1 master-bin.000018 # Xid 1 # COMMIT /* xid=509 */ master-bin.000018 # Query 1 # use `mysqltest1`; CREATE INDEX my_idx5 ON mysqltest1.t5(f1) -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 13 SHOW BINLOG EVENTS IN 'slave-bin.000018'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000018 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000018 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 12 + 1 slave-bin.000018 # Query 1 # use `mysqltest1`; CREATE INDEX my_idx5 ON mysqltest1.t5(f1) -------- switch to master ------- ROLLBACK; SELECT MAX(f1) FROM t1; MAX(f1) 13 TEST-INFO: MASTER: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000018'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000018 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000018 # Query 1 # use `mysqltest1`; BEGIN master-bin.000018 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 12 + 1 master-bin.000018 # Xid 1 # COMMIT /* xid=509 */ master-bin.000018 # Query 1 # use `mysqltest1`; CREATE INDEX my_idx5 ON mysqltest1.t5(f1) -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 13 TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000018'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000018 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000018 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 12 + 1 slave-bin.000018 # Query 1 # use `mysqltest1`; CREATE INDEX my_idx5 ON mysqltest1.t5(f1) -------- switch to master ------- flush logs; -------- switch to slave -------- flush logs; -------- switch to master ------- SHOW INDEX FROM mysqltest1.t5; Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment t5 1 my_idx5 1 f1 A 0 NULL NULL YES BTREE -------- switch to slave -------- SHOW INDEX FROM mysqltest1.t5; Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment t5 1 my_idx5 1 f1 A NULL NULL NULL YES BTREE -------- switch to master ------- ######## DROP DATABASE mysqltest2 ######## -------- switch to master ------- INSERT INTO t1 SET f1= 13 + 1; SELECT MAX(f1) FROM t1; MAX(f1) 14 SHOW BINLOG EVENTS IN 'master-bin.000019'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000019 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 13 SHOW BINLOG EVENTS IN 'slave-bin.000019'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000019 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- DROP DATABASE mysqltest2; SELECT MAX(f1) FROM t1; MAX(f1) 14 SHOW BINLOG EVENTS IN 'master-bin.000019'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000019 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000019 # Query 1 # use `mysqltest1`; BEGIN master-bin.000019 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 13 + 1 master-bin.000019 # Xid 1 # COMMIT /* xid=538 */ master-bin.000019 # Query 1 # DROP DATABASE mysqltest2 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 14 SHOW BINLOG EVENTS IN 'slave-bin.000019'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000019 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000019 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 13 + 1 slave-bin.000019 # Query 1 # DROP DATABASE mysqltest2 -------- switch to master ------- ROLLBACK; SELECT MAX(f1) FROM t1; MAX(f1) 14 TEST-INFO: MASTER: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000019'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000019 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000019 # Query 1 # use `mysqltest1`; BEGIN master-bin.000019 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 13 + 1 master-bin.000019 # Xid 1 # COMMIT /* xid=538 */ master-bin.000019 # Query 1 # DROP DATABASE mysqltest2 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 14 TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000019'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000019 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000019 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 13 + 1 slave-bin.000019 # Query 1 # DROP DATABASE mysqltest2 -------- switch to master ------- flush logs; -------- switch to slave -------- flush logs; -------- switch to master ------- SHOW DATABASES LIKE "mysqltest2"; Database (mysqltest2) -------- switch to slave -------- SHOW DATABASES LIKE "mysqltest2"; Database (mysqltest2) -------- switch to master ------- ######## CREATE DATABASE mysqltest3 ######## -------- switch to master ------- INSERT INTO t1 SET f1= 14 + 1; SELECT MAX(f1) FROM t1; MAX(f1) 15 SHOW BINLOG EVENTS IN 'master-bin.000020'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000020 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 14 SHOW BINLOG EVENTS IN 'slave-bin.000020'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000020 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 -------- switch to master ------- CREATE DATABASE mysqltest3; SELECT MAX(f1) FROM t1; MAX(f1) 15 SHOW BINLOG EVENTS IN 'master-bin.000020'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000020 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000020 # Query 1 # use `mysqltest1`; BEGIN master-bin.000020 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 14 + 1 master-bin.000020 # Xid 1 # COMMIT /* xid=567 */ master-bin.000020 # Query 1 # CREATE DATABASE mysqltest3 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 15 SHOW BINLOG EVENTS IN 'slave-bin.000020'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000020 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000020 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 14 + 1 slave-bin.000020 # Query 1 # CREATE DATABASE mysqltest3 -------- switch to master ------- ROLLBACK; SELECT MAX(f1) FROM t1; MAX(f1) 15 TEST-INFO: MASTER: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000020'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000020 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4 master-bin.000020 # Query 1 # use `mysqltest1`; BEGIN master-bin.000020 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 14 + 1 master-bin.000020 # Xid 1 # COMMIT /* xid=567 */ master-bin.000020 # Query 1 # CREATE DATABASE mysqltest3 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 15 TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000020'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000020 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4 slave-bin.000020 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 14 + 1 slave-bin.000020 # Query 1 # CREATE DATABASE mysqltest3 -------- switch to master ------- flush logs; -------- switch to slave -------- flush logs; -------- switch to master ------- SHOW DATABASES LIKE "mysqltest3"; Database (mysqltest3) mysqltest3 -------- switch to slave -------- SHOW DATABASES LIKE "mysqltest3"; Database (mysqltest3) mysqltest3 -------- switch to master ------- DROP DATABASE IF EXISTS mysqltest1; DROP DATABASE IF EXISTS mysqltest2; DROP DATABASE IF EXISTS mysqltest3;