Debian Codegraph @

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

raw
1 ###############################################################################
2 # Description: Checks if DDL and DML statements are correctly logged by
3 # servers and slave servers according to log-replica-updates,
4 # and independent of their settings on the particular MySQLD
5 # acting in the slave role
6 #
7 # Testing scenario: Cluster 1 replicates to Cluster 2
8 # Key : BL = log-bin, LSU = log-replica-updates
9 #
10 # BL BL
11 # cluster 1 [ srv_master srv_master1 srv_master2 ]
12 # |----------+------------
13 # v v v
14 # cluster 2 [ srv_slave srv_slave1 srv_slave2 ]
15 # BL BL LSU
16 #
17 # - First replicate via srv_slave and check all nodes' Binlog contents
18 # - Second replicate via srv_slave1 and check all nodes' Binlog contents
19 # - Third replicate via srv_slave2 and check all nodes' Binlog contents
20 #
21 # Makes use of suite/ndb_rpl/t/ndb_rpl_multi_binlog_update.inc
22 # Originally motivated by bug#45756
23 ###############################################################################
24
25 --source include/have_ndb.inc
26 --source include/have_log_bin.inc
27
28 ###############################################################################
29 # Configuring Environment
30 ###############################################################################
31
32 # setup _no_ replication to start with, but with all 6 servers included
33 --let $rpl_topology= none
34 --let $rpl_server_count= 6
35 --let $rpl_skip_reset_master_and_slave=1
36 --source include/rpl_init.inc
37 --let $rpl_skip_reset_master_and_slave=0
38
39 --echo *** Configuring connections ***
40 --let $rpl_connection_name= srv_master
41 --let $rpl_server_number= 1
42 --source include/rpl_connect.inc
43
44 --let $rpl_connection_name= srv_master1
45 --let $rpl_server_number= 2
46 --source include/rpl_connect.inc
47
48 --let $rpl_connection_name= srv_master2
49 --let $rpl_server_number= 3
50 --source include/rpl_connect.inc
51
52 --let $rpl_connection_name= srv_slave
53 --let $rpl_server_number= 4
54 --source include/rpl_connect.inc
55
56 --let $rpl_connection_name= srv_slave1
57 --let $rpl_server_number= 5
58 --source include/rpl_connect.inc
59
60 --let $rpl_connection_name= srv_slave2
61 --let $rpl_server_number= 6
62 --source include/rpl_connect.inc
63
64 --echo *** Waiting for each cluster to startup ***
65
66 # Check schema op binlogging enabled between servers on cluster1
67 --let $source_server=srv_master
68 --let $dest_server=srv_master2
69 source suite/ndb_rpl/t/wait_schema_logging.inc;
70
71 --let $source_server=srv_master1
72 --let $dest_server=srv_master
73 source suite/ndb_rpl/t/wait_schema_logging.inc;
74
75 --let $source_server=srv_master1
76 --let $dest_server=srv_master2
77 source suite/ndb_rpl/t/wait_schema_logging.inc;
78
79 --let $source_server=srv_master2
80 --let $dest_server=srv_master
81 source suite/ndb_rpl/t/wait_schema_logging.inc;
82
83 # Check schema op binlogging enabled between servers on cluster2
84 --let $source_server=srv_slave
85 --let $dest_server=srv_slave1
86 source suite/ndb_rpl/t/wait_schema_logging.inc;
87
88 --let $source_server=srv_slave
89 --let $dest_server=srv_slave2
90 source suite/ndb_rpl/t/wait_schema_logging.inc;
91
92 --let $source_server=srv_slave1
93 --let $dest_server=srv_slave2
94 source suite/ndb_rpl/t/wait_schema_logging.inc;
95
96 --let $source_server=srv_slave2
97 --let $dest_server=srv_slave1
98 source suite/ndb_rpl/t/wait_schema_logging.inc;
99
100 # Reset state of all Binlogging nodes
101 --disable_query_log
102 connection srv_master;
103 --disable_warnings
104 RESET MASTER;
105 --enable_warnings
106
107 connection srv_master2;
108 --disable_warnings
109 RESET MASTER;
110 --enable_warnings
111
112 connection srv_slave1;
113 --disable_warnings
114 RESET MASTER;
115 --enable_warnings
116
117 connection srv_slave2;
118 --disable_warnings
119 RESET MASTER;
120 --enable_warnings
121 --enable_query_log
122
123
124
125 --echo *** Configuring replication via Slave ***
126 --let $rpl_connection_name= srv_slave
127 --source include/rpl_connection.inc
128
129 --let $rpl_topology= 1->4
130 --source include/rpl_change_topology.inc
131
132 --source include/start_slave.inc
133
134 # Run the test script
135 --let $which_slave=srv_slave
136 --source suite/ndb_rpl/t/ndb_rpl_multi_binlog_update.inc
137
138 --source include/stop_slave.inc
139
140 # Reset state of all Binlogging nodes
141 --disable_query_log
142 connection srv_master;
143 --disable_warnings
144 RESET MASTER;
145 --enable_warnings
146
147 connection srv_master2;
148 --disable_warnings
149 RESET MASTER;
150 --enable_warnings
151
152 connection srv_slave1;
153 --disable_warnings
154 RESET MASTER;
155 --enable_warnings
156
157 connection srv_slave2;
158 --disable_warnings
159 RESET MASTER;
160 --enable_warnings
161 --enable_query_log
162
163
164
165 --echo *** Configuring replication via Slave1 ***
166 --let $rpl_connection_name= srv_slave1
167 --source include/rpl_connection.inc
168
169 --let $rpl_topology= 1->4,1->5
170 --source include/rpl_change_topology.inc
171
172 --source include/start_slave.inc
173
174 # Run the test script
175 --let $which_slave=srv_slave1
176 --source suite/ndb_rpl/t/ndb_rpl_multi_binlog_update.inc
177
178 --source include/stop_slave.inc
179
180 # Reset state of all Binlogging nodes
181 --disable_query_log
182 connection srv_master;
183 --disable_warnings
184 RESET MASTER;
185 --enable_warnings
186
187 connection srv_master2;
188 --disable_warnings
189 RESET MASTER;
190 --enable_warnings
191
192 connection srv_slave1;
193 --disable_warnings
194 RESET MASTER;
195 --enable_warnings
196
197 connection srv_slave2;
198 --disable_warnings
199 RESET MASTER;
200 --enable_warnings
201 --enable_query_log
202
203
204
205 --echo *** Configuring replication via Slave2 ***
206 --let $rpl_connection_name= srv_slave2
207 --source include/rpl_connection.inc
208
209 --let $rpl_topology= 1->4,1->5,1->6
210 --source include/rpl_change_topology.inc
211
212 --source include/start_slave.inc
213
214 # Run the test script
215 --let $which_slave=srv_slave2
216 --source suite/ndb_rpl/t/ndb_rpl_multi_binlog_update.inc
217
218 --source include/stop_slave.inc
219
220
221
222 # Cleanup and reset replication settings to how
223 # they where when test started
224 --let $rpl_topology= none
225 --source include/rpl_change_topology.inc
226
227 --source include/rpl_end.inc