Debian Codegraph @

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

raw
1 ################################################################################
2 # Validate that recovery channel compression configuration is properly
3 # exported by performance schema.
4 #
5 # Test:
6 # 0. The test requires two servers: M1 and M2.
7 # 1. Create a table on the group.
8 # 2. Test invalid algorithm and level values.
9 # 3. Test invalid algorithm and level combinations.
10 # 4. Test valid algorithm and level combinations.
11 # 5. Clean up.
12 ################################################################################
13 --source include/big_test.inc
14 --source include/have_group_replication_plugin.inc
15 --source include/group_replication.inc
16
17 --echo
18 --echo ############################################################
19 --echo # 1. Create a table on the group.
20 --let $rpl_connection_name= server2
21 --source include/rpl_connection.inc
22 --disable_query_log
23 --let $saved_gr_recovery_compression_algorithm = `SELECT @@GLOBAL.group_replication_recovery_compression_algorithms;`
24 --let $saved_gr_recovery_compression_level = `SELECT @@GLOBAL.group_replication_recovery_zstd_compression_level;`
25 --enable_query_log
26
27 SET SESSION sql_log_bin= 0;
28 call mtr.add_suppression("Invalid compression level found while reading connection metadata repository. Resetting level to default.");
29 call mtr.add_suppression("Plugin group_replication reported: 'Error while creating the group replication recovery channel with donor .*");
30 call mtr.add_suppression("Plugin group_replication reported: 'Error when configuring the asynchronous recovery channel connection to the donor.");
31 call mtr.add_suppression("Plugin group_replication reported: 'Maximum number of retries when trying to connect to a donor reached. Aborting group replication incremental recovery.");
32 call mtr.add_suppression("Plugin group_replication reported: 'Fatal error during the incremental recovery process of Group Replication. The server will leave the group.");
33 call mtr.add_suppression("Plugin group_replication reported: 'Skipping leave operation: concurrent attempt to leave the group is on-going.");
34 SET SESSION sql_log_bin= 1;
35
36 CREATE TABLE t1 (c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
37 --source include/rpl_sync.inc
38
39
40 --echo
41 --echo ############################################################
42 --echo # 2. Test invalid algorithm and level values.
43 --let $rpl_connection_name= server2
44 --source include/rpl_connection.inc
45
46 --error ER_WRONG_TYPE_FOR_VAR
47 SET @@GLOBAL.group_replication_recovery_compression_algorithms= 1;
48
49 --error ER_WRONG_TYPE_FOR_VAR
50 SET @@GLOBAL.group_replication_recovery_compression_algorithms= 1.0;
51
52 --error ER_WRONG_VALUE_FOR_VAR
53 SET @@GLOBAL.group_replication_recovery_compression_algorithms= "foo";
54
55 --error ER_WRONG_VALUE_FOR_VAR
56 SET @@GLOBAL.group_replication_recovery_compression_algorithms= "ZLIB";
57
58 --error ER_WRONG_VALUE_FOR_VAR
59 SET @@GLOBAL.group_replication_recovery_compression_algorithms= "ZSTD";
60
61 --error ER_WRONG_TYPE_FOR_VAR
62 SET @@GLOBAL.group_replication_recovery_zstd_compression_level= "bar";
63
64 --error ER_WRONG_TYPE_FOR_VAR
65 SET @@GLOBAL.group_replication_recovery_zstd_compression_level= 1.0;
66
67
68 --echo
69 --echo ############################################################
70 --echo # 3. Test invalid algorithm and level combinations.
71 --let $rpl_connection_name= server2
72 --source include/rpl_connection.inc
73
74 SET @@GLOBAL.group_replication_recovery_compression_algorithms= "zlib";
75 --error ER_WRONG_VALUE_FOR_VAR
76 SET @@GLOBAL.group_replication_recovery_zstd_compression_level= 0;
77 --error ER_WRONG_VALUE_FOR_VAR
78 SET @@GLOBAL.group_replication_recovery_zstd_compression_level= 23;
79
80 SET @@GLOBAL.group_replication_recovery_compression_algorithms= "zstd";
81 --error ER_WRONG_VALUE_FOR_VAR
82 SET @@GLOBAL.group_replication_recovery_zstd_compression_level= 0;
83 --error ER_WRONG_VALUE_FOR_VAR
84 SET @@GLOBAL.group_replication_recovery_zstd_compression_level= 23;
85
86 SET @@GLOBAL.group_replication_recovery_compression_algorithms= "uncompressed";
87 --error ER_WRONG_VALUE_FOR_VAR
88 SET @@GLOBAL.group_replication_recovery_zstd_compression_level= 0;
89 --error ER_WRONG_VALUE_FOR_VAR
90 SET @@GLOBAL.group_replication_recovery_zstd_compression_level= 23;
91
92 --echo
93 --echo ############################################################
94 --echo # 4. Test valid algorithm and level combinations.
95 --let $rpl_connection_name= server2
96 --source include/rpl_connection.inc
97
98 SET @@GLOBAL.group_replication_recovery_compression_algorithms= DEFAULT;
99 SET @@GLOBAL.group_replication_recovery_zstd_compression_level= DEFAULT;
100
101 SET @@GLOBAL.group_replication_recovery_compression_algorithms= "zlib";
102 --source ../include/gr_recovery_channel_block.inc
103 --let $assert_text= 'Algorithm must be zlib'
104 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME="group_replication_recovery" AND COMPRESSION_ALGORITHM="zlib", count, 1] = 1
105 --source include/assert.inc
106 --source ../include/gr_recovery_channel_resume.inc
107
108 SET @@GLOBAL.group_replication_recovery_compression_algorithms= DEFAULT;
109 SET @@GLOBAL.group_replication_recovery_zstd_compression_level= DEFAULT;
110
111 SET @@GLOBAL.group_replication_recovery_compression_algorithms= "zstd";
112 --source ../include/gr_recovery_channel_block.inc
113 --let $assert_text= 'Algorithm must be zstd and level must be 3 (the default)'
114 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME="group_replication_recovery" AND COMPRESSION_ALGORITHM="zstd" AND ZSTD_COMPRESSION_LEVEL=3, count, 1] = 1
115 --source include/assert.inc
116 --source ../include/gr_recovery_channel_resume.inc
117
118 SET @@GLOBAL.group_replication_recovery_compression_algorithms= "zstd";
119 SET @@GLOBAL.group_replication_recovery_zstd_compression_level= 1;
120 --source ../include/gr_recovery_channel_block.inc
121 --let $assert_text= 'Algorithm must be zstd and level must be 1'
122 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME="group_replication_recovery" AND COMPRESSION_ALGORITHM="zstd" AND ZSTD_COMPRESSION_LEVEL=1, count, 1] = 1
123 --source include/assert.inc
124 --source ../include/gr_recovery_channel_resume.inc
125
126 SET @@GLOBAL.group_replication_recovery_compression_algorithms= "zstd";
127 SET @@GLOBAL.group_replication_recovery_zstd_compression_level= 22;
128 --source ../include/gr_recovery_channel_block.inc
129 --let $assert_text= 'Algorithm must be zstd and level must be 22'
130 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME="group_replication_recovery" AND COMPRESSION_ALGORITHM="zstd" AND ZSTD_COMPRESSION_LEVEL=22, count, 1] = 1
131 --source include/assert.inc
132 --source ../include/gr_recovery_channel_resume.inc
133
134
135 --echo
136 --echo ############################################################
137 --echo # 6. Clean up.
138 --let $rpl_connection_name= server2
139 --source include/rpl_connection.inc
140 DROP TABLE t1;
141
142 --disable_query_log
143 --eval SET @@GLOBAL.group_replication_recovery_compression_algorithms= "$saved_gr_recovery_compression_algorithm"
144 --eval SET @@GLOBAL.group_replication_recovery_zstd_compression_level= $saved_gr_recovery_compression_level
145 --enable_query_log
146
147 --source include/group_replication_end.inc