Debian Codegraph @

mysql-test/suite/galera/t/galera_circular_replication.test

raw
1 #
2 # Test circular replication where galera cluster is async replica and master
3 #
4 # mariadb #4 galera galera
5 # primary1
6 # replica2
7 # ---async replication-->replica1 #1 <--galera replication--> node_2 #2
8 # ^ ^
9 # | | galera replication
10 # | v
11 # +<------------------async replication----------------------primary2 (galera) #3
12 #
13 # Test outline:
14 #
15 # - Create user for async replication in primary1
16 # - Create user for async replication in primary2
17 # - Create table and some data in primary1
18 # - Verify that table and data is replicated to galera nodes
19 # - Verify that mysql.gtid_slave_pos has some rows in all Galera nodes
20 # - Verify that gtid_slave_pos, gtid_binlog_pos and gtid_current_pos are
21 # same in all Galera nodes and primary1
22 # - Verify that writes on Galera nodes are replicated to all nodes
23 # and to primary1
24 #
25 # The galera/galera_3nodes_as_slave.cnf describes the setup of the nodes
26 #
27 --source include/force_restart.inc
28 --source include/galera_cluster.inc
29 --source include/have_innodb.inc
30
31 --connect replica1, 127.0.0.1, root, , test, $NODE_MYPORT_1
32 --connect primary2, 127.0.0.1, root, , test, $NODE_MYPORT_3
33
34 # As node #4 is not a Galera node, and galera_cluster.inc does not open connetion to it
35 # because it is both primary and replica we open both connections here
36 --connect primary1, 127.0.0.1, root, , test, $NODE_MYPORT_4
37 --connect replica2, 127.0.0.1, root, , test, $NODE_MYPORT_4
38
39 --connection primary1
40 --echo # Primary1 node creating user for replication
41 create user repl@'%' identified by 'repl';
42 grant all on *.* to repl@'%';
43 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
44
45 --let $node_1 = replica1
46 --let $node_2 = node_2
47 --let $node_3 = primary2
48 --let $node_4 = primary1
49 --source include/auto_increment_offset_save.inc
50
51 --connection replica1
52 --echo # Galera replica changing master to primary1
53 --disable_query_log
54 --eval CHANGE MASTER TO master_host='127.0.0.1', master_user='repl', master_password='repl', master_ssl_verify_server_cert=0, master_port=$NODE_MYPORT_4, master_use_gtid=slave_pos;
55 --enable_query_log
56 START SLAVE;
57
58 --connection primary2
59 --echo # Primary2 creating user for replication
60 create user repl2@'%' identified by 'repl2';
61 grant all on *.* to repl2@'%';
62
63 --connection replica2
64 --echo # replica2 changing master to primary2
65 --disable_query_log
66 --eval CHANGE MASTER TO master_host='127.0.0.1', master_user='repl2', master_password='repl2', master_ssl_verify_server_cert=0, master_port=$NODE_MYPORT_3, master_use_gtid=slave_pos;
67 --enable_query_log
68 START SLAVE;
69
70 --connection primary1
71 --echo # Primary1: Creating table and populating it with data
72 CREATE TABLE t1 (id bigint auto_increment primary key, msg varchar(100)) engine=innodb;
73 --echo # Intentionally generate 1k GTID-events
74 --let $inserts=1000
75 --let $count=0
76 --disable_query_log
77 while($count < $inserts)
78 {
79 --eval insert into t1 values (NULL,'test1')
80 --inc $count
81 }
82 --enable_query_log
83
84 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
85
86 --connection replica1
87 --echo # Waiting for data to replicate to replica
88 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
89 --source include/wait_condition.inc
90
91 --let $wait_condition = SELECT COUNT(*) = 1000 FROM t1;
92 --source include/wait_condition.inc
93
94 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
95
96 --echo # Writing more data to table
97 --echo # Intentionally generate 1k GTID-events
98 --let $inserts=1000
99 --let $count=0
100 --disable_query_log
101 while($count < $inserts)
102 {
103 --eval insert into t1 values (NULL,'test1')
104 --inc $count
105 }
106 --enable_query_log
107
108 SELECT COUNT(*) AS EXPECT_2000 FROM t1;
109
110 --connection node_2
111 --echo # Waiting for data to replicate to Galera node_2
112 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
113 --source include/wait_condition.inc
114
115 --let $wait_condition = SELECT COUNT(*) = 2000 FROM t1;
116 --source include/wait_condition.inc
117
118 SELECT COUNT(*) AS EXPECT_2000 FROM t1;
119
120 --echo # Writing more data to table
121 --echo # Intentionally generate 1k GTID-events
122 --let $inserts=1000
123 --let $count=0
124 --disable_query_log
125 while($count < $inserts)
126 {
127 --eval insert into t1 values (NULL,'test1')
128 --inc $count
129 }
130 --enable_query_log
131
132 SELECT COUNT(*) AS EXPECT_3000 FROM t1;
133
134 --connection primary2
135 --echo # Waiting for data to replicate to primary2
136 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
137 --source include/wait_condition.inc
138
139 --let $wait_condition = SELECT COUNT(*) = 3000 FROM t1;
140 --source include/wait_condition.inc
141
142 SELECT COUNT(*) AS EXPECT_3000 FROM t1;
143
144 --echo # Writing more data to table
145 --echo # Intentionally generate 1k GTID-events
146 --let $inserts=1000
147 --let $count=0
148 --disable_query_log
149 while($count < $inserts)
150 {
151 --eval insert into t1 values (NULL,'test1')
152 --inc $count
153 }
154 --enable_query_log
155
156 SELECT COUNT(*) AS EXPECT_4000 FROM t1;
157
158 --connection primary1
159 --echo # Waiting for data to replicate to primary1
160 --let $wait_condition = SELECT COUNT(*) = 4000 FROM t1;
161 --let $wait_condition_on_error_output = SHOW SLAVE STATUS;
162 --source include/wait_condition_with_debug.inc
163
164 SELECT COUNT(*) AS EXPECT_4000 FROM t1;
165 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
166 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
167 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
168
169 --connection replica1
170 --echo # Waiting for data to replicate to replica
171 --let $wait_condition = SELECT COUNT(*) = 4000 FROM t1;
172 --source include/wait_condition.inc
173
174 SELECT COUNT(*) AS EXPECT_4000 FROM t1;
175 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
176 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
177 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
178
179 --connection node_2
180 --echo # Waiting for data to replicate to node_2
181 --let $wait_condition = SELECT COUNT(*) = 4000 FROM t1;
182 --source include/wait_condition.inc
183
184 SELECT COUNT(*) AS EXPECT_4000 FROM t1;
185 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
186 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
187 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
188
189 --connection primary2
190 --echo # Waiting for data to replicate to node_3
191 --let $wait_condition = SELECT COUNT(*) = 4000 FROM t1;
192 --source include/wait_condition.inc
193
194 SELECT COUNT(*) AS EXPECT_4000 FROM t1;
195 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
196 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
197 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
198 #
199 # Cleanup
200 #
201 --connection primary1
202 drop table t1;
203
204 --echo # Wait until drop table is replicated on Galera
205 --connection replica1
206 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
207 --source include/wait_condition.inc
208
209 --connection node_2
210 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
211 --source include/wait_condition.inc
212
213 --connection primary2
214 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
215 --source include/wait_condition.inc
216
217 --connection replica1
218 STOP SLAVE;
219 RESET SLAVE ALL;
220
221 --connection replica2
222 STOP SLAVE;
223 RESET SLAVE ALL;
224 RESET MASTER;
225
226 --source include/auto_increment_offset_restore.inc
227
228 --connection node_1
229 --disconnect primary1
230 --disconnect replica1
231 --disconnect primary2
232 --disconnect replica2
233
234 --source include/galera_end.inc
235 --echo # End of test