diff options
| author | unknown <lars@mysql.com> | 2005-06-01 15:52:32 +0200 |
|---|---|---|
| committer | unknown <lars@mysql.com> | 2005-06-01 15:52:32 +0200 |
| commit | de78f2e593aa429dff4e74ab23730608bd98204b (patch) | |
| tree | cea8de3d569e508e26d6f3cefee0a5c68969cce9 /mysql-test/r/rpl_ddl.result | |
| parent | 6e7dd94ea4622dad0cd01672561ffd818e42c638 (diff) | |
| download | mariadb-git-de78f2e593aa429dff4e74ab23730608bd98204b.tar.gz | |
BUG#6883: Added tests for create/drop temporary table, UNLOCK TABLES
If a create table can not do implicit commit, the stmt now fails
CREATE/DROP TEMPORARY TABLE is now flushed to binlog
mysql-test/include/rpl_stmt_seq.inc:
Documentation, cleared up code
mysql-test/r/rpl_ddl.result:
New results
mysql-test/t/rpl_ddl.test:
Added tests for create/drop temporary table
Added tests for different types of locks in UNLOCK TABLES
Cleared up code/documentation
sql/sql_parse.cc:
If A CREATE TABLE fails to do implicit commit, then the stmt now fails (DROP works in same way)
CREATE/DROP TEMOPORARY TABLE is now flushed to binlog
Diffstat (limited to 'mysql-test/r/rpl_ddl.result')
| -rw-r--r-- | mysql-test/r/rpl_ddl.result | 1252 |
1 files changed, 760 insertions, 492 deletions
diff --git a/mysql-test/r/rpl_ddl.result b/mysql-test/r/rpl_ddl.result index 7e544a609e8..9e3f76fe0bb 100644 --- a/mysql-test/r/rpl_ddl.result +++ b/mysql-test/r/rpl_ddl.result @@ -5,40 +5,40 @@ reset slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; start slave; SET AUTOCOMMIT = 1; -DROP DATABASE IF EXISTS d1; -DROP DATABASE IF EXISTS d2; -DROP DATABASE IF EXISTS d3; -CREATE DATABASE d1; -CREATE DATABASE d2; -CREATE TABLE d1.t1 (f1 BIGINT) ENGINE= "InnoDB"; -INSERT INTO d1.t1 SET f1= 0; -CREATE TABLE d1.t2 (f1 BIGINT) ENGINE= "InnoDB"; -CREATE TABLE d1.t3 (f1 BIGINT) ENGINE= "InnoDB"; -CREATE TABLE d1.t4 (f1 BIGINT) ENGINE= "InnoDB"; -CREATE TABLE d1.t5 (f1 BIGINT) ENGINE= "InnoDB"; -CREATE TABLE d1.t6 (f1 BIGINT) ENGINE= "InnoDB"; -CREATE INDEX my_idx6 ON d1.t6(f1); -CREATE TABLE d1.t7 (f1 BIGINT) ENGINE= "InnoDB"; -INSERT INTO d1.t7 SET f1= 0; -CREATE TABLE d1.t8 (f1 BIGINT) ENGINE= "InnoDB"; -CREATE TABLE d1.t9 (f1 BIGINT) ENGINE= "InnoDB"; -CREATE TABLE d1.t10 (f1 BIGINT) ENGINE= "InnoDB"; -CREATE TABLE d1.t11 (f1 BIGINT) ENGINE= "InnoDB"; -CREATE TABLE d1.t12 (f1 BIGINT) ENGINE= "InnoDB"; -CREATE TABLE d1.t13 (f1 BIGINT) ENGINE= "InnoDB"; -CREATE TABLE d1.t14 (f1 BIGINT) ENGINE= "InnoDB"; -CREATE TABLE d1.t15 (f1 BIGINT) ENGINE= "InnoDB"; -CREATE TABLE d1.t16 (f1 BIGINT) ENGINE= "InnoDB"; -CREATE TABLE d1.t17 (f1 BIGINT) ENGINE= "InnoDB"; -CREATE TABLE d1.t18 (f1 BIGINT) ENGINE= "InnoDB"; -CREATE TABLE d1.t19 (f1 BIGINT) ENGINE= "InnoDB"; -COMMIT; +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 d1; +use mysqltest1; -------- switch to slave -------- -SET AUTOCOMMIT = 1; -use d1; +SET AUTOCOMMIT = 0; +use mysqltest1; -------- switch to master ------- @@ -51,34 +51,35 @@ MAX(f1) 1 SHOW BINLOG EVENTS IN 'master-bin.000001'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000001 4 Start 1 4 Server ver: VERSION, Binlog ver: 3 -master-bin.000001 79 Query 1 79 DROP DATABASE IF EXISTS d1 -master-bin.000001 138 Query 1 138 DROP DATABASE IF EXISTS d2 -master-bin.000001 197 Query 1 197 DROP DATABASE IF EXISTS d3 -master-bin.000001 256 Query 1 256 CREATE DATABASE d1 -master-bin.000001 307 Query 1 307 CREATE DATABASE d2 -master-bin.000001 358 Query 1 358 use `test`; CREATE TABLE d1.t1 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 440 Query 1 440 use `test`; INSERT INTO d1.t1 SET f1= 0 -master-bin.000001 502 Query 1 502 use `test`; CREATE TABLE d1.t2 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 584 Query 1 584 use `test`; CREATE TABLE d1.t3 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 666 Query 1 666 use `test`; CREATE TABLE d1.t4 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 748 Query 1 748 use `test`; CREATE TABLE d1.t5 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 830 Query 1 830 use `test`; CREATE TABLE d1.t6 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 912 Query 1 912 use `test`; CREATE INDEX my_idx6 ON d1.t6(f1) -master-bin.000001 980 Query 1 980 use `test`; CREATE TABLE d1.t7 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1062 Query 1 1062 use `test`; INSERT INTO d1.t7 SET f1= 0 -master-bin.000001 1124 Query 1 1124 use `test`; CREATE TABLE d1.t8 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1206 Query 1 1206 use `test`; CREATE TABLE d1.t9 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1288 Query 1 1288 use `test`; CREATE TABLE d1.t10 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1371 Query 1 1371 use `test`; CREATE TABLE d1.t11 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1454 Query 1 1454 use `test`; CREATE TABLE d1.t12 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1537 Query 1 1537 use `test`; CREATE TABLE d1.t13 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1620 Query 1 1620 use `test`; CREATE TABLE d1.t14 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1703 Query 1 1703 use `test`; CREATE TABLE d1.t15 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1786 Query 1 1786 use `test`; CREATE TABLE d1.t16 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1869 Query 1 1869 use `test`; CREATE TABLE d1.t17 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1952 Query 1 1952 use `test`; CREATE TABLE d1.t18 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 2035 Query 1 2035 use `test`; CREATE TABLE d1.t19 (f1 BIGINT) ENGINE= "InnoDB" +master-bin.000001 # Start 1 # Server ver: VERSION, Binlog ver: 3 +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 # 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 # 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; @@ -86,35 +87,36 @@ MAX(f1) 0 SHOW BINLOG EVENTS IN 'slave-bin.000001'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000001 4 Start 2 4 Server ver: VERSION, Binlog ver: 3 -slave-bin.000001 79 Query 2 79 use `test`; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9 -slave-bin.000001 161 Query 1 161 DROP DATABASE IF EXISTS d1 -slave-bin.000001 220 Query 1 220 DROP DATABASE IF EXISTS d2 -slave-bin.000001 279 Query 1 279 DROP DATABASE IF EXISTS d3 -slave-bin.000001 338 Query 1 338 CREATE DATABASE d1 -slave-bin.000001 389 Query 1 389 CREATE DATABASE d2 -slave-bin.000001 440 Query 1 440 use `test`; CREATE TABLE d1.t1 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 522 Query 1 522 use `test`; INSERT INTO d1.t1 SET f1= 0 -slave-bin.000001 584 Query 1 584 use `test`; CREATE TABLE d1.t2 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 666 Query 1 666 use `test`; CREATE TABLE d1.t3 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 748 Query 1 748 use `test`; CREATE TABLE d1.t4 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 830 Query 1 830 use `test`; CREATE TABLE d1.t5 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 912 Query 1 912 use `test`; CREATE TABLE d1.t6 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 994 Query 1 994 use `test`; CREATE INDEX my_idx6 ON d1.t6(f1) -slave-bin.000001 1062 Query 1 1062 use `test`; CREATE TABLE d1.t7 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1144 Query 1 1144 use `test`; INSERT INTO d1.t7 SET f1= 0 -slave-bin.000001 1206 Query 1 1206 use `test`; CREATE TABLE d1.t8 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1288 Query 1 1288 use `test`; CREATE TABLE d1.t9 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1370 Query 1 1370 use `test`; CREATE TABLE d1.t10 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1453 Query 1 1453 use `test`; CREATE TABLE d1.t11 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1536 Query 1 1536 use `test`; CREATE TABLE d1.t12 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1619 Query 1 1619 use `test`; CREATE TABLE d1.t13 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1702 Query 1 1702 use `test`; CREATE TABLE d1.t14 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1785 Query 1 1785 use `test`; CREATE TABLE d1.t15 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1868 Query 1 1868 use `test`; CREATE TABLE d1.t16 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1951 Query 1 1951 use `test`; CREATE TABLE d1.t17 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 2034 Query 1 2034 use `test`; CREATE TABLE d1.t18 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 2117 Query 1 2117 use `test`; CREATE TABLE d1.t19 (f1 BIGINT) ENGINE= "InnoDB" +slave-bin.000001 # Start 2 # Server ver: VERSION, Binlog ver: 3 +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; @@ -123,37 +125,38 @@ MAX(f1) 1 SHOW BINLOG EVENTS IN 'master-bin.000001'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000001 4 Start 1 4 Server ver: VERSION, Binlog ver: 3 -master-bin.000001 79 Query 1 79 DROP DATABASE IF EXISTS d1 -master-bin.000001 138 Query 1 138 DROP DATABASE IF EXISTS d2 -master-bin.000001 197 Query 1 197 DROP DATABASE IF EXISTS d3 -master-bin.000001 256 Query 1 256 CREATE DATABASE d1 -master-bin.000001 307 Query 1 307 CREATE DATABASE d2 -master-bin.000001 358 Query 1 358 use `test`; CREATE TABLE d1.t1 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 440 Query 1 440 use `test`; INSERT INTO d1.t1 SET f1= 0 -master-bin.000001 502 Query 1 502 use `test`; CREATE TABLE d1.t2 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 584 Query 1 584 use `test`; CREATE TABLE d1.t3 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 666 Query 1 666 use `test`; CREATE TABLE d1.t4 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 748 Query 1 748 use `test`; CREATE TABLE d1.t5 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 830 Query 1 830 use `test`; CREATE TABLE d1.t6 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 912 Query 1 912 use `test`; CREATE INDEX my_idx6 ON d1.t6(f1) -master-bin.000001 980 Query 1 980 use `test`; CREATE TABLE d1.t7 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1062 Query 1 1062 use `test`; INSERT INTO d1.t7 SET f1= 0 -master-bin.000001 1124 Query 1 1124 use `test`; CREATE TABLE d1.t8 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1206 Query 1 1206 use `test`; CREATE TABLE d1.t9 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1288 Query 1 1288 use `test`; CREATE TABLE d1.t10 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1371 Query 1 1371 use `test`; CREATE TABLE d1.t11 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1454 Query 1 1454 use `test`; CREATE TABLE d1.t12 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1537 Query 1 1537 use `test`; CREATE TABLE d1.t13 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1620 Query 1 1620 use `test`; CREATE TABLE d1.t14 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1703 Query 1 1703 use `test`; CREATE TABLE d1.t15 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1786 Query 1 1786 use `test`; CREATE TABLE d1.t16 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1869 Query 1 1869 use `test`; CREATE TABLE d1.t17 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1952 Query 1 1952 use `test`; CREATE TABLE d1.t18 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 2035 Query 1 2035 use `test`; CREATE TABLE d1.t19 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 2118 Query 1 2118 use `d1`; BEGIN -master-bin.000001 2156 Query 1 2118 use `d1`; INSERT INTO t1 SET f1= 0 + 1 -master-bin.000001 2217 Query 1 2217 use `d1`; COMMIT +master-bin.000001 # Start 1 # Server ver: VERSION, Binlog ver: 3 +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 # 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 # 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 # Query 1 # use `mysqltest1`; COMMIT -------- switch to slave -------- SELECT MAX(f1) FROM t1; @@ -161,36 +164,37 @@ MAX(f1) 1 SHOW BINLOG EVENTS IN 'slave-bin.000001'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000001 4 Start 2 4 Server ver: VERSION, Binlog ver: 3 -slave-bin.000001 79 Query 2 79 use `test`; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9 -slave-bin.000001 161 Query 1 161 DROP DATABASE IF EXISTS d1 -slave-bin.000001 220 Query 1 220 DROP DATABASE IF EXISTS d2 -slave-bin.000001 279 Query 1 279 DROP DATABASE IF EXISTS d3 -slave-bin.000001 338 Query 1 338 CREATE DATABASE d1 -slave-bin.000001 389 Query 1 389 CREATE DATABASE d2 -slave-bin.000001 440 Query 1 440 use `test`; CREATE TABLE d1.t1 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 522 Query 1 522 use `test`; INSERT INTO d1.t1 SET f1= 0 -slave-bin.000001 584 Query 1 584 use `test`; CREATE TABLE d1.t2 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 666 Query 1 666 use `test`; CREATE TABLE d1.t3 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 748 Query 1 748 use `test`; CREATE TABLE d1.t4 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 830 Query 1 830 use `test`; CREATE TABLE d1.t5 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 912 Query 1 912 use `test`; CREATE TABLE d1.t6 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 994 Query 1 994 use `test`; CREATE INDEX my_idx6 ON d1.t6(f1) -slave-bin.000001 1062 Query 1 1062 use `test`; CREATE TABLE d1.t7 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1144 Query 1 1144 use `test`; INSERT INTO d1.t7 SET f1= 0 -slave-bin.000001 1206 Query 1 1206 use `test`; CREATE TABLE d1.t8 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1288 Query 1 1288 use `test`; CREATE TABLE d1.t9 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1370 Query 1 1370 use `test`; CREATE TABLE d1.t10 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1453 Query 1 1453 use `test`; CREATE TABLE d1.t11 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1536 Query 1 1536 use `test`; CREATE TABLE d1.t12 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1619 Query 1 1619 use `test`; CREATE TABLE d1.t13 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1702 Query 1 1702 use `test`; CREATE TABLE d1.t14 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1785 Query 1 1785 use `test`; CREATE TABLE d1.t15 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1868 Query 1 1868 use `test`; CREATE TABLE d1.t16 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1951 Query 1 1951 use `test`; CREATE TABLE d1.t17 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 2034 Query 1 2034 use `test`; CREATE TABLE d1.t18 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 2117 Query 1 2117 use `test`; CREATE TABLE d1.t19 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 2200 Query 1 2200 use `d1`; INSERT INTO t1 SET f1= 0 + 1 +slave-bin.000001 # Start 2 # Server ver: VERSION, Binlog ver: 3 +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; @@ -198,79 +202,81 @@ SELECT MAX(f1) FROM t1; MAX(f1) 1 -TEST-INFO: MASTER: The INSERT is committed +TEST-INFO: MASTER: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000001'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000001 4 Start 1 4 Server ver: VERSION, Binlog ver: 3 -master-bin.000001 79 Query 1 79 DROP DATABASE IF EXISTS d1 -master-bin.000001 138 Query 1 138 DROP DATABASE IF EXISTS d2 -master-bin.000001 197 Query 1 197 DROP DATABASE IF EXISTS d3 -master-bin.000001 256 Query 1 256 CREATE DATABASE d1 -master-bin.000001 307 Query 1 307 CREATE DATABASE d2 -master-bin.000001 358 Query 1 358 use `test`; CREATE TABLE d1.t1 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 440 Query 1 440 use `test`; INSERT INTO d1.t1 SET f1= 0 -master-bin.000001 502 Query 1 502 use `test`; CREATE TABLE d1.t2 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 584 Query 1 584 use `test`; CREATE TABLE d1.t3 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 666 Query 1 666 use `test`; CREATE TABLE d1.t4 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 748 Query 1 748 use `test`; CREATE TABLE d1.t5 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 830 Query 1 830 use `test`; CREATE TABLE d1.t6 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 912 Query 1 912 use `test`; CREATE INDEX my_idx6 ON d1.t6(f1) -master-bin.000001 980 Query 1 980 use `test`; CREATE TABLE d1.t7 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1062 Query 1 1062 use `test`; INSERT INTO d1.t7 SET f1= 0 -master-bin.000001 1124 Query 1 1124 use `test`; CREATE TABLE d1.t8 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1206 Query 1 1206 use `test`; CREATE TABLE d1.t9 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1288 Query 1 1288 use `test`; CREATE TABLE d1.t10 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1371 Query 1 1371 use `test`; CREATE TABLE d1.t11 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1454 Query 1 1454 use `test`; CREATE TABLE d1.t12 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1537 Query 1 1537 use `test`; CREATE TABLE d1.t13 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1620 Query 1 1620 use `test`; CREATE TABLE d1.t14 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1703 Query 1 1703 use `test`; CREATE TABLE d1.t15 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1786 Query 1 1786 use `test`; CREATE TABLE d1.t16 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1869 Query 1 1869 use `test`; CREATE TABLE d1.t17 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 1952 Query 1 1952 use `test`; CREATE TABLE d1.t18 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 2035 Query 1 2035 use `test`; CREATE TABLE d1.t19 (f1 BIGINT) ENGINE= "InnoDB" -master-bin.000001 2118 Query 1 2118 use `d1`; BEGIN -master-bin.000001 2156 Query 1 2118 use `d1`; INSERT INTO t1 SET f1= 0 + 1 -master-bin.000001 2217 Query 1 2217 use `d1`; COMMIT +master-bin.000001 # Start 1 # Server ver: VERSION, Binlog ver: 3 +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 # 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 # 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 # Query 1 # use `mysqltest1`; COMMIT -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 1 -TEST-INFO: SLAVE: The INSERT is committed +TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000001'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000001 4 Start 2 4 Server ver: VERSION, Binlog ver: 3 -slave-bin.000001 79 Query 2 79 use `test`; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9 -slave-bin.000001 161 Query 1 161 DROP DATABASE IF EXISTS d1 -slave-bin.000001 220 Query 1 220 DROP DATABASE IF EXISTS d2 -slave-bin.000001 279 Query 1 279 DROP DATABASE IF EXISTS d3 -slave-bin.000001 338 Query 1 338 CREATE DATABASE d1 -slave-bin.000001 389 Query 1 389 CREATE DATABASE d2 -slave-bin.000001 440 Query 1 440 use `test`; CREATE TABLE d1.t1 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 522 Query 1 522 use `test`; INSERT INTO d1.t1 SET f1= 0 -slave-bin.000001 584 Query 1 584 use `test`; CREATE TABLE d1.t2 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 666 Query 1 666 use `test`; CREATE TABLE d1.t3 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 748 Query 1 748 use `test`; CREATE TABLE d1.t4 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 830 Query 1 830 use `test`; CREATE TABLE d1.t5 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 912 Query 1 912 use `test`; CREATE TABLE d1.t6 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 994 Query 1 994 use `test`; CREATE INDEX my_idx6 ON d1.t6(f1) -slave-bin.000001 1062 Query 1 1062 use `test`; CREATE TABLE d1.t7 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1144 Query 1 1144 use `test`; INSERT INTO d1.t7 SET f1= 0 -slave-bin.000001 1206 Query 1 1206 use `test`; CREATE TABLE d1.t8 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1288 Query 1 1288 use `test`; CREATE TABLE d1.t9 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1370 Query 1 1370 use `test`; CREATE TABLE d1.t10 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1453 Query 1 1453 use `test`; CREATE TABLE d1.t11 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1536 Query 1 1536 use `test`; CREATE TABLE d1.t12 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1619 Query 1 1619 use `test`; CREATE TABLE d1.t13 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1702 Query 1 1702 use `test`; CREATE TABLE d1.t14 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1785 Query 1 1785 use `test`; CREATE TABLE d1.t15 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1868 Query 1 1868 use `test`; CREATE TABLE d1.t16 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 1951 Query 1 1951 use `test`; CREATE TABLE d1.t17 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 2034 Query 1 2034 use `test`; CREATE TABLE d1.t18 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 2117 Query 1 2117 use `test`; CREATE TABLE d1.t19 (f1 BIGINT) ENGINE= "InnoDB" -slave-bin.000001 2200 Query 1 2200 use `d1`; INSERT INTO t1 SET f1= 0 + 1 +slave-bin.000001 # Start 2 # Server ver: VERSION, Binlog ver: 3 +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; @@ -318,7 +324,7 @@ SELECT MAX(f1) FROM t1; MAX(f1) 1 -TEST-INFO: MASTER: The INSERT is not committed +TEST-INFO: MASTER: The INSERT is not committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000002'; Log_name Pos Event_type Server_id Orig_log_pos Info @@ -327,7 +333,7 @@ SELECT MAX(f1) FROM t1; MAX(f1) 1 -TEST-INFO: SLAVE: The INSERT is not committed +TEST-INFO: SLAVE: The INSERT is not committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000002'; Log_name Pos Event_type Server_id Orig_log_pos Info @@ -363,9 +369,9 @@ MAX(f1) 2 SHOW BINLOG EVENTS IN 'master-bin.000003'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000003 4 Query 1 4 use `d1`; BEGIN -master-bin.000003 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 1 + 1 -master-bin.000003 103 Query 1 103 use `d1`; COMMIT +master-bin.000003 # Query 1 # use `mysqltest1`; BEGIN +master-bin.000003 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 1 + 1 +master-bin.000003 # Query 1 # use `mysqltest1`; COMMIT -------- switch to slave -------- SELECT MAX(f1) FROM t1; @@ -373,7 +379,7 @@ MAX(f1) 2 SHOW BINLOG EVENTS IN 'slave-bin.000003'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000003 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 1 + 1 +slave-bin.000003 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 1 + 1 -------- switch to master ------- ROLLBACK; @@ -381,22 +387,22 @@ SELECT MAX(f1) FROM t1; MAX(f1) 2 -TEST-INFO: MASTER: The INSERT is committed +TEST-INFO: MASTER: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000003'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000003 4 Query 1 4 use `d1`; BEGIN -master-bin.000003 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 1 + 1 -master-bin.000003 103 Query 1 103 use `d1`; COMMIT +master-bin.000003 # Query 1 # use `mysqltest1`; BEGIN +master-bin.000003 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 1 + 1 +master-bin.000003 # Query 1 # use `mysqltest1`; COMMIT -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 2 -TEST-INFO: SLAVE: The INSERT is committed +TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000003'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000003 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 1 + 1 +slave-bin.000003 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 1 + 1 -------- switch to master ------- flush logs; @@ -431,9 +437,9 @@ MAX(f1) 3 SHOW BINLOG EVENTS IN 'master-bin.000004'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000004 4 Query 1 4 use `d1`; BEGIN -master-bin.000004 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 2 + 1 -master-bin.000004 103 Query 1 103 use `d1`; COMMIT +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 # Query 1 # use `mysqltest1`; COMMIT -------- switch to slave -------- SELECT MAX(f1) FROM t1; @@ -441,7 +447,7 @@ MAX(f1) 3 SHOW BINLOG EVENTS IN 'slave-bin.000004'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000004 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 2 + 1 +slave-bin.000004 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 2 + 1 -------- switch to master ------- ROLLBACK; @@ -449,22 +455,22 @@ SELECT MAX(f1) FROM t1; MAX(f1) 3 -TEST-INFO: MASTER: The INSERT is committed +TEST-INFO: MASTER: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000004'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000004 4 Query 1 4 use `d1`; BEGIN -master-bin.000004 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 2 + 1 -master-bin.000004 103 Query 1 103 use `d1`; COMMIT +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 # Query 1 # use `mysqltest1`; COMMIT -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 3 -TEST-INFO: SLAVE: The INSERT is committed +TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000004'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000004 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 2 + 1 +slave-bin.000004 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 2 + 1 -------- switch to master ------- flush logs; @@ -498,9 +504,9 @@ MAX(f1) 4 SHOW BINLOG EVENTS IN 'master-bin.000005'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000005 4 Query 1 4 use `d1`; BEGIN -master-bin.000005 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 3 + 1 -master-bin.000005 103 Query 1 103 use `d1`; COMMIT +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 # Query 1 # use `mysqltest1`; COMMIT -------- switch to slave -------- SELECT MAX(f1) FROM t1; @@ -508,7 +514,7 @@ MAX(f1) 4 SHOW BINLOG EVENTS IN 'slave-bin.000005'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000005 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 3 + 1 +slave-bin.000005 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 3 + 1 -------- switch to master ------- ROLLBACK; @@ -516,22 +522,22 @@ SELECT MAX(f1) FROM t1; MAX(f1) 4 -TEST-INFO: MASTER: The INSERT is committed +TEST-INFO: MASTER: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000005'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000005 4 Query 1 4 use `d1`; BEGIN -master-bin.000005 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 3 + 1 -master-bin.000005 103 Query 1 103 use `d1`; COMMIT +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 # Query 1 # use `mysqltest1`; COMMIT -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 4 -TEST-INFO: SLAVE: The INSERT is committed +TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000005'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000005 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 3 + 1 +slave-bin.000005 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 3 + 1 -------- switch to master ------- flush logs; @@ -541,7 +547,7 @@ flush logs; -------- switch to master ------- -######## DROP TABLE d1.t2 ######## +######## DROP TABLE mysqltest1.t2 ######## -------- switch to master ------- INSERT INTO t1 SET f1= 4 + 1; @@ -559,16 +565,16 @@ SHOW BINLOG EVENTS IN 'slave-bin.000006'; Log_name Pos Event_type Server_id Orig_log_pos Info -------- switch to master ------- -DROP TABLE d1.t2; +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 Orig_log_pos Info -master-bin.000006 4 Query 1 4 use `d1`; BEGIN -master-bin.000006 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 4 + 1 -master-bin.000006 103 Query 1 103 use `d1`; COMMIT -master-bin.000006 142 Query 1 142 use `d1`; DROP TABLE d1.t2 +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 # Query 1 # use `mysqltest1`; COMMIT +master-bin.000006 # Query 1 # use `mysqltest1`; DROP TABLE mysqltest1.t2 -------- switch to slave -------- SELECT MAX(f1) FROM t1; @@ -576,8 +582,8 @@ MAX(f1) 5 SHOW BINLOG EVENTS IN 'slave-bin.000006'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000006 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 4 + 1 -slave-bin.000006 65 Query 1 65 use `d1`; DROP TABLE d1.t2 +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; @@ -585,24 +591,24 @@ SELECT MAX(f1) FROM t1; MAX(f1) 5 -TEST-INFO: MASTER: The INSERT is committed +TEST-INFO: MASTER: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000006'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000006 4 Query 1 4 use `d1`; BEGIN -master-bin.000006 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 4 + 1 -master-bin.000006 103 Query 1 103 use `d1`; COMMIT -master-bin.000006 142 Query 1 142 use `d1`; DROP TABLE d1.t2 +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 # Query 1 # use `mysqltest1`; COMMIT +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 +TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000006'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000006 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 4 + 1 -slave-bin.000006 65 Query 1 65 use `d1`; DROP TABLE d1.t2 +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; @@ -612,15 +618,15 @@ flush logs; -------- switch to master ------- SHOW TABLES LIKE 't2'; -Tables_in_d1 (t2) +Tables_in_mysqltest1 (t2) -------- switch to slave -------- SHOW TABLES LIKE 't2'; -Tables_in_d1 (t2) +Tables_in_mysqltest1 (t2) -------- switch to master ------- -######## RENAME TABLE d1.t3 to d1.t20 ######## +######## DROP TEMPORARY TABLE mysqltest1.t23 ######## -------- switch to master ------- INSERT INTO t1 SET f1= 5 + 1; @@ -638,50 +644,125 @@ SHOW BINLOG EVENTS IN 'slave-bin.000007'; Log_name Pos Event_type Server_id Orig_log_pos Info -------- switch to master ------- -RENAME TABLE d1.t3 to d1.t20; +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 Orig_log_pos Info -master-bin.000007 4 Query 1 4 use `d1`; BEGIN -master-bin.000007 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 5 + 1 -master-bin.000007 103 Query 1 103 use `d1`; COMMIT -master-bin.000007 142 Query 1 142 use `d1`; RENAME TABLE d1.t3 to d1.t20 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) -6 +5 SHOW BINLOG EVENTS IN 'slave-bin.000007'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000007 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 5 + 1 -slave-bin.000007 65 Query 1 65 use `d1`; RENAME TABLE d1.t3 to d1.t20 -------- switch to master ------- ROLLBACK; +Warnings: +Warning 1196 Some non-transactional changed tables couldn't be rolled back SELECT MAX(f1) FROM t1; MAX(f1) -6 +5 -TEST-INFO: MASTER: The INSERT is committed +TEST-INFO: MASTER: The INSERT is not committed (Succeeded) SHOW BINLOG EVENTS IN 'master-bin.000007'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000007 4 Query 1 4 use `d1`; BEGIN -master-bin.000007 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 5 + 1 -master-bin.000007 103 Query 1 103 use `d1`; COMMIT -master-bin.000007 142 Query 1 142 use `d1`; RENAME TABLE d1.t3 to d1.t20 +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 +TEST-INFO: SLAVE: The INSERT is committed (Succeeded) SHOW BINLOG EVENTS IN 'slave-bin.000007'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000007 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 5 + 1 -slave-bin.000007 65 Query 1 65 use `d1`; RENAME TABLE d1.t3 to d1.t20 +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 Orig_log_pos Info + +-------- 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 Orig_log_pos Info + +-------- 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 Orig_log_pos Info +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 # Query 1 # use `mysqltest1`; COMMIT +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 Orig_log_pos Info +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 Orig_log_pos Info +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 # Query 1 # use `mysqltest1`; COMMIT +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 Orig_log_pos Info +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; @@ -691,53 +772,53 @@ flush logs; -------- switch to master ------- SHOW TABLES LIKE 't20'; -Tables_in_d1 (t20) +Tables_in_mysqltest1 (t20) t20 -------- switch to slave -------- SHOW TABLES LIKE 't20'; -Tables_in_d1 (t20) +Tables_in_mysqltest1 (t20) t20 -------- switch to master ------- -######## ALTER TABLE d1.t4 ADD column f2 BIGINT ######## +######## 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.000008'; +SHOW BINLOG EVENTS IN 'master-bin.000009'; Log_name Pos Event_type Server_id Orig_log_pos Info -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 6 -SHOW BINLOG EVENTS IN 'slave-bin.000008'; +SHOW BINLOG EVENTS IN 'slave-bin.000009'; Log_name Pos Event_type Server_id Orig_log_pos Info -------- switch to master ------- -ALTER TABLE d1.t4 ADD column f2 BIGINT; +ALTER TABLE mysqltest1.t4 ADD column f2 BIGINT; SELECT MAX(f1) FROM t1; MAX(f1) 7 -SHOW BINLOG EVENTS IN 'master-bin.000008'; +SHOW BINLOG EVENTS IN 'master-bin.000009'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000008 4 Query 1 4 use `d1`; BEGIN -master-bin.000008 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 6 + 1 -master-bin.000008 103 Query 1 103 use `d1`; COMMIT -master-bin.000008 142 Query 1 142 use `d1`; ALTER TABLE d1.t4 ADD column f2 BIGINT +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 # Query 1 # use `mysqltest1`; COMMIT +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.000008'; +SHOW BINLOG EVENTS IN 'slave-bin.000009'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000008 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 6 + 1 -slave-bin.000008 65 Query 1 65 use `d1`; ALTER TABLE d1.t4 ADD column f2 BIGINT +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; @@ -745,24 +826,24 @@ SELECT MAX(f1) FROM t1; MAX(f1) 7 -TEST-INFO: MASTER: The INSERT is committed -SHOW BINLOG EVENTS IN 'master-bin.000008'; +TEST-INFO: MASTER: The INSERT is committed (Succeeded) +SHOW BINLOG EVENTS IN 'master-bin.000009'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000008 4 Query 1 4 use `d1`; BEGIN -master-bin.000008 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 6 + 1 -master-bin.000008 103 Query 1 103 use `d1`; COMMIT -master-bin.000008 142 Query 1 142 use `d1`; ALTER TABLE d1.t4 ADD column f2 BIGINT +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 # Query 1 # use `mysqltest1`; COMMIT +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 -SHOW BINLOG EVENTS IN 'slave-bin.000008'; +TEST-INFO: SLAVE: The INSERT is committed (Succeeded) +SHOW BINLOG EVENTS IN 'slave-bin.000009'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000008 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 6 + 1 -slave-bin.000008 65 Query 1 65 use `d1`; ALTER TABLE d1.t4 ADD column f2 BIGINT +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; @@ -771,56 +852,56 @@ flush logs; flush logs; -------- switch to master ------- -describe d1.t4; +describe mysqltest1.t4; Field Type Null Key Default Extra f1 bigint(20) YES NULL f2 bigint(20) YES NULL -------- switch to slave -------- -describe d1.t4; +describe mysqltest1.t4; Field Type Null Key Default Extra f1 bigint(20) YES NULL f2 bigint(20) YES NULL -------- switch to master ------- -######## CREATE TABLE d1.t21 (f1 BIGINT) ENGINE= "InnoDB" ######## +######## 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.000009'; +SHOW BINLOG EVENTS IN 'master-bin.000010'; Log_name Pos Event_type Server_id Orig_log_pos Info -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 7 -SHOW BINLOG EVENTS IN 'slave-bin.000009'; +SHOW BINLOG EVENTS IN 'slave-bin.000010'; Log_name Pos Event_type Server_id Orig_log_pos Info -------- switch to master ------- -CREATE TABLE d1.t21 (f1 BIGINT) ENGINE= "InnoDB"; +CREATE TABLE mysqltest1.t21 (f1 BIGINT) ENGINE= "InnoDB"; SELECT MAX(f1) FROM t1; MAX(f1) 8 -SHOW BINLOG EVENTS IN 'master-bin.000009'; +SHOW BINLOG EVENTS IN 'master-bin.000010'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000009 4 Query 1 4 use `d1`; BEGIN -master-bin.000009 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 7 + 1 -master-bin.000009 103 Query 1 103 use `d1`; COMMIT -master-bin.000009 142 Query 1 142 use `d1`; CREATE TABLE d1.t21 (f1 BIGINT) ENGINE= "InnoDB" +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 # Query 1 # use `mysqltest1`; COMMIT +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.000009'; +SHOW BINLOG EVENTS IN 'slave-bin.000010'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000009 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 7 + 1 -slave-bin.000009 65 Query 1 65 use `d1`; CREATE TABLE d1.t21 (f1 BIGINT) ENGINE= "InnoDB" +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; @@ -828,24 +909,24 @@ SELECT MAX(f1) FROM t1; MAX(f1) 8 -TEST-INFO: MASTER: The INSERT is committed -SHOW BINLOG EVENTS IN 'master-bin.000009'; +TEST-INFO: MASTER: The INSERT is committed (Succeeded) +SHOW BINLOG EVENTS IN 'master-bin.000010'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000009 4 Query 1 4 use `d1`; BEGIN -master-bin.000009 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 7 + 1 -master-bin.000009 103 Query 1 103 use `d1`; COMMIT -master-bin.000009 142 Query 1 142 use `d1`; CREATE TABLE d1.t21 (f1 BIGINT) ENGINE= "InnoDB" +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 # Query 1 # use `mysqltest1`; COMMIT +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 -SHOW BINLOG EVENTS IN 'slave-bin.000009'; +TEST-INFO: SLAVE: The INSERT is committed (Succeeded) +SHOW BINLOG EVENTS IN 'slave-bin.000010'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000009 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 7 + 1 -slave-bin.000009 65 Query 1 65 use `d1`; CREATE TABLE d1.t21 (f1 BIGINT) ENGINE= "InnoDB" +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; @@ -855,43 +936,110 @@ flush logs; -------- switch to master ------- -######## TRUNCATE TABLE d1.t7 ######## +######## 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.000010'; +SHOW BINLOG EVENTS IN 'master-bin.000011'; Log_name Pos Event_type Server_id Orig_log_pos Info -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 8 -SHOW BINLOG EVENTS IN 'slave-bin.000010'; +SHOW BINLOG EVENTS IN 'slave-bin.000011'; Log_name Pos Event_type Server_id Orig_log_pos Info -------- switch to master ------- -TRUNCATE TABLE d1.t7; +CREATE TEMPORARY TABLE mysqltest1.t22 (f1 BIGINT); SELECT MAX(f1) FROM t1; MAX(f1) 9 -SHOW BINLOG EVENTS IN 'master-bin.000010'; +SHOW BINLOG EVENTS IN 'master-bin.000011'; +Log_name Pos Event_type Server_id Orig_log_pos Info + +-------- 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 Orig_log_pos Info + +-------- 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 Orig_log_pos Info -master-bin.000010 4 Query 1 4 use `d1`; BEGIN -master-bin.000010 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 8 + 1 -master-bin.000010 103 Query 1 103 use `d1`; COMMIT -master-bin.000010 142 Query 1 142 use `d1`; TRUNCATE TABLE d1.t7 +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 -SHOW BINLOG EVENTS IN 'slave-bin.000010'; + +TEST-INFO: SLAVE: The INSERT is committed (Succeeded) +SHOW BINLOG EVENTS IN 'slave-bin.000011'; +Log_name Pos Event_type Server_id Orig_log_pos Info +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 Orig_log_pos Info + +-------- 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 Orig_log_pos Info + +-------- 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 Orig_log_pos Info +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 # Query 1 # use `mysqltest1`; COMMIT +master-bin.000012 # Query 1 # use `mysqltest1`; TRUNCATE TABLE mysqltest1.t7 + +-------- 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 Orig_log_pos Info -slave-bin.000010 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 8 + 1 -slave-bin.000010 65 Query 1 65 use `d1`; TRUNCATE TABLE d1.t7 +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; @@ -899,24 +1047,24 @@ SELECT MAX(f1) FROM t1; MAX(f1) 9 -TEST-INFO: MASTER: The INSERT is committed -SHOW BINLOG EVENTS IN 'master-bin.000010'; +TEST-INFO: MASTER: The INSERT is committed (Succeeded) +SHOW BINLOG EVENTS IN 'master-bin.000012'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000010 4 Query 1 4 use `d1`; BEGIN -master-bin.000010 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 8 + 1 -master-bin.000010 103 Query 1 103 use `d1`; COMMIT -master-bin.000010 142 Query 1 142 use `d1`; TRUNCATE TABLE d1.t7 +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 # Query 1 # use `mysqltest1`; COMMIT +master-bin.000012 # Query 1 # use `mysqltest1`; TRUNCATE TABLE mysqltest1.t7 -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 9 -TEST-INFO: SLAVE: The INSERT is committed -SHOW BINLOG EVENTS IN 'slave-bin.000010'; +TEST-INFO: SLAVE: The INSERT is committed (Succeeded) +SHOW BINLOG EVENTS IN 'slave-bin.000012'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000010 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 8 + 1 -slave-bin.000010 65 Query 1 65 use `d1`; TRUNCATE TABLE d1.t7 +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; @@ -925,50 +1073,50 @@ flush logs; flush logs; -------- switch to master ------- -SELECT * FROM d1.t7; +SELECT * FROM mysqltest1.t7; f1 -------- switch to slave -------- -SELECT * FROM d1.t7; +SELECT * FROM mysqltest1.t7; f1 -------- switch to master ------- -######## LOCK TABLES d1.t1 WRITE, d1.t8 READ ######## +######## 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.000011'; +SHOW BINLOG EVENTS IN 'master-bin.000013'; Log_name Pos Event_type Server_id Orig_log_pos Info -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 9 -SHOW BINLOG EVENTS IN 'slave-bin.000011'; +SHOW BINLOG EVENTS IN 'slave-bin.000013'; Log_name Pos Event_type Server_id Orig_log_pos Info -------- switch to master ------- -LOCK TABLES d1.t1 WRITE, d1.t8 READ; +LOCK TABLES mysqltest1.t1 WRITE, mysqltest1.t8 READ; SELECT MAX(f1) FROM t1; MAX(f1) 10 -SHOW BINLOG EVENTS IN 'master-bin.000011'; +SHOW BINLOG EVENTS IN 'master-bin.000013'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000011 4 Query 1 4 use `d1`; BEGIN -master-bin.000011 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 9 + 1 -master-bin.000011 103 Query 1 103 use `d1`; COMMIT +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 # Query 1 # use `mysqltest1`; COMMIT -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 10 -SHOW BINLOG EVENTS IN 'slave-bin.000011'; +SHOW BINLOG EVENTS IN 'slave-bin.000013'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000011 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 9 + 1 +slave-bin.000013 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 9 + 1 -------- switch to master ------- ROLLBACK; @@ -976,22 +1124,22 @@ SELECT MAX(f1) FROM t1; MAX(f1) 10 -TEST-INFO: MASTER: The INSERT is committed -SHOW BINLOG EVENTS IN 'master-bin.000011'; +TEST-INFO: MASTER: The INSERT is committed (Succeeded) +SHOW BINLOG EVENTS IN 'master-bin.000013'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000011 4 Query 1 4 use `d1`; BEGIN -master-bin.000011 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 9 + 1 -master-bin.000011 103 Query 1 103 use `d1`; COMMIT +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 # Query 1 # use `mysqltest1`; COMMIT -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 10 -TEST-INFO: SLAVE: The INSERT is committed -SHOW BINLOG EVENTS IN 'slave-bin.000011'; +TEST-INFO: SLAVE: The INSERT is committed (Succeeded) +SHOW BINLOG EVENTS IN 'slave-bin.000013'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000011 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 9 + 1 +slave-bin.000013 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 9 + 1 -------- switch to master ------- flush logs; @@ -1001,7 +1149,6 @@ flush logs; -------- switch to master ------- UNLOCK TABLES; -LOCK TABLES d1.t1 WRITE, d1.t8 READ; ######## UNLOCK TABLES ######## @@ -1010,14 +1157,14 @@ INSERT INTO t1 SET f1= 10 + 1; SELECT MAX(f1) FROM t1; MAX(f1) 11 -SHOW BINLOG EVENTS IN 'master-bin.000012'; +SHOW BINLOG EVENTS IN 'master-bin.000014'; Log_name Pos Event_type Server_id Orig_log_pos Info -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 10 -SHOW BINLOG EVENTS IN 'slave-bin.000012'; +SHOW BINLOG EVENTS IN 'slave-bin.000014'; Log_name Pos Event_type Server_id Orig_log_pos Info -------- switch to master ------- @@ -1025,19 +1172,140 @@ UNLOCK TABLES; SELECT MAX(f1) FROM t1; MAX(f1) 11 -SHOW BINLOG EVENTS IN 'master-bin.000012'; +SHOW BINLOG EVENTS IN 'master-bin.000014'; +Log_name Pos Event_type Server_id Orig_log_pos Info + +-------- 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 Orig_log_pos Info + +-------- 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 Orig_log_pos Info + +-------- 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 Orig_log_pos Info + +-------- 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 Orig_log_pos Info + +-------- 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 Orig_log_pos Info + +-------- 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 Orig_log_pos Info -master-bin.000012 4 Query 1 4 use `d1`; BEGIN -master-bin.000012 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 10 + 1 -master-bin.000012 104 Query 1 104 use `d1`; COMMIT -------- 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 Orig_log_pos Info + +-------- 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 Orig_log_pos Info + +-------- 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 Orig_log_pos Info + +-------- 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 'slave-bin.000012'; +SHOW BINLOG EVENTS IN 'master-bin.000016'; +Log_name Pos Event_type Server_id Orig_log_pos Info + +-------- 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 Orig_log_pos Info -slave-bin.000012 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 10 + 1 + +-------- 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 Orig_log_pos Info +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 # Query 1 # use `mysqltest1`; COMMIT + +-------- 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 Orig_log_pos Info +slave-bin.000016 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 10 + 1 -------- switch to master ------- ROLLBACK; @@ -1045,22 +1313,22 @@ SELECT MAX(f1) FROM t1; MAX(f1) 11 -TEST-INFO: MASTER: The INSERT is committed -SHOW BINLOG EVENTS IN 'master-bin.000012'; +TEST-INFO: MASTER: The INSERT is committed (Succeeded) +SHOW BINLOG EVENTS IN 'master-bin.000016'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000012 4 Query 1 4 use `d1`; BEGIN -master-bin.000012 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 10 + 1 -master-bin.000012 104 Query 1 104 use `d1`; COMMIT +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 # Query 1 # use `mysqltest1`; COMMIT -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 11 -TEST-INFO: SLAVE: The INSERT is committed -SHOW BINLOG EVENTS IN 'slave-bin.000012'; +TEST-INFO: SLAVE: The INSERT is committed (Succeeded) +SHOW BINLOG EVENTS IN 'slave-bin.000016'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000012 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 10 + 1 +slave-bin.000016 # Query 1 # use `mysqltest1`; INSERT INTO t1 SET f1= 10 + 1 -------- switch to master ------- flush logs; @@ -1070,43 +1338,43 @@ flush logs; -------- switch to master ------- -######## DROP INDEX my_idx6 ON d1.t6 ######## +######## 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.000013'; +SHOW BINLOG EVENTS IN 'master-bin.000017'; Log_name Pos Event_type Server_id Orig_log_pos Info -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 11 -SHOW BINLOG EVENTS IN 'slave-bin.000013'; +SHOW BINLOG EVENTS IN 'slave-bin.000017'; Log_name Pos Event_type Server_id Orig_log_pos Info -------- switch to master ------- -DROP INDEX my_idx6 ON d1.t6; +DROP INDEX my_idx6 ON mysqltest1.t6; SELECT MAX(f1) FROM t1; MAX(f1) 12 -SHOW BINLOG EVENTS IN 'master-bin.000013'; +SHOW BINLOG EVENTS IN 'master-bin.000017'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000013 4 Query 1 4 use `d1`; BEGIN -master-bin.000013 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 11 + 1 -master-bin.000013 104 Query 1 104 use `d1`; COMMIT -master-bin.000013 143 Query 1 143 use `d1`; DROP INDEX my_idx6 ON d1.t6 +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 # Query 1 # use `mysqltest1`; COMMIT +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.000013'; +SHOW BINLOG EVENTS IN 'slave-bin.000017'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000013 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 11 + 1 -slave-bin.000013 66 Query 1 66 use `d1`; DROP INDEX my_idx6 ON d1.t6 +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; @@ -1114,24 +1382,24 @@ SELECT MAX(f1) FROM t1; MAX(f1) 12 -TEST-INFO: MASTER: The INSERT is committed -SHOW BINLOG EVENTS IN 'master-bin.000013'; +TEST-INFO: MASTER: The INSERT is committed (Succeeded) +SHOW BINLOG EVENTS IN 'master-bin.000017'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000013 4 Query 1 4 use `d1`; BEGIN -master-bin.000013 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 11 + 1 -master-bin.000013 104 Query 1 104 use `d1`; COMMIT -master-bin.000013 143 Query 1 143 use `d1`; DROP INDEX my_idx6 ON d1.t6 +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 # Query 1 # use `mysqltest1`; COMMIT +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 -SHOW BINLOG EVENTS IN 'slave-bin.000013'; +TEST-INFO: SLAVE: The INSERT is committed (Succeeded) +SHOW BINLOG EVENTS IN 'slave-bin.000017'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000013 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 11 + 1 -slave-bin.000013 66 Query 1 66 use `d1`; DROP INDEX my_idx6 ON d1.t6 +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; @@ -1140,52 +1408,52 @@ flush logs; flush logs; -------- switch to master ------- -SHOW INDEX FROM d1.t6; +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 d1.t6; +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 d1.t5(f1) ######## +######## 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.000014'; +SHOW BINLOG EVENTS IN 'master-bin.000018'; Log_name Pos Event_type Server_id Orig_log_pos Info -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 12 -SHOW BINLOG EVENTS IN 'slave-bin.000014'; +SHOW BINLOG EVENTS IN 'slave-bin.000018'; Log_name Pos Event_type Server_id Orig_log_pos Info -------- switch to master ------- -CREATE INDEX my_idx5 ON d1.t5(f1); +CREATE INDEX my_idx5 ON mysqltest1.t5(f1); SELECT MAX(f1) FROM t1; MAX(f1) 13 -SHOW BINLOG EVENTS IN 'master-bin.000014'; +SHOW BINLOG EVENTS IN 'master-bin.000018'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000014 4 Query 1 4 use `d1`; BEGIN -master-bin.000014 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 12 + 1 -master-bin.000014 104 Query 1 104 use `d1`; COMMIT -master-bin.000014 143 Query 1 143 use `d1`; CREATE INDEX my_idx5 ON d1.t5(f1) +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 # Query 1 # use `mysqltest1`; COMMIT +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.000014'; +SHOW BINLOG EVENTS IN 'slave-bin.000018'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000014 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 12 + 1 -slave-bin.000014 66 Query 1 66 use `d1`; CREATE INDEX my_idx5 ON d1.t5(f1) +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; @@ -1193,24 +1461,24 @@ SELECT MAX(f1) FROM t1; MAX(f1) 13 -TEST-INFO: MASTER: The INSERT is committed -SHOW BINLOG EVENTS IN 'master-bin.000014'; +TEST-INFO: MASTER: The INSERT is committed (Succeeded) +SHOW BINLOG EVENTS IN 'master-bin.000018'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000014 4 Query 1 4 use `d1`; BEGIN -master-bin.000014 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 12 + 1 -master-bin.000014 104 Query 1 104 use `d1`; COMMIT -master-bin.000014 143 Query 1 143 use `d1`; CREATE INDEX my_idx5 ON d1.t5(f1) +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 # Query 1 # use `mysqltest1`; COMMIT +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 -SHOW BINLOG EVENTS IN 'slave-bin.000014'; +TEST-INFO: SLAVE: The INSERT is committed (Succeeded) +SHOW BINLOG EVENTS IN 'slave-bin.000018'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000014 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 12 + 1 -slave-bin.000014 66 Query 1 66 use `d1`; CREATE INDEX my_idx5 ON d1.t5(f1) +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; @@ -1219,54 +1487,54 @@ flush logs; flush logs; -------- switch to master ------- -SHOW INDEX FROM d1.t5; +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 d1.t5; +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 d2 ######## +######## 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.000015'; +SHOW BINLOG EVENTS IN 'master-bin.000019'; Log_name Pos Event_type Server_id Orig_log_pos Info -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 13 -SHOW BINLOG EVENTS IN 'slave-bin.000015'; +SHOW BINLOG EVENTS IN 'slave-bin.000019'; Log_name Pos Event_type Server_id Orig_log_pos Info -------- switch to master ------- -DROP DATABASE d2; +DROP DATABASE mysqltest2; SELECT MAX(f1) FROM t1; MAX(f1) 14 -SHOW BINLOG EVENTS IN 'master-bin.000015'; +SHOW BINLOG EVENTS IN 'master-bin.000019'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000015 4 Query 1 4 use `d1`; BEGIN -master-bin.000015 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 13 + 1 -master-bin.000015 104 Query 1 104 use `d1`; COMMIT -master-bin.000015 143 Query 1 143 DROP DATABASE d2 +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 # Query 1 # use `mysqltest1`; COMMIT +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.000015'; +SHOW BINLOG EVENTS IN 'slave-bin.000019'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000015 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 13 + 1 -slave-bin.000015 66 Query 1 66 DROP DATABASE d2 +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; @@ -1274,24 +1542,24 @@ SELECT MAX(f1) FROM t1; MAX(f1) 14 -TEST-INFO: MASTER: The INSERT is committed -SHOW BINLOG EVENTS IN 'master-bin.000015'; +TEST-INFO: MASTER: The INSERT is committed (Succeeded) +SHOW BINLOG EVENTS IN 'master-bin.000019'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000015 4 Query 1 4 use `d1`; BEGIN -master-bin.000015 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 13 + 1 -master-bin.000015 104 Query 1 104 use `d1`; COMMIT -master-bin.000015 143 Query 1 143 DROP DATABASE d2 +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 # Query 1 # use `mysqltest1`; COMMIT +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 -SHOW BINLOG EVENTS IN 'slave-bin.000015'; +TEST-INFO: SLAVE: The INSERT is committed (Succeeded) +SHOW BINLOG EVENTS IN 'slave-bin.000019'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000015 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 13 + 1 -slave-bin.000015 66 Query 1 66 DROP DATABASE d2 +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; @@ -1300,52 +1568,52 @@ flush logs; flush logs; -------- switch to master ------- -SHOW DATABASES LIKE "d2"; -Database (d2) +SHOW DATABASES LIKE "mysqltest2"; +Database (mysqltest2) -------- switch to slave -------- -SHOW DATABASES LIKE "d2"; -Database (d2) +SHOW DATABASES LIKE "mysqltest2"; +Database (mysqltest2) -------- switch to master ------- -######## CREATE DATABASE d3 ######## +######## 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.000016'; +SHOW BINLOG EVENTS IN 'master-bin.000020'; Log_name Pos Event_type Server_id Orig_log_pos Info -------- switch to slave -------- SELECT MAX(f1) FROM t1; MAX(f1) 14 -SHOW BINLOG EVENTS IN 'slave-bin.000016'; +SHOW BINLOG EVENTS IN 'slave-bin.000020'; Log_name Pos Event_type Server_id Orig_log_pos Info -------- switch to master ------- -CREATE DATABASE d3; +CREATE DATABASE mysqltest3; SELECT MAX(f1) FROM t1; MAX(f1) 15 -SHOW BINLOG EVENTS IN 'master-bin.000016'; +SHOW BINLOG EVENTS IN 'master-bin.000020'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000016 4 Query 1 4 use `d1`; BEGIN -master-bin.000016 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 14 + 1 -master-bin.000016 104 Query 1 104 use `d1`; COMMIT -master-bin.000016 143 Query 1 143 CREATE DATABASE d3 +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 # Query 1 # use `mysqltest1`; COMMIT +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.000016'; +SHOW BINLOG EVENTS IN 'slave-bin.000020'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000016 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 14 + 1 -slave-bin.000016 66 Query 1 66 CREATE DATABASE d3 +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; @@ -1353,24 +1621,24 @@ SELECT MAX(f1) FROM t1; MAX(f1) 15 -TEST-INFO: MASTER: The INSERT is committed -SHOW BINLOG EVENTS IN 'master-bin.000016'; +TEST-INFO: MASTER: The INSERT is committed (Succeeded) +SHOW BINLOG EVENTS IN 'master-bin.000020'; Log_name Pos Event_type Server_id Orig_log_pos Info -master-bin.000016 4 Query 1 4 use `d1`; BEGIN -master-bin.000016 42 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 14 + 1 -master-bin.000016 104 Query 1 104 use `d1`; COMMIT -master-bin.000016 143 Query 1 143 CREATE DATABASE d3 +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 # Query 1 # use `mysqltest1`; COMMIT +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 -SHOW BINLOG EVENTS IN 'slave-bin.000016'; +TEST-INFO: SLAVE: The INSERT is committed (Succeeded) +SHOW BINLOG EVENTS IN 'slave-bin.000020'; Log_name Pos Event_type Server_id Orig_log_pos Info -slave-bin.000016 4 Query 1 4 use `d1`; INSERT INTO t1 SET f1= 14 + 1 -slave-bin.000016 66 Query 1 66 CREATE DATABASE d3 +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; @@ -1379,16 +1647,16 @@ flush logs; flush logs; -------- switch to master ------- -SHOW DATABASES LIKE "d3"; -Database (d3) -d3 +SHOW DATABASES LIKE "mysqltest3"; +Database (mysqltest3) +mysqltest3 -------- switch to slave -------- -SHOW DATABASES LIKE "d3"; -Database (d3) -d3 +SHOW DATABASES LIKE "mysqltest3"; +Database (mysqltest3) +mysqltest3 -------- switch to master ------- -DROP DATABASE IF EXISTS d1; -DROP DATABASE IF EXISTS d2; -DROP DATABASE IF EXISTS d3; +DROP DATABASE IF EXISTS mysqltest1; +DROP DATABASE IF EXISTS mysqltest2; +DROP DATABASE IF EXISTS mysqltest3; |