Debian Codegraph @

mysql-test/suite/rpl/r/rpl_blackhole.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
7 CREATE TABLE t1 (a INT, b INT, c INT);
8 CREATE TABLE t2 (a INT, b INT, c INT);
9 include/sync_slave_sql_with_master.inc
10 ALTER TABLE t1 ENGINE=BLACKHOLE;
11 INSERT INTO t2 VALUES (1,9,1), (2,9,2), (3,9,3), (4,9,4);
12 include/sync_slave_sql_with_master.inc
13 [on master]
14 INSERT INTO t1 VALUES (1,1,1),(2,1,2),(3,1,3),(4,1,4);
15 [on slave]
16 include/sync_slave_sql_with_master.inc
17 # Expect 0
18 SELECT COUNT(*) FROM t1;
19 COUNT(*)
20 0
21 >>> Something was written to binary log <<<
22 [on master]
23 UPDATE t1 SET c = 2*c WHERE a % 2 = 0 AND b = 1;
24 [on slave]
25 include/sync_slave_sql_with_master.inc
26 # Expect 0
27 SELECT COUNT(*) FROM t1;
28 COUNT(*)
29 0
30 >>> Something was written to binary log <<<
31 [on master]
32 DELETE FROM t1 WHERE a % 2 = 0 AND b = 1;
33 [on slave]
34 include/sync_slave_sql_with_master.inc
35 # Expect 0
36 SELECT COUNT(*) FROM t1;
37 COUNT(*)
38 0
39 >>> Something was written to binary log <<<
40 [on master]
41 INSERT INTO t1 SELECT * FROM t2;
42 [on slave]
43 include/sync_slave_sql_with_master.inc
44 # Expect 0
45 SELECT COUNT(*) FROM t1;
46 COUNT(*)
47 0
48 >>> Something was written to binary log <<<
49 ALTER TABLE t1 ADD PRIMARY KEY pk_t1 (a,b);
50 [on master]
51 INSERT INTO t1 VALUES (1,2,1),(2,2,2),(3,2,3),(4,2,4);
52 [on slave]
53 include/sync_slave_sql_with_master.inc
54 # Expect 0
55 SELECT COUNT(*) FROM t1;
56 COUNT(*)
57 0
58 >>> Something was written to binary log <<<
59 [on master]
60 UPDATE t1 SET c = 2*c WHERE a % 2 = 0 AND b = 2;
61 [on slave]
62 include/sync_slave_sql_with_master.inc
63 # Expect 0
64 SELECT COUNT(*) FROM t1;
65 COUNT(*)
66 0
67 >>> Something was written to binary log <<<
68 [on master]
69 DELETE FROM t1 WHERE a % 2 = 0 AND b = 2;
70 [on slave]
71 include/sync_slave_sql_with_master.inc
72 # Expect 0
73 SELECT COUNT(*) FROM t1;
74 COUNT(*)
75 0
76 >>> Something was written to binary log <<<
77 ALTER TABLE t1 DROP PRIMARY KEY, ADD KEY key_t1 (a);
78 [on master]
79 INSERT INTO t1 VALUES (1,3,1),(2,3,2),(3,3,3),(4,3,4);
80 [on slave]
81 include/sync_slave_sql_with_master.inc
82 # Expect 0
83 SELECT COUNT(*) FROM t1;
84 COUNT(*)
85 0
86 >>> Something was written to binary log <<<
87 [on master]
88 UPDATE t1 SET c = 2*c WHERE a % 2 = 0 AND b = 3;
89 [on slave]
90 include/sync_slave_sql_with_master.inc
91 # Expect 0
92 SELECT COUNT(*) FROM t1;
93 COUNT(*)
94 0
95 >>> Something was written to binary log <<<
96 [on master]
97 DELETE FROM t1 WHERE a % 2 = 0 AND b = 3;
98 [on slave]
99 include/sync_slave_sql_with_master.inc
100 # Expect 0
101 SELECT COUNT(*) FROM t1;
102 COUNT(*)
103 0
104 >>> Something was written to binary log <<<
105 DROP TABLE t1,t2;
106 include/rpl_end.inc