Debian Codegraph @

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

raw
1 ################################################################################
2 # wl#5655 : Test the doublewrite functionality in group rpl scenario
3 # Set the following parameters on each server differently during server start.
4 # innodb_doublewrite
5 # innodb_doublewrite_files
6 # innodb_doublewrite_pages
7 # innodb_doublewrite_batch_size
8 # Test DDL and DML operations with REDO_LOG ENABLE and DISABLE
9 # Test Error and DDL and DML scenarios on all 3 servers
10 # Check the number of servers online and status of servers
11 # Cleanup
12 ################################################################################
13 --source include/have_innodb_16k.inc
14 --source include/not_valgrind.inc
15 --source include/have_group_replication_plugin.inc
16
17 --let $rpl_skip_group_replication_start= 1
18 --let $rpl_server_count= 3
19 --source include/group_replication.inc
20
21 # Start group replication on two servers
22
23 --echo
24 --let $rpl_connection_name= server1
25 --source include/rpl_connection.inc
26 --source include/start_and_bootstrap_group_replication.inc
27
28 --echo
29 --let $rpl_connection_name= server2
30 --source include/rpl_connection.inc
31 --source include/start_group_replication.inc
32
33 # Make sure number of servers in the group is 2
34 --let $group_replication_number_of_members= 2
35 --source include/gr_wait_for_number_of_members.inc
36
37 # Make 3rd member ready for starting GR
38 --echo
39 --let $rpl_connection_name= server3
40 --source include/rpl_connection.inc
41 --replace_result $group_replication_group_name GROUP_REPLICATION_DOUBELWRITE
42 --eval SET GLOBAL group_replication_group_name= "$group_replication_group_name"
43
44 # Connect to server1
45 --let $rpl_connection_name= server1
46 --source include/rpl_connection.inc
47
48 # Disable redo_log on server1
49 ALTER INSTANCE DISABLE INNODB REDO_LOG;
50
51 SET sql_log_bin = 0;
52 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* InnoDB redo logging is disabled. All data could be lost in case of a server crash");
53 SET sql_log_bin = 1;
54
55 # Check status of redo_log on server1
56 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
57
58 CREATE TABLE test.tab ( c1 int primary key, c2 TEXT);
59 INSERT INTO test.tab VALUES(1, 'Test wl#5655');
60
61 SELECT @@innodb_doublewrite_dir;
62
63 SELECT @@innodb_doublewrite_files;
64
65 SELECT @@innodb_doublewrite_pages;
66
67 SELECT @@innodb_doublewrite_batch_size;
68
69 --source include/rpl_sync.inc
70
71 # Add 3rd member parallely while the insertion is in progress
72 --echo
73 --let $rpl_connection_name= server3
74 --source include/rpl_connection.inc
75 --source include/start_group_replication_command.inc
76
77 # Make sure that all the servers in the group are ONLINE
78 --echo
79 --let $rpl_connection_name= server2
80 --source include/rpl_connection.inc
81
82 --let $wait_timeout= 600
83 let $wait_condition=SELECT COUNT(*)=3 FROM performance_schema.replication_group_members where MEMBER_STATE="ONLINE";
84 --source include/wait_condition.inc
85
86 # Disable redo_log on server2
87 ALTER INSTANCE DISABLE INNODB REDO_LOG;
88
89 SET sql_log_bin = 0;
90 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* InnoDB redo logging is disabled. All data could be lost in case of a server crash");
91 SET sql_log_bin = 1;
92
93 # Check status of redo_log on server2
94 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
95
96 SELECT @@innodb_doublewrite_dir;
97
98 SELECT @@innodb_doublewrite_files;
99
100 SELECT @@innodb_doublewrite_pages;
101
102 SELECT @@innodb_doublewrite_batch_size;
103
104 --echo
105 --echo #Validating the records in server3#
106 --let $rpl_connection_name= server3
107 --source include/rpl_connection.inc
108
109 # Check Enable redo_log on server3
110 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
111
112 SELECT * FROM test.tab;
113
114 SELECT @@innodb_doublewrite_dir;
115
116 SELECT @@innodb_doublewrite_files;
117
118 SELECT @@innodb_doublewrite_pages;
119
120 SELECT @@innodb_doublewrite_batch_size;
121
122 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
123 SET GLOBAL innodb_doublewrite_dir=$MYSQL_TMP_DIR/"#DBWL-DIR";
124
125 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
126 SET GLOBAL innodb_doublewrite_files=1;
127
128 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
129 SET GLOBAL innodb_doublewrite_pages=10;
130
131 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
132 SET GLOBAL innodb_doublewrite_batch_size=1;
133
134 --source include/rpl_sync.inc
135
136 # Verify the consistency of number of records on all the servers
137 --echo
138 --echo #Validating the records in server2
139 --let $rpl_connection_name= server2
140 --source include/rpl_connection.inc
141
142 # Enable redo_log on server2
143 ALTER INSTANCE ENABLE INNODB REDO_LOG;
144
145 SET sql_log_bin = 0;
146 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* InnoDB redo logging is enabled. Data is now safe and can be recovered in case of a server crash.");
147 SET sql_log_bin = 1;
148
149 # Check status of redo_log on server2
150 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
151
152 SELECT * FROM test.tab;
153
154 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
155 SET GLOBAL innodb_doublewrite_dir=$MYSQL_TMP_DIR/"#DBWL-DIR";
156
157 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
158 SET GLOBAL innodb_doublewrite_files=1;
159
160 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
161 SET GLOBAL innodb_doublewrite_pages=10;
162
163 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
164 SET GLOBAL innodb_doublewrite_batch_size=1;
165
166 # Connect to server1
167 --let $rpl_connection_name= server1
168 --source include/rpl_connection.inc
169
170 # Enable redo_log on server1
171 ALTER INSTANCE ENABLE INNODB REDO_LOG;
172
173 SET sql_log_bin = 0;
174 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* InnoDB redo logging is enabled. Data is now safe and can be recovered in case of a server crash.");
175 SET sql_log_bin = 1;
176
177 # Check status of redo_log on server1
178 SHOW GLOBAL STATUS LIKE 'innodb_redo_log_enabled';
179
180 # Cleanup
181 --echo
182 DROP TABLE test.tab;
183
184 --source include/rpl_sync.inc
185
186 STOP GROUP_REPLICATION;
187
188 --source include/group_replication_end.inc