Debian Codegraph @

mysql-test/suite/rpl/t/rpl_test_framework.test

raw
1 # ==== Purpose ====
2 #
3 # Test that the sync chain generated by
4 # include/rpl_change_topology.inc (sourced from include/rpl_init.inc)
5 # is correct.
6 #
7 # We test a number of different topologies. Each topology is tested
8 # in extra/rpl_tests/rpl_test_framework.inc. See
9 # extra/rpl_tests/rpl_test_framework.inc for details on how the sync
10 # chain is tested.
11 #
12 # ==== Related bugs ====
13 #
14 # BUG#49978: Replication tests don't clean up replication state at the end
15
16 --source include/not_parallel.inc
17 --source include/no_valgrind_without_big.inc
18
19 # We only need to execute this test once. Also, we rely on 'DELETE
20 # FROM t1' to remove rows in slave tables that don't exist in master
21 # tables (see include/rpl_test_framework.inc for details).
22 --source include/have_binlog_format_statement.inc
23
24
25 --echo ==== Create t1 on all servers. ====
26 if ($mtr_supports_more_than_10_servers)
27 {
28 --let $rpl_server_count= 15
29 --let $rpl_topology= 1->2->3->4->5->6->7->8->9->10->11->12->13->14->15
30 }
31 if (!$mtr_supports_more_than_10_servers)
32 {
33 --let $rpl_server_count= 9
34 --let $rpl_topology= 1->2->3->4->5->6->7->8->9
35 }
36 --source include/rpl_init.inc
37 CREATE TABLE t1 (a INT);
38 --source include/rpl_end.inc
39
40 # Initialize $next_number before first call to
41 # extra/rpl_tests/rpl_test_framework.text
42 --let $next_number= 0
43
44
45 --echo ==== Test 3-server topologies ====
46
47 --let $rpl_server_count= 3
48
49 --let $rpl_topology= 1 -> 2
50 --let $masters= 1,3
51 --source extra/rpl_tests/rpl_test_framework.inc
52
53 --let $rpl_topology= 2 -> 3
54 --let $masters= 1,2
55 --source extra/rpl_tests/rpl_test_framework.inc
56
57 --let $rpl_topology= none
58 --let $masters= 1,2,3
59 --source extra/rpl_tests/rpl_test_framework.inc
60
61 --let $rpl_topology= 1->2, 2->1
62 --let $masters= 1,3
63 --source extra/rpl_tests/rpl_test_framework.inc
64
65 --let $rpl_topology= 1->2->1
66 --let $masters= 2,3
67 --source extra/rpl_tests/rpl_test_framework.inc
68
69 --let $rpl_topology= 2->1->2
70 --let $masters= 1,3
71 --source extra/rpl_tests/rpl_test_framework.inc
72
73 --let $rpl_topology= 1->2->3
74 --let $masters= 1
75 --source extra/rpl_tests/rpl_test_framework.inc
76
77 --let $rpl_topology= 2->3->2->1
78 --let $masters= 3
79 --source extra/rpl_tests/rpl_test_framework.inc
80
81 --let $rpl_topology= 1->2,2->3,3->1
82 --let $masters= 3
83 --source extra/rpl_tests/rpl_test_framework.inc
84
85 --let $rpl_topology= 1->3->2->1
86 --let $masters= 3
87 --source extra/rpl_tests/rpl_test_framework.inc
88
89
90 --echo ==== Test 6-server topologies ====
91
92 --let $rpl_server_count= 6
93
94 --let $rpl_topology= 1->2->3->4->1->5->6
95 --let $masters= 1
96 --source extra/rpl_tests/rpl_test_framework.inc
97
98 --let $rpl_topology= 3->4->5->6->3->1->2
99 --let $masters= 4
100 --source extra/rpl_tests/rpl_test_framework.inc
101
102 --let $rpl_topology= 6->5->4->3->2->1
103 --let $masters= 6
104 --source extra/rpl_tests/rpl_test_framework.inc
105
106 --let $rpl_topology= 1->2->3->1,4->5->6
107 --let $masters= 3,4
108 --source extra/rpl_tests/rpl_test_framework.inc
109
110
111 --echo ==== Test 9-server topology ====
112
113 --let $rpl_server_count= 9
114
115 --let $rpl_topology= 1->2, 2->3, 3->4, 4->5, 5->1, 1->6, 6->7, 6->8, 8->9
116 --let $masters= 2
117 --source extra/rpl_tests/rpl_test_framework.inc
118
119 if ($mtr_supports_more_than_10_servers) {
120 --echo ==== Test 15-server topologies ====
121
122 --let $rpl_server_count= 15
123
124 --let $rpl_topology= 1->2->3->4->5->6->7->8->9->10->11->12->13->14->15->1
125 --let $masters= 2
126 --source extra/rpl_tests/rpl_test_framework.inc
127
128 # This is a binary tree
129 --let $rpl_topology= 1->2->4->8,1->3->6->12,2->5->10,3->7->14,4->9,5->11,6->13,7->15
130 --let $masters= 1
131 --source extra/rpl_tests/rpl_test_framework.inc
132 }
133
134 --echo ==== Clean up ====
135
136 if ($mtr_supports_more_than_10_servers) {
137 --let $rpl_topology= 1->2->3->4->5->6->7->8->9->10->11->12->13->14->15
138 }
139 if (!$mtr_supports_more_than_10_servers) {
140 --let $rpl_topology= 1->2->3->4->5->6->7->8->9
141 }
142 --source include/rpl_init.inc
143 --connection server_1
144 DROP TABLE t1;
145 --source include/rpl_end.inc