Debian Codegraph @

mysql-test/suite/group_replication/t/gr_xplugin_basic_dml.test

raw
1 ##############################################################################
2 #
3 # This test checks the basic functionality of group replication plugin along
4 # with mysqlx plugin.
5 #
6 # NOTE : All queries will be run through mysqlx plugin using mysqlxtest.
7 #
8 # Steps involved in this test :
9 # 0. This test requires 3 servers.
10 # 1. Start 3 servers loaded with both mysqlx and group replication plugin.
11 # 2. Start group replication on server1 as bootstrap server for the group.
12 # 3. Start group replication on other two servers as non bootstrap server.
13 # 4. Wait until all three servers come online.
14 # 5. Perform ddl and dml operations on all the three servers.
15 # a) server1 : Create table T1 and perform ddl on T1.
16 # b) server2 : Create table T2 and perform ddl on T1 & T2.
17 # c) server3 : Create table T3 and perform ddl on T1,T2 & T3.
18 # 6. Assert for values on three tables from different servers.
19 # 7. Stop group replication on all the servers through mysqlx.
20 # 8. uninstall mysqlx plugin on all servers.
21 # 9. clean-up
22 ##############################################################################
23
24 --source include/big_test.inc
25 --source include/have_mysqlx_plugin.inc
26 --source include/have_group_replication_plugin_base.inc
27
28 # This initial setup starts three servers with all the prerequisites required
29 # for GR to start
30
31 --source include/have_group_replication_plugin.inc
32 --let $rpl_skip_group_replication_start= 1
33 --let $rpl_server_count= 3
34 --source include/group_replication.inc
35
36 # Install Mysqlx plugin on all servers.
37
38 --let $rpl_connection_name= server1
39 --source include/rpl_connection.inc
40 --source include/xplugin_wait_for_interfaces.inc
41
42 --let $rpl_connection_name= server2
43 --source include/rpl_connection.inc
44 --source include/xplugin_wait_for_interfaces.inc
45
46 --let $rpl_connection_name= server3
47 --source include/rpl_connection.inc
48 --source include/xplugin_wait_for_interfaces.inc
49
50 # File for starting GR through X-protocol
51 # Bootstrap-server
52 --write_file $MYSQL_TMP_DIR/bootstrap_server.tmp
53 -->sql
54 SET GLOBAL GROUP_REPLICATION_GROUP_NAME = 'aaaaaaaa-dddd-aaaa-aaaa-aaaaaaaaaaaa';
55 SET GLOBAL GROUP_REPLICATION_BOOTSTRAP_GROUP=1;
56 START GROUP_REPLICATION;
57 SET GLOBAL GROUP_REPLICATION_BOOTSTRAP_GROUP=0;
58 -->endsql
59 EOF
60
61 # Temp file for starting group replication as non bootstrap server.
62 --write_file $MYSQL_TMP_DIR/non_bootstrap_server.tmp
63 -->sql
64 SET GLOBAL GROUP_REPLICATION_GROUP_NAME = 'aaaaaaaa-dddd-aaaa-aaaa-aaaaaaaaaaaa';
65 CHANGE REPLICATION SOURCE TO SOURCE_USER='root' FOR CHANNEL 'group_replication_recovery';
66 START GROUP_REPLICATION;
67 -->endsql
68 EOF
69
70 # Starting GR on all the servers through mysqlx
71 --echo Starting GR on server 1
72 --exec $MYSQLXTEST --ssl-cipher='ECDHE-RSA-AES128-GCM-SHA256' -u root --port=$MASTER_X_MYPORT_1 --file=$MYSQL_TMP_DIR/bootstrap_server.tmp 2>&1
73 --echo Starting GR on server 2
74 --exec $MYSQLXTEST --ssl-cipher='ECDHE-RSA-AES128-GCM-SHA256' -u root --port=$MASTER_X_MYPORT_2 --file=$MYSQL_TMP_DIR/non_bootstrap_server.tmp 2>&1
75 --echo Starting GR on server 3
76 --exec $MYSQLXTEST --ssl-cipher='ECDHE-RSA-AES128-GCM-SHA256' -u root --port=$MASTER_X_MYPORT_3 --file=$MYSQL_TMP_DIR/non_bootstrap_server.tmp 2>&1
77
78 --echo Waiting for GR members to come online.
79 --let $wait_condition=SELECT COUNT(*)=3 FROM performance_schema.replication_group_members where MEMBER_STATE="ONLINE"
80 --source include/wait_condition.inc
81
82 # Temp file for performing ddl and dml on server1
83
84 --write_file $MYSQL_TMP_DIR/ddl_dml_on_server1.tmp
85 -->sql
86 USE test;
87 CREATE TABLE T1 (C1 INT PRIMARY KEY, C2 INT );
88 INSERT INTO T1 VALUES (1,12);
89 INSERT INTO T1 VALUES (2,1234);
90 INSERT INTO T1 VALUES (3,98765);
91 UPDATE T1 SET C2 = C2 - 98765;
92 DELETE FROM T1 WHERE C2 = 0;
93 -->endsql
94 EOF
95
96 --exec $MYSQLXTEST --ssl-cipher='ECDHE-RSA-AES128-GCM-SHA256' -u root --port=$MASTER_X_MYPORT_1 --file=$MYSQL_TMP_DIR/ddl_dml_on_server1.tmp 2>&1
97
98 # Wait for synchronization between the nodes.
99
100 --source include/rpl_sync.inc
101
102 # Temp file for performing ddl and dml on server2
103
104 --write_file $MYSQL_TMP_DIR/ddl_dml_on_server2.tmp
105 -->sql
106 USE test;
107 CREATE TABLE T2 (C1 CHAR(20) PRIMARY KEY, C2 INT );
108 INSERT INTO T2 VALUES ('ABC',23);
109 UPDATE T2 SET C2 = C2 + 27;
110 INSERT INTO T1 VALUES (4,34);
111 INSERT INTO T2 VALUES ('ABCDEF',23);
112 INSERT INTO T1 VALUES (5,1234);
113 INSERT INTO T2 VALUES ('ABCDEFGHIJ',23);
114 DELETE FROM T2 WHERE C1 = 'ABC';
115 -->endsql
116 EOF
117
118 --exec $MYSQLXTEST --ssl-cipher='ECDHE-RSA-AES128-GCM-SHA256' -u root --port=$MASTER_X_MYPORT_2 --file=$MYSQL_TMP_DIR/ddl_dml_on_server2.tmp 2>&1
119
120 # Wait for synchronization between the nodes.
121
122 --source include/rpl_sync.inc
123
124 # Temp file for performing ddl and dml on server3
125
126 --write_file $MYSQL_TMP_DIR/ddl_dml_on_server3.tmp
127 -->sql
128 USE test;
129 CREATE TABLE T3 (C1 INT PRIMARY KEY, C2 VARCHAR(20) );
130 DELETE FROM T1;
131 INSERT INTO T1 VALUES (1,12345);
132 INSERT INTO T3 VALUES (1,'1234');
133 INSERT INTO T2 VALUES ('1234',1234);
134 INSERT INTO T1 VALUES (7,98765);
135 INSERT INTO T2 VALUES ('XYZ',23);
136 UPDATE T2 SET C1 = 'ABC' WHERE C1 ='XYZ';
137 INSERT INTO T3 VALUES (2,'23');
138 INSERT INTO T3 VALUES (3,'234');
139 DELETE FROM T3 WHERE C1 > 0;
140 -->endsql
141 EOF
142
143 --exec $MYSQLXTEST --ssl-cipher='ECDHE-RSA-AES128-GCM-SHA256' -u root --port=$MASTER_X_MYPORT_3 --file=$MYSQL_TMP_DIR/ddl_dml_on_server3.tmp 2>&1
144
145 # Wait for synchronization between the nodes.
146
147 --source include/rpl_sync.inc
148
149 # Asserts for values on each table.
150
151 --write_file $MYSQL_TMP_DIR/assert.tmp
152
153 -->echo Checking the Value on T1
154 -->wait_for 12345 SELECT C2 FROM test.T1 WHERE C1=1
155
156 -->echo Checking the row_count on T2
157 -->wait_for 23 SELECT C2 FROM test.T2 WHERE C1="ABC"
158 EOF
159
160 --exec $MYSQLXTEST --ssl-cipher='ECDHE-RSA-AES128-GCM-SHA256' -u root --port=$MASTER_X_MYPORT_3 --file=$MYSQL_TMP_DIR/assert.tmp 2>&1
161
162 --let $wait_condition=SELECT COUNT(*)=0 FROM test.T3
163 --source include/wait_condition.inc
164
165 # Temp for droping tables in a group.
166 --write_file $MYSQL_TMP_DIR/delete_tables.tmp
167 -->sql
168 USE test;
169 DROP TABLE T1;
170 DROP TABLE T2;
171 DROP TABLE T3;
172 -->endsql
173 EOF
174
175 # Deleting tables.
176 --exec $MYSQLXTEST --ssl-cipher='ECDHE-RSA-AES128-GCM-SHA256' -u root --port=$MASTER_X_MYPORT_3 --file=$MYSQL_TMP_DIR/delete_tables.tmp 2>&1
177 --source include/rpl_sync.inc
178
179 # Creating temp file to stop GR.
180 --write_file $MYSQL_TMP_DIR/stop_group_replication.tmp
181 -->stmtsql STOP GROUP_REPLICATION;
182 -->recvresult
183 EOF
184
185 # Stopping GR on all the servers
186 --echo Stopping GR on server 1
187 --exec $MYSQLXTEST --ssl-cipher='ECDHE-RSA-AES128-GCM-SHA256' -u root --port=$MASTER_X_MYPORT_1 --file=$MYSQL_TMP_DIR/stop_group_replication.tmp 2>&1
188 --echo Stopping GR on server 2
189 --exec $MYSQLXTEST --ssl-cipher='ECDHE-RSA-AES128-GCM-SHA256' -u root --port=$MASTER_X_MYPORT_2 --file=$MYSQL_TMP_DIR/stop_group_replication.tmp 2>&1
190 --echo Stopping GR on server 3
191 --exec $MYSQLXTEST --ssl-cipher='ECDHE-RSA-AES128-GCM-SHA256' -u root --port=$MASTER_X_MYPORT_3 --file=$MYSQL_TMP_DIR/stop_group_replication.tmp 2>&1
192
193 # Uninstall mysqlx on all servers
194 --let $rpl_connection_name= server1
195 --source include/rpl_connection.inc
196 --let $group_replication_member_state= OFFLINE
197 --source include/gr_wait_for_member_state.inc
198 --source include/assert_and_disable_read_only.inc
199
200 --let $rpl_connection_name= server2
201 --source include/rpl_connection.inc
202 --let $group_replication_member_state= OFFLINE
203 --source include/gr_wait_for_member_state.inc
204 --source include/assert_and_disable_read_only.inc
205
206 --let $rpl_connection_name= server3
207 --source include/rpl_connection.inc
208 --let $group_replication_member_state= OFFLINE
209 --source include/gr_wait_for_member_state.inc
210 --source include/assert_and_disable_read_only.inc
211
212 # clean-up
213 --remove_file $MYSQL_TMP_DIR/bootstrap_server.tmp
214 --remove_file $MYSQL_TMP_DIR/non_bootstrap_server.tmp
215 --remove_file $MYSQL_TMP_DIR/ddl_dml_on_server1.tmp
216 --remove_file $MYSQL_TMP_DIR/ddl_dml_on_server2.tmp
217 --remove_file $MYSQL_TMP_DIR/ddl_dml_on_server3.tmp
218 --remove_file $MYSQL_TMP_DIR/delete_tables.tmp
219 --remove_file $MYSQL_TMP_DIR/assert.tmp
220 --remove_file $MYSQL_TMP_DIR/stop_group_replication.tmp
221
222 --source include/group_replication_end.inc