| 1 |
include/master-slave.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 master] |
| 6 |
SET @@session.sql_log_bin = OFF; |
| 7 |
CREATE TABLE t(c INT, d INT); |
| 8 |
SET @@session.sql_log_bin = ON; |
| 9 |
[connection slave] |
| 10 |
CALL mtr.add_suppression(".*command denied to user."); |
| 11 |
CALL mtr.add_suppression(".*the option binlog_row_value_options.*"); |
| 12 |
CALL mtr.add_suppression(".*The replica coordinator and worker threads are stopped.*"); |
| 13 |
CALL mtr.add_suppression(".*Replica worker thread has failed to apply an event. As a consequence, the coordinator*"); |
| 14 |
CREATE TABLE t(c INT, d INT); |
| 15 |
# |
| 16 |
# Running test for |
| 17 |
# GRANT INSERT ON *.* TO ... |
| 18 |
# |
| 19 |
[connection master] |
| 20 |
INSERT INTO t VALUES(10, 10); |
| 21 |
include/save_master_pos.inc |
| 22 |
[connection slave] |
| 23 |
START SLAVE; |
| 24 |
Warnings: |
| 25 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 26 |
include/wait_for_slave_sql_error.inc [errno=1142] |
| 27 |
STOP SLAVE; |
| 28 |
Warnings: |
| 29 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 30 |
GRANT INSERT ON *.* TO 'a_bigger_username_just_for_test'; |
| 31 |
START SLAVE; |
| 32 |
Warnings: |
| 33 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 34 |
include/sync_slave_sql.inc |
| 35 |
REVOKE INSERT ON *.* FROM 'a_bigger_username_just_for_test'; |
| 36 |
STOP SLAVE; |
| 37 |
Warnings: |
| 38 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 39 |
include/diff_tables.inc [master:t, slave:t] |
| 40 |
# |
| 41 |
# Running test for |
| 42 |
# GRANT UPDATE ON *.* TO ... |
| 43 |
# |
| 44 |
[connection master] |
| 45 |
UPDATE t SET c = 12 WHERE c = 10; |
| 46 |
include/save_master_pos.inc |
| 47 |
[connection slave] |
| 48 |
START SLAVE; |
| 49 |
Warnings: |
| 50 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 51 |
include/wait_for_slave_sql_error.inc [errno=1142] |
| 52 |
STOP SLAVE; |
| 53 |
Warnings: |
| 54 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 55 |
GRANT UPDATE ON *.* TO 'a_bigger_username_just_for_test'; |
| 56 |
START SLAVE; |
| 57 |
Warnings: |
| 58 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 59 |
include/sync_slave_sql.inc |
| 60 |
REVOKE UPDATE ON *.* FROM 'a_bigger_username_just_for_test'; |
| 61 |
STOP SLAVE; |
| 62 |
Warnings: |
| 63 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 64 |
include/diff_tables.inc [master:t, slave:t] |
| 65 |
[connection slave] |
| 66 |
SET @binlog_row_value_options_save= @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS; |
| 67 |
SET @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS= PARTIAL_JSON; |
| 68 |
# |
| 69 |
# Running test for |
| 70 |
# GRANT UPDATE ON *.* TO ... |
| 71 |
# |
| 72 |
[connection master] |
| 73 |
UPDATE t SET c = 8 WHERE c = 12; |
| 74 |
include/save_master_pos.inc |
| 75 |
[connection slave] |
| 76 |
START SLAVE; |
| 77 |
Warnings: |
| 78 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 79 |
include/wait_for_slave_sql_error.inc [errno=1142] |
| 80 |
STOP SLAVE; |
| 81 |
Warnings: |
| 82 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 83 |
GRANT UPDATE ON *.* TO 'a_bigger_username_just_for_test'; |
| 84 |
START SLAVE; |
| 85 |
Warnings: |
| 86 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 87 |
include/sync_slave_sql.inc |
| 88 |
REVOKE UPDATE ON *.* FROM 'a_bigger_username_just_for_test'; |
| 89 |
STOP SLAVE; |
| 90 |
Warnings: |
| 91 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 92 |
SET @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS= @binlog_row_value_options_save; |
| 93 |
include/diff_tables.inc [master:t, slave:t] |
| 94 |
# |
| 95 |
# Running test for |
| 96 |
# GRANT DELETE ON *.* TO ... |
| 97 |
# |
| 98 |
[connection master] |
| 99 |
DELETE FROM t WHERE c = 8; |
| 100 |
include/save_master_pos.inc |
| 101 |
[connection slave] |
| 102 |
START SLAVE; |
| 103 |
Warnings: |
| 104 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 105 |
include/wait_for_slave_sql_error.inc [errno=1142] |
| 106 |
STOP SLAVE; |
| 107 |
Warnings: |
| 108 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 109 |
GRANT DELETE ON *.* TO 'a_bigger_username_just_for_test'; |
| 110 |
START SLAVE; |
| 111 |
Warnings: |
| 112 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 113 |
include/sync_slave_sql.inc |
| 114 |
REVOKE DELETE ON *.* FROM 'a_bigger_username_just_for_test'; |
| 115 |
STOP SLAVE; |
| 116 |
Warnings: |
| 117 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 118 |
include/diff_tables.inc [master:t, slave:t] |
| 119 |
# |
| 120 |
# Running test for |
| 121 |
# GRANT INSERT ON test.* TO ... |
| 122 |
# |
| 123 |
[connection master] |
| 124 |
INSERT INTO t VALUES(10, 10); |
| 125 |
include/save_master_pos.inc |
| 126 |
[connection slave] |
| 127 |
START SLAVE; |
| 128 |
Warnings: |
| 129 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 130 |
include/wait_for_slave_sql_error.inc [errno=1142] |
| 131 |
STOP SLAVE; |
| 132 |
Warnings: |
| 133 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 134 |
GRANT INSERT ON test.* TO 'a_bigger_username_just_for_test'; |
| 135 |
START SLAVE; |
| 136 |
Warnings: |
| 137 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 138 |
include/sync_slave_sql.inc |
| 139 |
REVOKE INSERT ON test.* FROM 'a_bigger_username_just_for_test'; |
| 140 |
STOP SLAVE; |
| 141 |
Warnings: |
| 142 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 143 |
include/diff_tables.inc [master:t, slave:t] |
| 144 |
# |
| 145 |
# Running test for |
| 146 |
# GRANT UPDATE ON test.* TO ... |
| 147 |
# |
| 148 |
[connection master] |
| 149 |
UPDATE t SET c = 12 WHERE c = 10; |
| 150 |
include/save_master_pos.inc |
| 151 |
[connection slave] |
| 152 |
START SLAVE; |
| 153 |
Warnings: |
| 154 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 155 |
include/wait_for_slave_sql_error.inc [errno=1142] |
| 156 |
STOP SLAVE; |
| 157 |
Warnings: |
| 158 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 159 |
GRANT UPDATE ON test.* TO 'a_bigger_username_just_for_test'; |
| 160 |
START SLAVE; |
| 161 |
Warnings: |
| 162 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 163 |
include/sync_slave_sql.inc |
| 164 |
REVOKE UPDATE ON test.* FROM 'a_bigger_username_just_for_test'; |
| 165 |
STOP SLAVE; |
| 166 |
Warnings: |
| 167 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 168 |
include/diff_tables.inc [master:t, slave:t] |
| 169 |
[connection slave] |
| 170 |
SET @binlog_row_value_options_save= @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS; |
| 171 |
SET @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS= PARTIAL_JSON; |
| 172 |
# |
| 173 |
# Running test for |
| 174 |
# GRANT UPDATE ON test.* TO ... |
| 175 |
# |
| 176 |
[connection master] |
| 177 |
UPDATE t SET c = 8 WHERE c = 12; |
| 178 |
include/save_master_pos.inc |
| 179 |
[connection slave] |
| 180 |
START SLAVE; |
| 181 |
Warnings: |
| 182 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 183 |
include/wait_for_slave_sql_error.inc [errno=1142] |
| 184 |
STOP SLAVE; |
| 185 |
Warnings: |
| 186 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 187 |
GRANT UPDATE ON test.* TO 'a_bigger_username_just_for_test'; |
| 188 |
START SLAVE; |
| 189 |
Warnings: |
| 190 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 191 |
include/sync_slave_sql.inc |
| 192 |
REVOKE UPDATE ON test.* FROM 'a_bigger_username_just_for_test'; |
| 193 |
STOP SLAVE; |
| 194 |
Warnings: |
| 195 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 196 |
SET @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS= @binlog_row_value_options_save; |
| 197 |
include/diff_tables.inc [master:t, slave:t] |
| 198 |
# |
| 199 |
# Running test for |
| 200 |
# GRANT DELETE ON test.* TO ... |
| 201 |
# |
| 202 |
[connection master] |
| 203 |
DELETE FROM t WHERE c = 8; |
| 204 |
include/save_master_pos.inc |
| 205 |
[connection slave] |
| 206 |
START SLAVE; |
| 207 |
Warnings: |
| 208 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 209 |
include/wait_for_slave_sql_error.inc [errno=1142] |
| 210 |
STOP SLAVE; |
| 211 |
Warnings: |
| 212 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 213 |
GRANT DELETE ON test.* TO 'a_bigger_username_just_for_test'; |
| 214 |
START SLAVE; |
| 215 |
Warnings: |
| 216 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 217 |
include/sync_slave_sql.inc |
| 218 |
REVOKE DELETE ON test.* FROM 'a_bigger_username_just_for_test'; |
| 219 |
STOP SLAVE; |
| 220 |
Warnings: |
| 221 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 222 |
include/diff_tables.inc [master:t, slave:t] |
| 223 |
# |
| 224 |
# Running test for |
| 225 |
# GRANT INSERT ON test.t TO ... |
| 226 |
# |
| 227 |
[connection master] |
| 228 |
INSERT INTO t VALUES(10, 10); |
| 229 |
include/save_master_pos.inc |
| 230 |
[connection slave] |
| 231 |
START SLAVE; |
| 232 |
Warnings: |
| 233 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 234 |
include/wait_for_slave_sql_error.inc [errno=1142] |
| 235 |
STOP SLAVE; |
| 236 |
Warnings: |
| 237 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 238 |
GRANT INSERT ON test.t TO 'a_bigger_username_just_for_test'; |
| 239 |
START SLAVE; |
| 240 |
Warnings: |
| 241 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 242 |
include/sync_slave_sql.inc |
| 243 |
REVOKE INSERT ON test.t FROM 'a_bigger_username_just_for_test'; |
| 244 |
STOP SLAVE; |
| 245 |
Warnings: |
| 246 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 247 |
include/diff_tables.inc [master:t, slave:t] |
| 248 |
# |
| 249 |
# Running test for |
| 250 |
# GRANT UPDATE ON test.t TO ... |
| 251 |
# |
| 252 |
[connection master] |
| 253 |
UPDATE t SET c = 12 WHERE c = 10; |
| 254 |
include/save_master_pos.inc |
| 255 |
[connection slave] |
| 256 |
START SLAVE; |
| 257 |
Warnings: |
| 258 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 259 |
include/wait_for_slave_sql_error.inc [errno=1142] |
| 260 |
STOP SLAVE; |
| 261 |
Warnings: |
| 262 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 263 |
GRANT UPDATE ON test.t TO 'a_bigger_username_just_for_test'; |
| 264 |
START SLAVE; |
| 265 |
Warnings: |
| 266 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 267 |
include/sync_slave_sql.inc |
| 268 |
REVOKE UPDATE ON test.t FROM 'a_bigger_username_just_for_test'; |
| 269 |
STOP SLAVE; |
| 270 |
Warnings: |
| 271 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 272 |
include/diff_tables.inc [master:t, slave:t] |
| 273 |
[connection slave] |
| 274 |
SET @binlog_row_value_options_save= @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS; |
| 275 |
SET @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS= PARTIAL_JSON; |
| 276 |
# |
| 277 |
# Running test for |
| 278 |
# GRANT UPDATE ON test.t TO ... |
| 279 |
# |
| 280 |
[connection master] |
| 281 |
UPDATE t SET c = 8 WHERE c = 12; |
| 282 |
include/save_master_pos.inc |
| 283 |
[connection slave] |
| 284 |
START SLAVE; |
| 285 |
Warnings: |
| 286 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 287 |
include/wait_for_slave_sql_error.inc [errno=1142] |
| 288 |
STOP SLAVE; |
| 289 |
Warnings: |
| 290 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 291 |
GRANT UPDATE ON test.t TO 'a_bigger_username_just_for_test'; |
| 292 |
START SLAVE; |
| 293 |
Warnings: |
| 294 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 295 |
include/sync_slave_sql.inc |
| 296 |
REVOKE UPDATE ON test.t FROM 'a_bigger_username_just_for_test'; |
| 297 |
STOP SLAVE; |
| 298 |
Warnings: |
| 299 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 300 |
SET @@GLOBAL.BINLOG_ROW_VALUE_OPTIONS= @binlog_row_value_options_save; |
| 301 |
include/diff_tables.inc [master:t, slave:t] |
| 302 |
# |
| 303 |
# Running test for |
| 304 |
# GRANT DELETE ON test.t TO ... |
| 305 |
# |
| 306 |
[connection master] |
| 307 |
DELETE FROM t WHERE c = 8; |
| 308 |
include/save_master_pos.inc |
| 309 |
[connection slave] |
| 310 |
START SLAVE; |
| 311 |
Warnings: |
| 312 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 313 |
include/wait_for_slave_sql_error.inc [errno=1142] |
| 314 |
STOP SLAVE; |
| 315 |
Warnings: |
| 316 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 317 |
GRANT DELETE ON test.t TO 'a_bigger_username_just_for_test'; |
| 318 |
START SLAVE; |
| 319 |
Warnings: |
| 320 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 321 |
include/sync_slave_sql.inc |
| 322 |
REVOKE DELETE ON test.t FROM 'a_bigger_username_just_for_test'; |
| 323 |
STOP SLAVE; |
| 324 |
Warnings: |
| 325 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 326 |
include/diff_tables.inc [master:t, slave:t] |
| 327 |
# |
| 328 |
# Running test for |
| 329 |
# GRANT INSERT(c, d) ON test.t TO ... |
| 330 |
# |
| 331 |
[connection master] |
| 332 |
INSERT INTO t VALUES(10, 10); |
| 333 |
include/save_master_pos.inc |
| 334 |
[connection slave] |
| 335 |
START SLAVE; |
| 336 |
Warnings: |
| 337 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 338 |
include/wait_for_slave_sql_error.inc [errno=1142] |
| 339 |
STOP SLAVE; |
| 340 |
Warnings: |
| 341 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 342 |
GRANT INSERT(c, d) ON test.t TO 'a_bigger_username_just_for_test'; |
| 343 |
START SLAVE; |
| 344 |
Warnings: |
| 345 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 346 |
include/sync_slave_sql.inc |
| 347 |
REVOKE INSERT(c, d) ON test.t FROM 'a_bigger_username_just_for_test'; |
| 348 |
STOP SLAVE; |
| 349 |
Warnings: |
| 350 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 351 |
include/diff_tables.inc [master:t, slave:t] |
| 352 |
# |
| 353 |
# Running test for |
| 354 |
# GRANT UPDATE(c) ON test.t TO ... |
| 355 |
# |
| 356 |
[connection master] |
| 357 |
UPDATE t SET c = 12 WHERE c = 10; |
| 358 |
include/save_master_pos.inc |
| 359 |
[connection slave] |
| 360 |
START SLAVE; |
| 361 |
Warnings: |
| 362 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 363 |
include/wait_for_slave_sql_error.inc [errno=1142] |
| 364 |
STOP SLAVE; |
| 365 |
Warnings: |
| 366 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 367 |
GRANT UPDATE(c) ON test.t TO 'a_bigger_username_just_for_test'; |
| 368 |
START SLAVE; |
| 369 |
Warnings: |
| 370 |
Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead |
| 371 |
include/sync_slave_sql.inc |
| 372 |
REVOKE UPDATE(c) ON test.t FROM 'a_bigger_username_just_for_test'; |
| 373 |
STOP SLAVE; |
| 374 |
Warnings: |
| 375 |
Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead |
| 376 |
include/diff_tables.inc [master:t, slave:t] |
| 377 |
DROP TABLE t; |
| 378 |
[connection master] |
| 379 |
DROP TABLE t; |
| 380 |
include/rpl_end.inc |