Debian Codegraph @

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

raw
1 #############################################################
2 # Author: Serge Kozlov <[email protected]>
3 # Date: 03/17/2008
4 # Purpose: Testing cluster circular replication based on two
5 # independent channels between two clusters
6 #############################################################
7 --source include/have_ndb.inc
8 --source suite/ndb_rpl/ndb_master-slave_2ch.inc
9 --source include/have_binlog_format_mixed_or_row.inc
10 --echo
11
12 # Check server_id and set auto_increment_* variables
13 --echo *** Check server_id of mysqld servers ***
14 --connection master
15 SHOW VARIABLES LIKE "server_id";
16 SET auto_increment_offset = 1;
17 SET auto_increment_increment = 2;
18 --connection master1
19 SHOW VARIABLES LIKE "server_id";
20 SET auto_increment_offset = 1;
21 SET auto_increment_increment = 2;
22 --connection slave
23 SHOW VARIABLES LIKE "server_id";
24 SET auto_increment_offset = 2;
25 SET auto_increment_increment = 2;
26 --connection slave1
27 SHOW VARIABLES LIKE "server_id";
28 SET auto_increment_offset = 2;
29 SET auto_increment_increment = 2;
30 --echo
31
32 # Preparing data.
33 --echo *** Preparing data ***
34 --connection master
35 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT, b VARCHAR(100), c INT NOT NULL, PRIMARY KEY(a)) ENGINE=ndb;
36
37 let $wait_binlog_event= CREATE TABLE t1;
38 --source include/wait_for_binlog_event.inc
39 --connection master1
40 --source include/wait_for_binlog_event.inc
41 --connection slave
42 --source include/wait_for_binlog_event.inc
43 --connection slave1
44 --source include/wait_for_binlog_event.inc
45 --echo
46
47 #
48 # Testing
49 #
50
51 --echo *** Basic testing ***
52 # insert data via all hosts
53 --echo Insert rows via all hosts
54 --disable_query_log
55 let $counter= 10;
56 while ($counter) {
57 --connection master
58 INSERT INTO t1(b,c) VALUES('master',1);
59 --connection master1
60 INSERT INTO t1(b,c) VALUES('master1',1);
61 --connection slave
62 INSERT INTO t1(b,c) VALUES('slave',1);
63 --connection slave1
64 INSERT INTO t1(b,c) VALUES('slave1',1);
65 dec $counter;
66 }
67 --connection master
68 --enable_query_log
69
70 # Wait replication between clusters
71 let $wait_condition= SELECT COUNT(*)=40 FROM t1 WHERE c = 1;
72 --source include/wait_condition.inc
73 --connection slave
74 --source include/wait_condition.inc
75
76 # Check data
77 --echo Check data on both clusters
78 let $diff_tables= master:t1, slave:t1;
79 source include/diff_tables.inc;
80
81 --echo *** Transaction testing ***
82 # Start transaction for one mysqld and do mass of inserts for other.
83 # Do it for for both clusters
84
85 --connection master
86 BEGIN;
87 --connection slave1
88 BEGIN;
89 let $counter= 100;
90 --connection master
91 --disable_query_log
92 while ($counter) {
93 --connection master
94 INSERT INTO t1(b,c) VALUES('master',2);
95 --connection master1
96 INSERT INTO t1(b,c) VALUES('master1',2);
97 --connection slave
98 INSERT INTO t1(b,c) VALUES('slave',2);
99 --connection slave1
100 INSERT INTO t1(b,c) VALUES('slave1',2);
101 dec $counter;
102 }
103 --connection master
104 --enable_query_log
105 COMMIT;
106 --connection slave1
107 COMMIT;
108
109 # Wait replication between clusters
110 --connection master
111 let $wait_condition= SELECT COUNT(*)=400 FROM t1 WHERE c = 2;
112 --source include/wait_condition.inc
113 --connection slave
114 --source include/wait_condition.inc
115
116 --echo Check data on both clusters
117 let $diff_tables= master:t1, slave:t1;
118 source include/diff_tables.inc;
119
120 # Start transaction and then roll back
121
122 --connection master
123 BEGIN;
124 --connection slave1
125 BEGIN;
126 let $counter= 100;
127 --connection master
128 --disable_query_log
129 while ($counter) {
130 --connection master
131 INSERT INTO t1(b,c) VALUES('master',3);
132 --connection master1
133 INSERT INTO t1(b,c) VALUES('master1',3);
134 --connection slave
135 INSERT INTO t1(b,c) VALUES('slave',3);
136 --connection slave1
137 INSERT INTO t1(b,c) VALUES('slave1',3);
138 dec $counter;
139 }
140 --connection master
141 --enable_query_log
142 ROLLBACK;
143 --connection slave1
144 ROLLBACK;
145
146 # Wait replication between clusters
147 --connection master
148 let $wait_condition= SELECT COUNT(*)=200 FROM t1 WHERE c = 3;
149 --source include/wait_condition.inc
150 --connection slave
151 --source include/wait_condition.inc
152
153 --echo Check data on both clusters
154 let $diff_tables= master:t1, slave:t1;
155 source include/diff_tables.inc;
156
157 # Clean up
158 --connection master
159 DROP TABLE IF EXISTS t1;
160 --connection slave
161 # Wait until table is dropped on slave.
162 --let $query= SELECT COUNT(*) FROM t1
163 --source include/wait_for_query_to_fail.inc
164 --echo
165
166 --connection master
167
168 # End of test 5.1
169 --source suite/ndb_rpl/ndb_master-slave_2ch_end.inc
170