Debian Codegraph @

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

raw
1 #==== Purpose ====
2 #
3 # This test script purpose is to check semisync replication
4 # behaviour when there are semisync slaves getting added and
5 # removed while dml changes are happening.
6 #
7 #==== Implementation ====
8 #
9 # 1) Install semisync on one Master and 8 Slaves.
10 # 2) Using mysqlslap, keep inserting data in background on Master.
11 # 3) While the DMLs are going on, keep adding/removing semisync slaves.
12 # 4) At the end of the step-3, check that the data is synced without any
13 # issues.
14 # 5) Check semisync is still enabled on Master and all slaves.
15 #
16 #==== References ====
17 #
18 # Bug#27610678 SEMI-SYNC REPLICATION DOESN'T WORK FOR MINUTES AFTER RESTART
19 # REPLICATION
20 #
21 #========
22 #
23 # 9 servers + 1000 inserts involved in test. Hence marking it as big-test.
24 #
25 --source include/big_test.inc
26 --source include/not_group_replication_plugin.inc
27 --source include/have_binlog_format_statement.inc
28 --source include/have_debug.inc
29
30 #
31 # One Master and 8 Slaves in the semi sync topology.
32 #
33 --let rpl_topology=1->2, 1->3, 1->4, 1->5, 1->6, 1->7, 1->8, 1->9
34 --source include/rpl_init.inc
35
36 --echo #
37 --echo # 1. Initial data.
38 --echo #
39 call mtr.add_suppression("Timeout waiting for reply of binlog");
40 CREATE TABLE t1(c1 INT);
41 --source include/rpl_sync.inc
42
43 --echo #
44 --echo # 2. Install semisync on all the 9 servers.
45 --echo #
46 --let $i= 1
47 while ($i < 10)
48 {
49 --let $rpl_connection_name= server_$i
50 --source include/rpl_connection.inc
51 if ( $i == 1)
52 {
53 --connect(server1_1, localhost,root,,,$MASTER_MYPORT)
54 CALL mtr.add_suppression("Semi-sync source failed on net_flush.*");
55 --source include/install_semisync_source.inc
56 }
57 if ( $i != 1 )
58 {
59 CALL mtr.add_suppression("Semi-sync replica net_flush.*");
60 --source include/install_semisync_replica.inc
61 }
62 --inc $i
63 }
64
65 --echo #
66 --echo # 3. Make Master aware of 8 semisync slaves.
67 --echo #
68 --let $rpl_connection_name= server1_1
69 --source include/rpl_connection.inc
70 --let $slaves = 8
71 --eval SET GLOBAL rpl_semi_sync_source_wait_for_replica_count = $slaves
72
73 --echo #
74 --echo # 4. Insert 1000 tuples in background using 10 parallel connections.
75 --echo #
76 --exec_in_background $MYSQL_SLAP --create-schema=test --delimiter=";" --iterations=100 --query="INSERT INTO t1 values (1)" --concurrency=10 --silent 2>&1
77
78 --echo #
79 --echo # 5. While the insert operations are going in the background, keep
80 --echo # adding/removing semisync slaves randomly.
81 --echo #
82 --let $rpl_connection_silent = 1
83 --let $include_silent= 1
84 --disable_result_log
85 --disable_query_log
86 --let $rpl_debug= 0
87 --let $iter= 1
88 while ( $iter < 50 )
89 {
90 # Random server_id generator ( server_id will between [2-9]
91 --let $server_id=`SELECT FLOOR(2 + ((RAND() * 100) % 8))`
92 --let $rpl_connection_name= server_$server_id
93 --source include/rpl_connection.inc
94 --let $service_state= `SELECT service_state FROM performance_schema.replication_connection_status`
95 if ($service_state == 'ON')
96 {
97 # If the replication state is ON, bring it down.
98 --source include/stop_slave.inc
99 --let $rpl_connection_name= server1_1
100 --source include/rpl_connection.inc
101 # Adjust rpl_semi_sync_source_wait_for_replica_count variable.
102 --dec $slaves
103 --eval SET GLOBAL rpl_semi_sync_source_wait_for_replica_count = $slaves
104 }
105 if ($service_state == 'OFF')
106 {
107 # If the replication state is OFF, bring it up.
108 --source include/start_slave.inc
109 --let $rpl_connection_name= server1_1
110 --source include/rpl_connection.inc
111 # Adjust rpl_semi_sync_source_wait_for_replica_count variable.
112 --inc $slaves
113 --eval SET GLOBAL rpl_semi_sync_source_wait_for_replica_count = $slaves
114 }
115 --inc $iter
116 # Do it slowly while insertions on the master are happening in the background.
117 sleep 1;
118 }
119
120 --echo #
121 --echo # 6. Add all 8 semisync slaves back to Master
122 --echo # (if they were disconnected, in above step).
123 --echo #
124 --let $iter = 2
125 while ($iter <= 9)
126 {
127 --let $rpl_connection_name= server_$iter
128 --source include/rpl_connection.inc
129 --let $service_state= `SELECT service_state FROM performance_schema.replication_connection_status`
130 if ($service_state == 'OFF')
131 {
132 --source include/start_slave.inc
133 --let $rpl_connection_name= server1_1
134 --source include/rpl_connection.inc
135 # Adjust rpl_semi_sync_source_wait_for_replica_count variable.
136 --inc $slaves
137 --eval SET GLOBAL rpl_semi_sync_source_wait_for_replica_count = $slaves
138 }
139 --inc $iter
140 }
141 --enable_result_log
142 --enable_query_log
143 --let $rpl_connection_silent = 0
144 --let $include_silent= 0
145
146
147 --echo #
148 --echo # 7. Make sure the data is synced on Master without any issues.
149 --echo #
150 --let $rpl_connection_name= server_1
151 --source include/rpl_connection.inc
152 --let $wait_timeout= 60
153 --let $wait_condition= SELECT count(*) = 1000 FROM t1
154 --source include/wait_condition.inc
155 --let $slave_timeout=600
156 --source include/rpl_sync.inc
157
158 --echo #
159 --echo # 8. Check on all servers semisync is enabled after the
160 --echo # the experiment and then uninstall semisync pluging
161 --echo # from it.
162 --echo #
163 --let $i= 9
164 while ($i >= 1)
165 {
166 --let $rpl_connection_name= server_$i
167 --source include/rpl_connection.inc
168 if ( $i == 1)
169 {
170 --let $assert_variable_name= rpl_semi_sync_source_enabled
171 --let $assert_variable_value= 1
172 --source include/assert_variable.inc
173 --source include/uninstall_semisync_source.inc
174 }
175 if ( $i != 1 )
176 {
177 --let $assert_variable_name= rpl_semi_sync_replica_enabled
178 --let $assert_variable_value= 1
179 --source include/assert_variable.inc
180 --source include/uninstall_semisync_replica.inc
181 }
182 --dec $i
183 }
184
185 --echo #
186 --echo # 9. Cleanup time.
187 --echo #
188 --let $rpl_connection_name= server_1
189 --source include/rpl_connection.inc
190 DROP TABLE t1;
191 --source include/rpl_end.inc