Debian Codegraph @

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

raw
1 ##########################################################################################################
2 # Add a member to GR group and parallely insert data onto the donor
3 #
4 # 0. Start 3 servers, and add 2 among them to GR
5 # 1. Add 3rd member to GR group
6 # 2. Insert data into the donor member
7 # 3. Validate the record counts on different tables
8 # 4. Check the number of servers online and status of servers
9 # 5. Cleanup
10 ################################################################################
11
12 --source include/big_test.inc
13 --source include/have_group_replication_plugin.inc
14 --let $rpl_skip_group_replication_start= 1
15 --let $rpl_server_count= 3
16 --source include/group_replication.inc
17
18 # Start group replication on two servers
19 --echo
20 --let $rpl_connection_name= server1
21 --source include/rpl_connection.inc
22 SET sql_log_bin=0;
23 CREATE TABLE test.t1 (a int primary key);
24 SET sql_log_bin=1;
25 --source include/start_and_bootstrap_group_replication.inc
26
27 --echo
28 --let $rpl_connection_name= server2
29 --source include/rpl_connection.inc
30 SET sql_log_bin=0;
31 CREATE TABLE test.t1 (a int primary key);
32 SET sql_log_bin=1;
33 --source include/start_group_replication.inc
34 # Extract the server_uuid
35 --let $server2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
36
37 # Connect to server1 and add some data
38 --echo
39 --let $rpl_connection_name= server1
40 --source include/rpl_connection.inc
41 --disable_query_log
42 --let $i=100
43 while($i)
44 {
45 --EVAL INSERT INTO t1 VALUES ($i)
46 --dec $i
47 }
48 --enable_query_log
49
50 # Start GR on server3
51 --echo
52 --let $rpl_connection_name= server3
53 --source include/rpl_connection.inc
54 SET sql_log_bin=0;
55 CREATE TABLE test.t1 (a int primary key);
56 SET sql_log_bin=1;
57 LOCK TABLES t1 READ;
58
59 connect(server3_2,localhost,root,,test,$SERVER_MYPORT_3,$SERVER_MYSOCK_3);
60 --connection server3_2
61 --replace_result $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
62 --eval SET GLOBAL group_replication_group_name= "$group_replication_group_name"
63 --source include/start_group_replication_command.inc
64
65 # Find the donor member
66 --let $wait_timeout= 100
67 let $wait_condition=SELECT COUNT(*)=1 FROM performance_schema.replication_connection_status WHERE channel_name='group_replication_recovery' AND service_state='ON';
68 --source include/wait_condition.inc
69
70 --let $donor_id= 1
71 if (`SELECT COUNT(*)=1 FROM performance_schema.replication_connection_status WHERE channel_name='group_replication_recovery' AND service_state='ON' AND source_uuid='$server2_uuid'`)
72 {
73 --let $donor_id= 2
74 }
75 --disconnect server3_2
76
77 --echo
78 --let $rpl_connection_name= server3
79 --source include/rpl_connection.inc
80 UNLOCK TABLES;
81
82 --echo
83 --echo Add data onto the donor member
84 --connection server$donor_id
85 --disable_query_log
86 --let $i=100
87 --let $j=200
88 while($i)
89 {
90 --EVAL INSERT INTO t1 VALUES ($j)
91 --dec $i
92 --dec $j
93 }
94 --enable_query_log
95
96 # Make sure the servers are part of the group
97 --let $wait_timeout= 300
98 let $wait_condition=SELECT COUNT(*)=3 FROM performance_schema.replication_group_members where MEMBER_STATE="ONLINE";
99 --source include/wait_condition.inc
100
101 --echo
102 --echo #Validating the records in server3#
103 --let $rpl_connection_name= server3
104 --source include/rpl_connection.inc
105 --let $wait_timeout= 300
106 --let $wait_condition= SELECT COUNT(*)=200 FROM test.t1;
107 --source include/wait_condition.inc
108 --source include/rpl_sync.inc
109
110 # Drop the tables created
111 --echo
112 --let $group_replication_member_state= ONLINE
113 --source include/gr_wait_for_member_state.inc
114 DROP TABLE test.t1;
115
116 --source include/group_replication_end.inc