Debian Codegraph @

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

raw
1 ############################################################
2 # WL#9426: Single Primary Mode in Group Replication
3 #
4 # This test case starts a group and validates that:
5 # 1. There is only one writable primary;
6 # 2. If we write to the primary, the secondaries will replicate
7 # 3. If we write to the secondaries, we will get errors.
8 # 4. Group is shutdown.
9 #
10 ############################################################
11 --source include/big_test.inc
12 --source include/have_group_replication_plugin.inc
13
14 --let $rpl_skip_group_replication_start= 1
15 --let $rpl_server_count= 4
16 --let $rpl_group_replication_single_primary_mode=1
17 --source include/group_replication.inc
18
19 --let $ceiling= `SELECT $rpl_server_count+1`
20
21 --echo ########################################################
22 --echo # 1. Start a single server
23 --echo #######################################################
24
25 --echo
26 --echo ## START SERVER 1
27 --let $rpl_connection_name= server1
28 --let $server1_uuid= `SELECT @@server_uuid`
29 --source include/rpl_connection.inc
30
31 --source include/start_and_bootstrap_group_replication.inc
32
33 --let $group_replication_expected_uuid= $server1_uuid
34 --source include/gr_wait_primary_member_uuid.inc
35
36 --echo
37 --echo ## START SERVERS 2-4
38 --let $server_num= 2
39
40 while($server_num<$ceiling)
41 {
42 --let $rpl_connection_name= server$server_num
43 --source include/rpl_connection.inc
44 --source include/start_group_replication.inc
45
46 --let $group_replication_expected_uuid= $server1_uuid
47 --source include/gr_wait_primary_member_uuid.inc
48
49 --inc $server_num
50 }
51
52 --echo
53 --echo ## TRY TO CREATE TABLES test1 TO test4 ON CORESPONDING SERVERS 1-4
54 --let $server_num= 1
55
56 # First is the primary node
57 # we do not expect any errors there !
58 --let $expect_error= 0
59 while($server_num<$ceiling)
60 {
61 --let $rpl_connection_name= server$server_num
62 --source include/rpl_connection.inc
63
64 --error $expect_error
65 --eval CREATE TABLE test$server_num(`id` INT PRIMARY KEY AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL);
66
67 --error $expect_error
68 --eval INSERT INTO test$server_num(`name`) VALUES("First ROW"), ("Second ROW"), ("Third ROW");
69
70 --error $expect_error
71 --eval INSERT INTO test$server_num(`name`) VALUES("First ROW created in second query"), ("Second ROW created in second query");
72
73 --error $expect_error
74 --eval UPDATE test$server_num SET `name`="2 ROW" WHERE `name` LIKE '%Second%';
75
76 --source include/rpl_sync.inc
77 --let $expect_error=ER_OPTION_PREVENTS_STATEMENT
78
79 --inc $server_num
80 }
81
82 --echo
83 --echo ## STOP SERVER 1 AND START IT AGAIN (MAKE IT TO SECONDARY NODE)
84 --let $rpl_connection_name= server1
85 --source include/rpl_connection.inc
86 --source include/stop_group_replication.inc
87 --source include/start_group_replication.inc
88
89 --echo
90 --echo ## FIND NEW PRIMARY SERVER AND INSERT DATA ON PRIMARY
91 --let $rpl_connection_silent=1
92 --source include/gr_find_a_primary.inc
93 if (!$group_replication_found_primary_out_var)
94 {
95 --echo performance_schema.replication_group_members
96 --echo --------------------------------------------
97 --query_vertical SELECT * FROM performance_schema.replication_group_members
98 --die "Unable to find PRIMARY!!"
99 }
100 --let $rpl_primary_server_name= $group_replication_primary_connection_out_var
101
102 --let $rpl_connection_name= $rpl_primary_server_name
103 --source include/rpl_connection.inc
104
105 INSERT INTO test1(`name`) VALUES("First ROW created in third query"), ("Second ROW created in third query");
106 INSERT INTO test1(`name`) VALUES("First ROW created in fourth query"), ("Second ROW created in fourth query");
107 UPDATE test1 SET `name`="3 query" WHERE `name` LIKE '%third query%';
108 UPDATE test1 SET `name`="Second ROW" WHERE `name` LIKE '%2 ROW%';
109
110 --source include/rpl_sync.inc
111
112 --echo
113 --echo ## CHECK SECONDARY SERVERS THAT ARE SET IN READ ONLY MODE
114 --let $server_num= 1
115 while($server_num<5)
116 {
117 --let $current_server= server$server_num
118
119 if ($current_server != $rpl_primary_server_name)
120 {
121 --connection $current_server
122 --error ER_OPTION_PREVENTS_STATEMENT
123 TRUNCATE TABLE `test1`;
124 }
125
126 --inc $server_num
127 }
128
129 --echo
130 --echo ## CHECK IF TABLE test1 IS IT PRESENT ON ALL SERVERS
131 --echo [connection new primary]
132 --let $rpl_connection_name= $rpl_primary_server_name
133 --source include/rpl_connection.inc
134 SELECT * FROM test1;
135
136 --let $server_num= 2
137 while($server_num<$ceiling)
138 {
139 --let $diff_tables= server1:test1, server$server_num:test1
140 --source include/diff_tables.inc
141 --inc $server_num
142 }
143
144
145 --echo
146 --echo ## CHECK TABLE test2-4, THEY SHOULDN'T BE THERE
147 --let $server_num= 1
148 while($server_num<$ceiling)
149 {
150 --let $rpl_connection_name= server$server_num
151 --source include/rpl_connection.inc
152
153 --let $assert_text= 'Number of tables in current schema should be equal 1, it should be only "test1" table'
154 --let $assert_cond= [SELECT COUNT(*) as count FROM information_schema.tables WHERE table_schema = schema(), count, 1] = 1
155 --source include/assert.inc
156 --inc $server_num
157 }
158
159 --echo
160 --echo ## CLEANUP
161 --let $rpl_connection_name= $rpl_primary_server_name
162 --source include/rpl_connection.inc
163 DROP TABLE `test1`;
164 --source include/rpl_sync.inc
165
166 --let $rpl_connection_silent=0
167
168 --source include/group_replication_end.inc