Debian Codegraph @

mysql-test/suite/galera/r/galera_circular_replication.result

raw
1 connection node_2;
2 connection node_1;
3 connect replica1, 127.0.0.1, root, , test, $NODE_MYPORT_1;
4 connect primary2, 127.0.0.1, root, , test, $NODE_MYPORT_3;
5 connect primary1, 127.0.0.1, root, , test, $NODE_MYPORT_4;
6 connect replica2, 127.0.0.1, root, , test, $NODE_MYPORT_4;
7 connection primary1;
8 # Primary1 node creating user for replication
9 create user repl@'%' identified by 'repl';
10 grant all on *.* to repl@'%';
11 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
12 connection replica1;
13 connection node_2;
14 connection primary2;
15 connection primary1;
16 connection replica1;
17 # Galera replica changing master to primary1
18 START SLAVE;
19 connection primary2;
20 # Primary2 creating user for replication
21 create user repl2@'%' identified by 'repl2';
22 grant all on *.* to repl2@'%';
23 connection replica2;
24 # replica2 changing master to primary2
25 START SLAVE;
26 connection primary1;
27 # Primary1: Creating table and populating it with data
28 CREATE TABLE t1 (id bigint auto_increment primary key, msg varchar(100)) engine=innodb;
29 # Intentionally generate 1k GTID-events
30 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
31 EXPECT_1000
32 1000
33 connection replica1;
34 # Waiting for data to replicate to replica
35 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
36 EXPECT_1000
37 1000
38 # Writing more data to table
39 # Intentionally generate 1k GTID-events
40 SELECT COUNT(*) AS EXPECT_2000 FROM t1;
41 EXPECT_2000
42 2000
43 connection node_2;
44 # Waiting for data to replicate to Galera node_2
45 SELECT COUNT(*) AS EXPECT_2000 FROM t1;
46 EXPECT_2000
47 2000
48 # Writing more data to table
49 # Intentionally generate 1k GTID-events
50 SELECT COUNT(*) AS EXPECT_3000 FROM t1;
51 EXPECT_3000
52 3000
53 connection primary2;
54 # Waiting for data to replicate to primary2
55 SELECT COUNT(*) AS EXPECT_3000 FROM t1;
56 EXPECT_3000
57 3000
58 # Writing more data to table
59 # Intentionally generate 1k GTID-events
60 SELECT COUNT(*) AS EXPECT_4000 FROM t1;
61 EXPECT_4000
62 4000
63 connection primary1;
64 # Waiting for data to replicate to primary1
65 SELECT COUNT(*) AS EXPECT_4000 FROM t1;
66 EXPECT_4000
67 4000
68 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
69 EXPECT_1
70 1
71 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
72 EXPECT_1
73 1
74 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
75 @@gtid_slave_pos @@gtid_binlog_pos @@gtid_current_pos
76 0-4-1004,16-15-3002 0-4-1004,16-15-3002 0-4-1004,16-15-3002
77 connection replica1;
78 # Waiting for data to replicate to replica
79 SELECT COUNT(*) AS EXPECT_4000 FROM t1;
80 EXPECT_4000
81 4000
82 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
83 EXPECT_1
84 1
85 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
86 EXPECT_1
87 1
88 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
89 @@gtid_slave_pos @@gtid_binlog_pos @@gtid_current_pos
90 0-4-1004,16-15-3002 0-4-1004,16-15-3002 0-4-1004,16-15-3002
91 connection node_2;
92 # Waiting for data to replicate to node_2
93 SELECT COUNT(*) AS EXPECT_4000 FROM t1;
94 EXPECT_4000
95 4000
96 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
97 EXPECT_1
98 1
99 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
100 EXPECT_1
101 1
102 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
103 @@gtid_slave_pos @@gtid_binlog_pos @@gtid_current_pos
104 0-4-1004 0-4-1004,16-15-3002 0-4-1004,16-15-3002
105 connection primary2;
106 # Waiting for data to replicate to node_3
107 SELECT COUNT(*) AS EXPECT_4000 FROM t1;
108 EXPECT_4000
109 4000
110 SELECT COUNT(*) > 0 AS EXPECT_1 FROM mysql.gtid_slave_pos;
111 EXPECT_1
112 1
113 SELECT COUNT(*) < 1000 AS EXPECT_1 FROM mysql.gtid_slave_pos;
114 EXPECT_1
115 1
116 SELECT @@gtid_slave_pos,@@gtid_binlog_pos,@@gtid_current_pos;
117 @@gtid_slave_pos @@gtid_binlog_pos @@gtid_current_pos
118 0-4-1004 0-4-1004,16-15-3002 0-4-1004,16-15-3002
119 connection primary1;
120 drop table t1;
121 # Wait until drop table is replicated on Galera
122 connection replica1;
123 connection node_2;
124 connection primary2;
125 connection replica1;
126 STOP SLAVE;
127 RESET SLAVE ALL;
128 connection replica2;
129 STOP SLAVE;
130 RESET SLAVE ALL;
131 RESET MASTER;
132 connection node_1;
133 disconnect primary1;
134 disconnect replica1;
135 disconnect primary2;
136 disconnect replica2;
137 disconnect node_2;
138 disconnect node_1;
139 # End of test