Debian Codegraph @

mysql-test/suite/rpl/include/rpl_mixed_ddl.inc

raw
1 #########################################
2 # Purpose: testing the replication in mixed mode
3 # Requirements: define binlog format for mysqld as in example below:
4 # ./mysql-test-run.pl --mysqld=--binlog-format=mixed
5 #########################################
6
7 --source include/master-slave.inc
8
9 # Check MIXED on both master and slave
10 connection master;
11 --source suite/rpl/include/rpl_mixed_show_binlog_format.inc
12 connection slave;
13 --source suite/rpl/include/rpl_mixed_show_binlog_format.inc
14 connection master;
15
16
17 # DDL for databases
18 --echo
19 --echo ******************** DDL for database ********************
20 --disable_warnings
21 DROP DATABASE IF EXISTS test_rpl;
22 DROP DATABASE IF EXISTS test_rpl_1;
23 --enable_warnings
24 CREATE DATABASE test_rpl_1 CHARACTER SET utf8 COLLATE utf8_general_ci;
25 ALTER DATABASE test_rpl_1 CHARACTER SET latin1 COLLATE latin1_general_ci;
26 DROP DATABASE test_rpl_1;
27 CREATE DATABASE test_rpl CHARACTER SET utf8 COLLATE utf8_general_ci;
28 ALTER DATABASE test_rpl CHARACTER SET latin1 COLLATE latin1_swedish_ci;
29 --source suite/rpl/include/rpl_mixed_check_db.inc
30
31 USE test_rpl;
32
33 # DDL for tables
34 --echo
35 --echo ******************** DDL for tables ********************
36 eval CREATE TABLE t0 (a int auto_increment not null, c int not null, PRIMARY KEY(a), KEY index2 (c)) ENGINE=$engine_type;
37 ALTER TABLE t0 DROP INDEX index2;
38 ALTER TABLE t0 ADD COLUMN b char(254);
39 ALTER TABLE t0 ADD INDEX index1 (b);
40 ALTER TABLE t0 DROP COLUMN c;
41 RENAME TABLE t0 TO t1;
42 CREATE TABLE t2 LIKE t1;
43 --source suite/rpl/include/rpl_mixed_check_table.inc
44
45 # DDL for logfiles
46 # skipped
47
48 # DDL for tablespaces
49 # skipped
50
51 # DDL for indexes
52 --echo
53 --echo ******************** DDL for indexes ********************
54 ALTER TABLE t2 ADD COLUMN d datetime;
55 CREATE INDEX index2 on t2 (d);
56 CREATE INDEX index3 on t2 (a, d);
57 --source suite/rpl/include/rpl_mixed_check_table.inc
58 ALTER TABLE t2 DROP COLUMN d;
59
60
61 # BINLOG EVENTS
62 --echo
63 --echo
64 --echo ******************** SHOW BINLOG EVENTS ********************
65 source include/show_binlog_events.inc;
66 sync_slave_with_master;
67 # as we're using UUID we don't SELECT but use "diff" like in rpl_row_UUID
68 --exec $MYSQL_DUMP --compact --order-by-primary --skip-extended-insert --no-create-info test_rpl > $MYSQLTEST_VARDIR/tmp/rpl_switch_stm_row_mixed_master.sql
69 --exec $MYSQL_DUMP_SLAVE --compact --order-by-primary --skip-extended-insert --no-create-info test_rpl > $MYSQLTEST_VARDIR/tmp/rpl_switch_stm_row_mixed_slave.sql
70
71 connection master;
72 drop database test_rpl;
73 sync_slave_with_master;
74
75 # Let's compare. Note: If they match test will pass, if they do not match
76 # the test will show that the diff statement failed and not reject file
77 # will be created. You will need to go to the mysql-test dir and diff
78 # the files your self to see what is not matching
79
80 --diff_files $MYSQLTEST_VARDIR/tmp/rpl_switch_stm_row_mixed_master.sql $MYSQLTEST_VARDIR/tmp/rpl_switch_stm_row_mixed_slave.sql
81 --source include/rpl_end.inc