Debian Codegraph @

mysql-test/suite/ndb_rpl/t/ndb_rpl_log_updates.test

raw
1 --source include/have_ndb.inc
2
3 # This test setups a replication topology with two upstream clusters
4 # and a replica cluster, where every replica binlogs their applied
5 # updates(log-replica-updates=ON) but no source does. One of the
6 # sources (source.4) applies updates with no-logging bit set
7 # (SQL_BIN_LOG=OFF) so that they are not applied on the replica
8 # cluster.
9
10 # set up replication
11 --let $rpl_topology= 1->6,2->3,5->7
12 # --let $rpl_debug= 1
13 --source include/rpl_init.inc
14
15 --let $rpl_connection_name= source.1
16 --let $rpl_server_number= 1
17 --source include/rpl_connect.inc
18
19 --let $rpl_connection_name= source.2
20 --let $rpl_server_number= 2
21 --source include/rpl_connect.inc
22
23 --let $rpl_connection_name= replica.3
24 --let $rpl_server_number= 3
25 --source include/rpl_connect.inc
26
27 --let $rpl_connection_name= source.4
28 --let $rpl_server_number= 4
29 --source include/rpl_connect.inc
30
31 --let $rpl_connection_name= source.5
32 --let $rpl_server_number= 5
33 --source include/rpl_connect.inc
34
35 --let $rpl_connection_name= replica.6
36 --let $rpl_server_number= 6
37 --source include/rpl_connect.inc
38
39 --let $rpl_connection_name= replica.7
40 --let $rpl_server_number= 7
41 --source include/rpl_connect.inc
42
43 # Create a table, insert data and check that replicas apply the correct updates
44 --let $rpl_connection_name= source.1
45 --source include/rpl_connection.inc
46 CREATE TABLE t1 (k INT PRIMARY KEY, c CHAR) ENGINE = NDB;
47 INSERT INTO t1 VALUES (1, 'a');
48
49 --echo # Sync the replication topology (propagates the table to all clusters)
50 --let $use_gtids=0
51 --source include/rpl_sync.inc
52
53 --let $rpl_connection_name= source.2
54 --source include/rpl_connection.inc
55 INSERT INTO t1 VALUES (2, 'b');
56
57 --let $rpl_connection_name= source.4
58 --source include/rpl_connection.inc
59 SET sql_log_bin= OFF;
60 INSERT INTO t1 VALUES (3, 'c');
61 SET sql_log_bin= ON;
62 INSERT INTO t1 VALUES (4, 'd');
63
64 --let $rpl_connection_name= source.5
65 --source include/rpl_connection.inc
66 INSERT INTO t1 VALUES (5, 'e');
67
68 --echo # Sync the replication topology (propagates the data changes)
69 --let $use_gtids=0
70 --source include/rpl_sync.inc
71
72 # Verify replica.3
73 --let $rpl_connection_name= replica.3
74 --source include/rpl_connection.inc
75 SELECT * FROM t1 ORDER BY k;
76
77 # Verfiy source.4
78 --let $rpl_connection_name= source.4
79 --source include/rpl_connection.inc
80 SELECT * FROM t1 ORDER BY k;
81
82 # Verify source.5
83 --let $rpl_connection_name= source.5
84 --source include/rpl_connection.inc
85 SELECT * FROM t1 ORDER BY k;
86
87 # Verify replica.7
88 --let $rpl_connection_name= replica.7
89 --source include/rpl_connection.inc
90 --echo # Must not have k = 3
91 SELECT * FROM t1 ORDER BY k;
92
93 # Verify replica.6
94 --let $rpl_connection_name= replica.6
95 --source include/rpl_connection.inc
96 --echo # Must not have k = 3
97 SELECT * FROM t1 ORDER BY k;
98
99 --echo Cleanup
100 --echo [connection source.1]
101 --connection source.1
102 DROP TABLE t1;
103
104 --source include/rpl_end.inc