Debian Codegraph @

mysql-test/suite/group_replication/r/gr_fragmentation_options.result

raw
1 include/group_replication.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6 #########################################################################
7 # 1. When GROUP is OFFLINE, set variable group_replication_communication_max_message_size to 0, i.e. disabled.
8 [connection server2]
9 SET GLOBAL group_replication_communication_max_message_size= 0;
10 SET GLOBAL group_replication_compression_threshold= 0;
11 [connection server1]
12 SET GLOBAL group_replication_communication_max_message_size= 0;
13 SET GLOBAL group_replication_compression_threshold= 0;
14 #########################################################################
15 # 2. Check it asserts that:
16 [connection server1]
17 # 2.a. The variable does not take invalid inputs.
18 SET GLOBAL group_replication_communication_max_message_size="AAAA";
19 ERROR 42000: Incorrect argument type to variable 'group_replication_communication_max_message_size'
20 # 2.b. The variable does not take over the max inputs.
21 SET GLOBAL group_replication_communication_max_message_size=4294967297;
22 ERROR 42000: The value 4294967297 is not within the range of accepted values for the group_replication_communication_max_message_size option. Use 0 to disable message fragmentation, or specify a value up to 1073741824.
23 # 2.c. The variable does not take negative inputs.
24 SET GLOBAL group_replication_communication_max_message_size=-1;
25 ERROR 42000: The value -1 is not within the range of accepted values for the group_replication_communication_max_message_size option. Use 0 to disable message fragmentation, or specify a value up to 1073741824.
26 # 2.d. The variable can be set to DEFAULT.
27 SET GLOBAL group_replication_communication_max_message_size=DEFAULT;
28 include/assert.inc [Assert that communication_max_message_size was changed to the default value]
29 # 2.e. The variable can be set to a valid value.
30 SET GLOBAL group_replication_communication_max_message_size=50000;
31 include/assert.inc [Assert that communication_max_message_size was changed]
32 #########################################################################
33 # 3. Bootstrap M1 and start M2 to make them ONLINE.
34 include/start_and_bootstrap_group_replication.inc
35 [connection server2]
36 include/start_group_replication.inc
37 [connection server1]
38 #########################################################################
39 # 4. Assert that on running member variable cannot be changed.
40 SET GLOBAL group_replication_communication_max_message_size=100000;
41 ERROR HY000: The group_replication_communication_max_message_size option cannot be set while Group Replication is running
42 include/assert.inc [Assert that the communication_max_message_size remains unchanged]
43 #########################################################################
44 # 5. Check if two servers with and without fragmentation enabled are able to exchange messages and still comunicate with each other.
45 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 LONGBLOB) ENGINE=InnoDB;
46 INSERT INTO t1 VALUES(1, REPEAT('A', 100000));
47 INSERT INTO t1 VALUES(2, 'B');
48 [connection server2]
49 include/rpl_sync.inc
50 include/assert.inc [Assert that the communication_max_message_size is disabled]
51 INSERT INTO t1 VALUES(3, REPEAT('C', 100000));
52 include/rpl_sync.inc
53 include/diff_tables.inc [server1:test.t1,server2:test.t1]
54 #########################################################################
55 # 6, Confirm, in the error log, the servers start with the expected fragmentation threshold.
56 include/assert_grep.inc [Fragmentation was active and logged to the error log]
57 include/assert_grep.inc [Fragmentation was disabled and logged to the error log]
58 include/assert_grep.inc [Fragmentation was always disabled]
59 #########################################################################
60 # Clean up
61 DROP TABLE t1;
62 include/rpl_sync.inc
63 [connection server1]
64 include/stop_group_replication.inc
65 SET GLOBAL group_replication_communication_max_message_size= SAVED_VALUE;
66 SET GLOBAL group_replication_compression_threshold= SAVED_VALUE;
67 include/start_group_replication.inc
68 [connection server2]
69 include/stop_group_replication.inc
70 SET GLOBAL group_replication_communication_max_message_size= SAVED_VALUE;
71 SET GLOBAL group_replication_compression_threshold= SAVED_VALUE;
72 include/start_group_replication.inc
73 include/group_replication_end.inc