Debian Codegraph @

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

raw
1 #
2 # Test two primary nodes async replication to Galera cluster
3 #
4 # primary1 primary2
5 # #3 #4
6 # | |
7 # | async replication v
8 # +-------------------+ +----------------+
9 # | |
10 # v v
11 # galera replica <------galera replication-------->galera node_2
12 # #1 #2
13 #
14 # Test outline
15 #
16 # - Create user for async replication and table with rows in both primaries
17 # - Verify that tables and rows are replicated to all Galera nodes
18 # - Verify that gtid position is same in all Galera nodes
19 #
20 # The galera/galera_2nodes_as_replica_2primary.cnf describes the setup of the nodes
21 #
22 --source include/force_restart.inc
23 --source include/galera_cluster.inc
24 --source include/have_innodb.inc
25
26 # As node #3 and #4 are not a Galera node, and galera_cluster.inc does not open connetion to it
27 # we open the connections here
28 --connect primary1, 127.0.0.1, root, , test, $NODE_MYPORT_3
29 --connect primary2, 127.0.0.1, root, , test, $NODE_MYPORT_4
30 --connection primary1
31 --echo # Primary1 creating user for replication
32 create user repl@'%' identified by 'repl';
33 grant all on *.* to repl@'%';
34
35 --connection primary2
36 --echo # Primary2 creating user for replication
37 create user repl2@'%' identified by 'repl2';
38 grant all on *.* to repl2@'%';
39
40 --connect replica, 127.0.0.1, root, , test, $NODE_MYPORT_1
41
42 --let $node_1 = replica
43 --let $node_2 = node_2
44 --let $node_3 = primary1
45 --let $node_4 = primary2
46 --source include/auto_increment_offset_save.inc
47
48 --connection replica
49 --echo # Galera replica changing master to primary1
50 SET @@default_master_connection='stream1';
51 --disable_query_log
52 --eval CHANGE MASTER 'stream1' TO master_host='127.0.0.1', master_user='repl', master_password='repl', master_ssl_verify_server_cert=0, master_port=$NODE_MYPORT_3, master_use_gtid=slave_pos;
53 --enable_query_log
54
55 --echo # Primary node changing master to primary2
56 SET @@default_master_connection='stream2';
57 --disable_query_log
58 --eval CHANGE MASTER 'stream2' TO master_host='127.0.0.1', master_user='repl2', master_password='repl2', master_ssl_verify_server_cert=0, master_port=$NODE_MYPORT_4, master_use_gtid=slave_pos;
59 --enable_query_log
60
61 START ALL SLAVES;
62
63 --connection primary1
64 --echo # Primary 1: Creating table and populating it with data
65 CREATE TABLE t1 (id bigint auto_increment primary key, msg varchar(100)) engine=innodb;
66 --disable_query_log
67 --echo # Intentionally generate 1k GTID-events
68 --let $inserts=1000
69 --let $count=0
70 --disable_query_log
71 while($count < $inserts)
72 {
73 --eval insert into t1 values (NULL,'test1')
74 --inc $count
75 }
76 --enable_query_log
77
78 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
79
80 --connection primary2
81 --echo # Primary 2: Creating table and populating it with data
82 CREATE TABLE t2 (id bigint auto_increment primary key, msg varchar(100)) engine=innodb;
83 --echo # Intentionally generate 1k GTID-events
84 --let $inserts=1000
85 --let $count=0
86 --disable_query_log
87 while($count < $inserts)
88 {
89 --eval insert into t2 values (NULL,'test1')
90 --inc $count
91 }
92 --enable_query_log
93
94 SELECT COUNT(*) AS EXPECT_1000 FROM t2;
95
96 --connection replica
97 --echo # Waiting for data to replicate to node_1
98 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
99 --let $wait_condition_on_error_output = SHOW ALL SLAVES STATUS;
100 --source include/wait_condition_with_debug.inc
101 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't2';
102 --let $wait_condition_on_error_output = SHOW ALL SLAVES STATUS;
103 --source include/wait_condition_with_debug.inc
104
105 --let $wait_condition = SELECT COUNT(*) = 1000 FROM t1;
106 --source include/wait_condition.inc
107 --let $wait_condition = SELECT COUNT(*) = 1000 FROM t2;
108 --source include/wait_condition.inc
109
110 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
111 SELECT COUNT(*) AS EXPECT_1000 FROM t2;
112
113 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
114 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
115 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
116
117 --connection node_2
118 --echo # Waiting for data to replicate to node_2
119 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
120 --source include/wait_condition.inc
121 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't2';
122 --source include/wait_condition.inc
123
124 --let $wait_condition = SELECT COUNT(*) = 1000 FROM t1;
125 --source include/wait_condition.inc
126 --let $wait_condition = SELECT COUNT(*) = 1000 FROM t2;
127 --source include/wait_condition.inc
128
129 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
130 SELECT COUNT(*) AS EXPECT_1000 FROM t2;
131 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
132 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
133 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
134 #
135 # Cleanup
136 #
137 --connection primary1
138 drop table t1;
139 --connection primary2
140 drop table t2;
141
142 --echo # Wait until drop table is replicated on Galera
143 --connection replica
144 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
145 --source include/wait_condition.inc
146 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't2';
147 --source include/wait_condition.inc
148
149 --connection node_2
150 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
151 --source include/wait_condition.inc
152 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't2';
153 --source include/wait_condition.inc
154
155 --connection replica
156 STOP ALL SLAVES;
157 RESET SLAVE ALL;
158
159 --connection primary1
160 RESET MASTER;
161 --connection primary2
162 RESET MASTER;
163
164 --source include/auto_increment_offset_restore.inc
165
166 --connection node_1
167 --disconnect primary1
168 --disconnect primary2
169 --disconnect replica
170
171 --source include/galera_end.inc
172 --echo # End of test