Debian Codegraph @

mysql-test/suite/rpl_gtid/t/rpl_sql_delay_multi_source.test

raw
1 #
2 # ==== Purpose ====
3 #
4 # This test checks if the sql delay is being applied correctly in a multi-source
5 # topology.
6 #
7 # ==== Implementation ====
8 # In server_1->server_2, server_3->server_2 topology
9 # The SQL_Delay in server_2 is set to 5 seconds and 8 seconds with respect to
10 # server_1 and server_3. For each for the six different transactions executed
11 # (two DDL, three DML and one multi-statement DML), the test verifies if the
12 # delay was the expected using replication timestamp infrastructure introduced
13 # by WL#7319.
14 #
15 # ==== References ====
16 #
17 # WL#7318 Delayed Replication: GTID based and relative to immediate master commit
18
19 --source include/big_test.inc
20 --source include/have_debug.inc
21 # Test requires master-info-repository=TABLE, relay-log-info-repository=TABLE
22 --source include/have_slave_repository_type_table.inc
23
24 --let $rpl_topology=1->2,3->2
25 --let $rpl_multi_source= 1
26 --let $rpl_skip_start_slave= 1
27 --source include/rpl_init.inc
28
29 --let $delay_1= 5
30 --let $delay_2= 8
31 --let $slave_sleep_1= 1
32 --let $slave_sleep_2= 2
33
34 --let $rpl_connection_name= server_2
35 --source include/rpl_connection.inc
36
37 --eval CHANGE REPLICATION SOURCE TO SOURCE_DELAY= $delay_1 for channel 'channel_1';
38 --let $rpl_channel_name= 'channel_1'
39 --source include/start_slave.inc
40
41 --eval CHANGE REPLICATION SOURCE TO SOURCE_DELAY= $delay_2 for channel 'channel_3';
42 --let $rpl_channel_name= 'channel_3'
43 --source include/start_slave.inc
44
45 --let $master= server_1
46 --let $slave= server_2
47 --let $rpl_channel_name= 'channel_1'
48 --let $slave_sleep= $slave_sleep_1
49
50 --let $rpl_connection_name= server_1
51 --source include/rpl_connection.inc
52
53 CREATE TABLE t1 (a INT);
54 --let $trx_num= 1
55 --source extra/rpl_tests/check_slave_delay_multi_source.inc
56
57 INSERT INTO t1 VALUES (1);
58 --let $trx_num= 2
59 --source extra/rpl_tests/check_slave_delay_multi_source.inc
60
61 UPDATE t1 SET a=2;
62 --let $trx_num= 3
63 --source extra/rpl_tests/check_slave_delay_multi_source.inc
64
65 DELETE FROM t1 WHERE a=2;
66 --let $trx_num= 4
67 --source extra/rpl_tests/check_slave_delay_multi_source.inc
68
69 START TRANSACTION;
70 INSERT INTO t1 VALUES (1);
71 INSERT INTO t1 VALUES (2);
72 INSERT INTO t1 VALUES (3);
73 COMMIT;
74 --let $trx_num= 5
75 --source extra/rpl_tests/check_slave_delay_multi_source.inc
76
77 DROP TABLE t1;
78 --let $trx_num= 6
79 --source extra/rpl_tests/check_slave_delay_multi_source.inc
80
81
82 #Do the transactions on the second master server_3
83
84 --let $master= server_3
85 --let $slave= server_2
86 --let $rpl_channel_name= 'channel_3'
87 --let $slave_sleep= $slave_sleep_2
88
89 --let $rpl_connection_name= server_3
90 --source include/rpl_connection.inc
91
92 CREATE TABLE t2 (a INT);
93 --let $trx_num= 1
94 --source extra/rpl_tests/check_slave_delay_multi_source.inc
95
96 INSERT INTO t2 VALUES (1);
97 --let $trx_num= 2
98 --source extra/rpl_tests/check_slave_delay_multi_source.inc
99
100 UPDATE t2 SET a=2;
101 --let $trx_num= 3
102 --source extra/rpl_tests/check_slave_delay_multi_source.inc
103
104 DELETE FROM t2 WHERE a=2;
105 --let $trx_num= 4
106 --source extra/rpl_tests/check_slave_delay_multi_source.inc
107
108 START TRANSACTION;
109 INSERT INTO t2 VALUES (1);
110 INSERT INTO t2 VALUES (2);
111 INSERT INTO t2 VALUES (3);
112 COMMIT;
113 --let $trx_num= 5
114 --source extra/rpl_tests/check_slave_delay_multi_source.inc
115
116 DROP TABLE t2;
117 --let $trx_num= 6
118 --source extra/rpl_tests/check_slave_delay_multi_source.inc
119
120 # Cleanup
121 --let $rpl_connection_name= server_2
122 --source include/rpl_connection.inc
123
124 --let $rpl_channel_name=
125 --source include/stop_slave_sql.inc
126 CHANGE REPLICATION SOURCE TO SOURCE_DELAY= 0 For channel 'channel_1';
127 CHANGE REPLICATION SOURCE TO SOURCE_DELAY= 0 For channel 'channel_3';
128 --source include/start_slave_sql.inc
129
130 --let $rpl_skip_sync= 1
131 --source include/rpl_end.inc