Debian Codegraph @

mysql-test/suite/rpl_gtid/t/rpl_group_replication_channel_defaults_on_creation.test

raw
1 # ==== Purpose ====
2 #
3 # This test validates that when a group replication channel is created
4 # SOURCE_AUTO_POSITION, REQUIRE_ROW_FORMAT and GTID_ONLY are enabled by default
5 #
6 # ==== Requirements ====
7 #
8 # When group replication channel is created
9 # R1. The channel must have SOURCE_AUTO_POSITION = 1
10 # R2. The channel must have REQUIRE_ROW_FORMAT = 1
11 # R3. The channel must have GTID_ONLY = 1
12 # R4. The user can't change the value of SOURCE_AUTO_POSITION for the channel
13 # R5. The user can't change the value of REQUIRE_ROW_FORMAT for the channel
14 # R6. The user can't change the value of GTID_ONLY for the channel
15 #
16 # R7: Group replication channels can only be configured when GTID_MODE = ON
17 #
18 # ==== Implementation ====
19 #
20 # 1. Create a user so we can set a privileged user to create GR channels
21 # 2. Create a group replication applier channel
22 # Verify SOURCE_AUTO_POSITION, REQUIRE_ROW_FORMAT and GTID_ONLY are enabled
23 # 3. For the group replication applier channel
24 # Verify SOURCE_AUTO_POSITION, REQUIRE_ROW_FORMAT and GTID_ONLY can't be modified
25 # 4. Create a group replication recovery channel
26 # Verify SOURCE_AUTO_POSITION, REQUIRE_ROW_FORMAT and GTID_ONLY are enabled
27 # 5. For the group replication recovery channel
28 # Verify SOURCE_AUTO_POSITION, REQUIRE_ROW_FORMAT and GTID_ONLY can't be modified
29 # 6. Delete the channels
30 # Verify they cannot be created when GTID_MODE != ON
31 # 7. Cleanup
32 #
33 # ==== References ====
34 #
35 # WL#7491: GTID-based replication applier recovery and positioning
36 # WL#12968: Configure replication applier to require row-based replication
37 #
38
39 --source include/have_binlog_format_row.inc
40 --source include/have_slave_repository_type_table.inc
41
42 --echo #
43 --echo # 1. Create a user so we can set a privileged user to create GR channels
44
45 CREATE USER 'u1'@'localhost';
46
47 --echo #
48 --echo # 2. Create a group replication applier channel
49 --echo # Verify SOURCE_AUTO_POSITION, REQUIRE_ROW_FORMAT and GTID_ONLY are enabled
50
51 CHANGE REPLICATION SOURCE TO PRIVILEGE_CHECKS_USER = 'u1'@'localhost' FOR CHANNEL "group_replication_applier";
52
53 --let $count = `SELECT COUNT(*) FROM mysql.slave_master_info WHERE Enabled_auto_position = 1 AND Channel_name = "group_replication_applier"`
54 --let $assert_text = Auto_position is set to 1 for GR applier channel
55 --let $assert_cond = 1 = $count
56 --source include/assert.inc
57
58 --let $count = `SELECT COUNT(*) FROM mysql.slave_relay_log_info WHERE Require_row_format = 1 AND Channel_name = "group_replication_applier"`
59 --let $assert_text = Require_row_format is set to 1 for GR applier channel
60 --let $assert_cond = 1 = $count
61 --source include/assert.inc
62
63 --let $count = `SELECT COUNT(*) FROM mysql.slave_master_info WHERE Gtid_only = 1 AND Channel_name = "group_replication_applier"`
64 --let $assert_text = Gtid_only is set to 1 for GR applier channel
65 --let $assert_cond = 1 = $count
66 --source include/assert.inc
67
68 --echo #
69 --echo # 3. For the group replication applier channel
70 --echo # Verify SOURCE_AUTO_POSITION, REQUIRE_ROW_FORMAT and GTID_ONLY can't be modified
71
72 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
73 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0 FOR CHANNEL "group_replication_applier";
74 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
75 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1 FOR CHANNEL "group_replication_applier";
76
77 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
78 CHANGE REPLICATION SOURCE TO REQUIRE_ROW_FORMAT = 0 FOR CHANNEL "group_replication_applier";
79 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
80 CHANGE REPLICATION SOURCE TO REQUIRE_ROW_FORMAT = 1 FOR CHANNEL "group_replication_applier";
81
82 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
83 CHANGE REPLICATION SOURCE TO GTID_ONLY = 0 FOR CHANNEL "group_replication_applier";
84 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
85 CHANGE REPLICATION SOURCE TO GTID_ONLY = 1 FOR CHANNEL "group_replication_applier";
86
87 --let $count = `SELECT COUNT(*) FROM mysql.slave_master_info WHERE Enabled_auto_position = 1 AND Channel_name = "group_replication_applier"`
88 --let $assert_text = Auto_position is set to 1 for GR applier channel
89 --let $assert_cond = 1 = $count
90 --source include/assert.inc
91
92 --let $count = `SELECT COUNT(*) FROM mysql.slave_relay_log_info WHERE Require_row_format = 1 AND Channel_name = "group_replication_applier"`
93 --let $assert_text = Require_row_format is set to 1 for GR applier channel
94 --let $assert_cond = 1 = $count
95 --source include/assert.inc
96
97 --let $count = `SELECT COUNT(*) FROM mysql.slave_master_info WHERE Gtid_only = 1 AND Channel_name = "group_replication_applier"`
98 --let $assert_text = Gtid_only is set to 1 for GR applier channel
99 --let $assert_cond = 1 = $count
100 --source include/assert.inc
101
102 --echo #
103 --echo # 4. Create a group replication recovery channel
104 --echo # Verify SOURCE_AUTO_POSITION, REQUIRE_ROW_FORMAT and GTID_ONLY are enabled
105
106 CHANGE REPLICATION SOURCE TO PRIVILEGE_CHECKS_USER = 'u1'@'localhost' FOR CHANNEL "group_replication_recovery";
107
108 --let $count = `SELECT COUNT(*) FROM mysql.slave_master_info WHERE Enabled_auto_position = 1 AND Channel_name = "group_replication_recovery"`
109 --let $assert_text = Auto_position is set to 1 for GR recovery channel
110 --let $assert_cond = 1 = $count
111 --source include/assert.inc
112
113 --let $count = `SELECT COUNT(*) FROM mysql.slave_relay_log_info WHERE Require_row_format = 1 AND Channel_name = "group_replication_recovery"`
114 --let $assert_text = Require_row_format is set to 1 for GR recovery channel
115 --let $assert_cond = 1 = $count
116 --source include/assert.inc
117
118 --let $count = `SELECT COUNT(*) FROM mysql.slave_master_info WHERE Gtid_only = 1 AND Channel_name = "group_replication_recovery"`
119 --let $assert_text = Gtid_only is set to 1 for GR recovery channel
120 --let $assert_cond = 1 = $count
121 --source include/assert.inc
122
123 --echo #
124 --echo # 5. For the group replication recovery channel
125 --echo # Verify SOURCE_AUTO_POSITION, REQUIRE_ROW_FORMAT and GTID_ONLY can't be modified
126
127 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
128 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 0 FOR CHANNEL "group_replication_recovery";
129 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
130 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION = 1 FOR CHANNEL "group_replication_recovery";
131
132 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
133 CHANGE REPLICATION SOURCE TO REQUIRE_ROW_FORMAT = 0 FOR CHANNEL "group_replication_recovery";
134 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
135 CHANGE REPLICATION SOURCE TO REQUIRE_ROW_FORMAT = 1 FOR CHANNEL "group_replication_recovery";
136
137 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
138 CHANGE REPLICATION SOURCE TO GTID_ONLY = 0 FOR CHANNEL "group_replication_recovery";
139 --error ER_REPLICA_CHANNEL_OPERATION_NOT_ALLOWED
140 CHANGE REPLICATION SOURCE TO GTID_ONLY = 1 FOR CHANNEL "group_replication_recovery";
141
142 --let $count = `SELECT COUNT(*) FROM mysql.slave_master_info WHERE Enabled_auto_position = 1 AND Channel_name = "group_replication_recovery"`
143 --let $assert_text = Auto_position is set to 1 for GR recovery channel
144 --let $assert_cond = 1 = $count
145 --source include/assert.inc
146
147 --let $count = `SELECT COUNT(*) FROM mysql.slave_relay_log_info WHERE Require_row_format = 1 AND Channel_name = "group_replication_recovery"`
148 --let $assert_text = Require_row_format is set to 1 for GR recovery channel
149 --let $assert_cond = 1 = $count
150 --source include/assert.inc
151
152 --let $count = `SELECT COUNT(*) FROM mysql.slave_master_info WHERE Gtid_only = 1 AND Channel_name = "group_replication_recovery"`
153 --let $assert_text = Gtid_only is set to 1 for GR recovery channel
154 --let $assert_cond = 1 = $count
155 --source include/assert.inc
156
157
158 --echo #
159 --echo # 6. Delete the channels
160 --echo # Verify they cannot be created when GTID_MODE != ON
161
162 RESET REPLICA ALL;
163
164 SET GLOBAL GTID_MODE = ON_PERMISSIVE;
165
166 --error ER_CHANGE_REP_SOURCE_GR_CHANNEL_WITH_GTID_MODE_NOT_ON
167 CHANGE REPLICATION SOURCE TO PRIVILEGE_CHECKS_USER = 'u1'@'localhost' FOR CHANNEL "group_replication_applier";
168
169 --error ER_CHANGE_REP_SOURCE_GR_CHANNEL_WITH_GTID_MODE_NOT_ON
170 CHANGE REPLICATION SOURCE TO PRIVILEGE_CHECKS_USER = 'u1'@'localhost' FOR CHANNEL "group_replication_recovery";
171
172 --echo #
173 --echo # 7. Cleanup
174
175 SET GLOBAL GTID_MODE = ON;
176
177 DROP USER 'u1'@'localhost';